ASPX Report Engine

Integral Accounting Enterprise also includes a dynamic report generator that we call the ASPX Report Engine. This reports engine builds a report dynamically based upon a pre-defined stored procedure in the database back-end. This works as follows:

1) The user selects a report from the menu, and presses the "Get Criteria and Parameters" button.

2) If the report has parameters, the parameter table will be populated and the user can enter the information that the report needs to run. 

3) The user can now select one of the three displaying options at the bottom of the window:

A) Screen - This will display the report on the screen in a browse-able data grid that supports sorting on any of the fields and paging through large amounts of data.

B) Printer - This will display the report in a format suitable for printing.

C) Excel - This will export the contents of the report directly into excel and load excel so you can work with the results immediately. Once in Excel, you can emancipate the data, export it to various formats, make charts and graphs, and save it separately. You need to have Microsoft Office 2000 or greater for this function to properly work.

D) You can also export the results to a text or xml file, and chart the results if they are numeric.

The Integral Accounting Enterprise system already includes over a hundred standard reports in ASPX Reports Engine format ready to run out of the box. Anyone that can understand simple stored procedures can customize and / or build new stored procedure report formats for use with the reports engine.