Excel reporters
The absoco Excel Reporter is a powerful reporting tool for generating and distributing reports in MS Excel format.
The Excel Reporter reads data from your database and creates reports based on templates. These are sent by e-mail if desired or simply stored in the network.
Once set up, this all happens automatically in the background without user intervention.
Data sources: Excel Reporter reports can be created from any database content. The following databases can serve as data sources:
-
IBM System i (AS/400)
-
Oracle
-
MySQL
-
MS SQL Server
-
Apache Derby / Java DB
-
...and other relational databases.
In addition, Excel Reporter can, if desired:
-
Run SQL scripts or CL programs before generating reports
-
Insert timestamps into reports and emails
-
Form row groups (summary view)
-
Pack and encrypt reports