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.