Web Reporter Architecture

Web-Reporter is used to create Graphical repesentation of the data from the database. This is reporting tool which is useful for quickly and easily building interactive reports from data sources.

Web Reporter is developed using the Zend framework. It comprises of following important aspects.

Zend Framework  – Zend framework is used to develop this application in the faster development methodology. Zend Framework is implemented using 100% object-oriented code. As this framework has many in-built components like authentication, cache, date, form, mail etc. which reduce the time for the development of web applcation.

Open Flash Chart 2 – Open Flash Chart is open source utility that can be used to generate the charts from the data available.When the user downloads the web page, Open Flash Chart requests the chart data from the server. There are useful features like tooltips which encourage user interactivity and data exploration.

It uses the power of MVC architecture from Zend and latest open flash chart to generate the graphical representation. User can view those interms of charts as well as interms of tabular format.

System Architecture of Web-Reporter

Modular Architecture of Web-Reporter

Layered Architecture of Web-Reporter

It basically uses three main modules Profiles, Users and Create Reports.

Profile Module :

This module is used to store the data of the specific database server. Which can be used to connect the database using the login credentials of database user. It has main functionalities as follows:

A. Add/edit/delete: profiles which can only be done by administrator.

B. Assign Profile: This module also has functionality to assign specific profile for the selected user so that user can acess the reports for that profile.

User Module :

This module is used to store the user information. This module also allows user to view instances or reports created and assigned by administrator to specific profile.

Create Report :

This is the main module which is used to generate the reports for selected profile. It has many functionalities which are as follows :

A. Select profile- This functionality allows administrator to select the database server to which user can connect and generate the reports.

B. Select Database – It allows user to select the database from the all databases which are populated from the specific database server.It is basically used to generate the SQL query that can be used as base for generating the reports. It uses combination of JQUERY and AJAX to populate this database.

C. Expression – This allows administrator to add an expression which can be applied on the previously selected SQL query. The expression can be MAX, MIN, AVG etc for the selected fields from the table.

Add Filter – This functionality allows administrator to add specific filters with conditions such as NOT NULL, NULL etc. It restricts the output of the report to make the output specific.

E. Add Clauses – This additional functionality adds more refined output by using the GROUP BY / ORDER BY clause to specific field from selected tables.

F. Variable Filter – It allows administrator to filter the output of the web-report by specifying the datatype or element type of the selected fields.

G. Display – This functionality allows administrator to select the output chart type, values on x-axis, values on y-axis for the report.

H. Report Display – It allows administrator to save the output of the generated report, where user can run the instance and checkout the output of the reports.

I. Final Report – This functionality allows user to save the generated output from the selected fields also allows user to run the instances for the reports.