Custom Reports

>>> README <<<
Version 7.2+ stores all date/times in Coordinated Universal Time, better known as UTC. As part of the upgrade process all data gets converted to UTC. Therefore, the initial upgrade process could run an extended amount of time while the data is converted. Furthermore, any custom reports that go directly to the database to gather date/times will need to be modified to convert the time from UTC to the time zone desired.

>>> README <<<

Version 7.2+ stores all date/times in Coordinated Universal Time, better known as UTC. As part of the upgrade process all data gets converted to UTC. Therefore, the initial upgrade process could run an extended amount of time while the data is converted. Furthermore, any custom reports that go directly to the database to gather date/times will need to be modified to convert the time from UTC to the time zone desired.

The Custom Report module is an add-on feature used to create custom reports using JETT (Java Excel Template Translator) or BIRT (Business Intelligence and Reporting Tools); both use Microsoft Excel functionality.

Using JETT, Report Data Source templates provide the structure, layout, and styling of the resultant spreadsheet or you may create an Excel template of your own using any of the canned report data source templates available except the Assignment, or Multiday report.

Using BIRT an open source platform, based on Eclipse for designing and generating reports, you may create or modify reports using the data source and data sets available in the canned reports including the Assignment, and Multiday report. Additionally, BIRT allows users to apply new or change the preset data source Limits on the custom report from the Reports area. For example, if the BIRT report contains West region and Shift 1 as the preset limit, the user can change or add more regions or shifts by simply editing the Limit By setting of the data source provided.

The Custom Report module allows customers to create custom reports using the familiar environment of Microsoft Excel a registered trademark of Microsoft Corporation. This add-on feature allows both Excel novice users and advanced programmers to create simple custom reports, for example using JETT you can increase the font size on any report, perform aggregate operations, use pivot tables, combine multiple reports to create one report, omit data columns, add column data from one report to another, add headers, create borders, and more. Same features available using the BIRT designer, plus cross tab reports and more.

To obtain more information regarding JETT reporting functionality visit: http://jett.sourceforge.net
To obtain more information regarding BIRT reporting functionality visit: http://www.eclipse.org/birt/

Note: Custom Reports use JETT (Java Excel Template Translator) which allows the creation of spreadsheet reports using Excel spreadsheet templates, and Birt which allows the creation of reports using the predefined templates or a blank report design. Some programming knowledge may be needed to produce more advanced custom reports. Customers must be licensed for Custom Reports to access this feature. Custom report writing add-on services are also available.