Report Generating Tool

Aim:

Our goal was to develop a web portal for generating and editing report for any database with a user-friendly interface and which has various interactive features like select only required fields, generating various types of graph for that particular report, formatting the style color, font etc for rows and cell of report.

Client Profile:

Our client approached us with the development of a highly feature rich and interactive tool that would enable to user to attach any database to this tool. After attachment user can select the relevant tables and field to generating the report. If user wants to see the graph then they can easily select various types of graph like Pie graph, Line graph, Trend Graph, Bar Graph, Funnel Graph, Plot Graph. User can also summarized, filter and make group for the report. User can also set the formatting style color, font, border, cell color etc. Report could be generated in word, excel and pdf format. They can easily view the print preview, set the pagination style, save the report and print the report.

Objectives:

Some of the objectives that our development team had to achieve were:

  • Design and develop highly effective data base management system for the website
  • Design a user-friendly interface
  • Segregated group option for the users on the basis of field, yearly, monthly etc
  • Invoices and payments
  • An advanced administration panel for easy management
  • Interactive website with multiples tools like save, save as, report list, print, word, excel, pdf, settings
  • Member engagement through forums

Solution:

The website developed by our web developers provided a common platform for any company to generate a report. This tool that would enable to user to attach any database to this tool. After attachment user can select the relevant tables and field to generating the report. If user wants to see the graph then they can easily select various types of graph like Pie graph, Line graph, Trend Graph, Bar Graph, Funnel Graph, Plot Graph. User can also summarized, filter and make group for the report. User can also set the formatting style color, font, border, cell color etc. Report could be generated in word, excel and pdf format. They can easily view the print preview, set the pagination style, save the report and print the report.

Technical Background:

  • Front End: ASP.NET, HTML, AJAX and Javascript
  • Back End: MySQL
  • Business Logic: C#