Reporting Tool is a system for generating reports with Web-based interface. Process of report generation is regarded as a sequence of the following steps: selecting data essential for a report thus obtaining so-called DataSpace, data processing (e.g. calculations for financial statements or summarization of inquiry data), and generating disposable reports. The system is built in such a way that DataSpace, processing and generating functions are plugged in as external modules thus enabling to add new reports without reprogramming the system itself. Generated reports are stored in Oracle database.
Functionally the project includes the following components:
- ApplicationServer contains special workflow providing report management functions, facilities for accessing database, transmitting data between separate modules, report scheduler allowing to generate necessary reports with specified intervals or by certain dates or hours, and also functions for generating reports in the form of HTML, XML, or MS Excel tables. ApplicationServer is written in Visual C++ using ODBC and COM technologies.
- Web-based interface is designed for interactive system management (new reports generation, specifying report parameters, viewing results, etc.). This component is implemented in PHP4 using Apache Web server. Its interface looks like a usual Windows program. As the system contains thousands of reports, there was created a subsystem for automatical categorization and sorting reports depending on their properties.
- Customer specific functions are implemented as a set of external modules for preparing and processing data and generating statistical reports for marketing researches.
Databases: Oracle 8.1.7
Web server: Apache 1.3.14
Technologies: OLE, VBA, OCI, ODBC, CGI
OS: Windows NT/2000, RedHat Linux