OPEN SOURCE - Job Scheduler - Solutions for Reporting
|
|
|
|
| |
| |
Reporting with JasperReports
| |
JasperReports (http://jasperreports.sourceforge.net) is an Open Source solution for business reports.
This solution stack automates report generation with database connections
by the Job Scheduler for calendar events, manual execution and API methods.
Why would you integrate the Job Scheduler with a reporting tool?
-
You could launch reports automatically at configurable calendar events.
-
You could add jobs to the processing of reports in a job chain:
before generating a report some preliminary jobs could prepare or aggregate data
and after generating the report subsequent jobs for output processing,
delivery by mail or printing could be started.
-
You could automatically monitor the processing of reports: the Job Scheduler
keeps track of log files and of the job history,
in case of errors
you will be notified by mail. You could integrate a solution stack
for Network Monitors to
which the Job Scheduler reports errors.
-
You could make the Job Scheduler automatically react to errors from individual successor jobs.
Download
Job implementations for this stack are not included in the Job Scheduler distribution because of legal considerations.
However, you can download them from the
sos.stacks.jar
and sos.documentfactory.jar archives.
The source code of these jobs is given below.
Configuration
The configuration in
config/scheduler_jasperreports.xml
could be included by adding <base file="scheduler_jasperreports.xml"/> to the
scheduler.xml configuration file.
Use the Job Scheduler's own visual Job Configuration Editor
to adjust the configuration.
Implementation
For standalone jobs and asynchronous Web Service requests the following jobs are used:
- Job: Create Report (jasper_report)
This job creates a report from a compiled JasperReports configuration and
is used as a template for standalone jobs.
This job supports the report formats PDF, HTML, RTF, XML and XLS.
The report configuration file, report format and output filename are given as job parameters,
see the job documentation for details.
Show Job Documentation
Show Job Source Code
- Job: Create Report for Job History (jasper_report_scheduler_job_history)
This job uses the same implementation as the jasper_report job above
with sample job parameters for generating a history report of the jobs executed by the Job Scheduler:
-
Parameter
report_filename
-
Parameter
query_filename
Due to the differences in the SQL language implemented by different database systems
you have to choose the appropriate query file:
- Job: Create Report for Order History (jasper_report_scheduler_order_history)
This job uses the same implementation as the jasper_report job above
with sample job parameters for generating a history report for the orders executed by the Job Scheduler:
-
Parameter
report_filename
-
Parameter
query_filename
Due to the differences in the SQL language implemented by different database systems
you have to choose the appropriate query file:
For orders and synchronous Web Service requests the following configuration is used:
- Job: Create Report from Orders (jasper_report_service)
This job uses the same implementation as the above job jasper_report
but is used to process orders.
The report configuration file, report type and output file name are given as order parameters -
see the job documentation for details.
Show Job Documentation
Show Job Source Code
|
|
|
|
| |
| |
Office Automation - Document Delivery - Job Scheduling - Systems Integration - Output Management - Enterprise Application Integration - Connectivity |
|
