Online Class — Custom Reporting: SQL Report Writer for Open Source ERP
$345.00
SKU: TR-RPT
Learn how to make changes and create a custom report with OpenRPT, the open source report writer.
xTuple ERP: Open Source SQL Report Writer (OpenRPT)
This class includes a step-by-step demonstration of how to make cosmetic changes to existing OpenRPT reports and how to create a custom report. Participants will also learn how SQL and meta-SQL are used in OpenRPT to control data and filter options in a report definition.
Features of OpenRPT:
- Report definitions are saved in XML format, and support "grades" or versioning
- Stand-alone or embeddable WYSIWYG Report Designer
- Embeddable report renderer renders to local printers, including PDF and Postscript distillers
- Support for All/Even/Odd/First/Last Page Headers and Footers
- Support for multiple column detail sections
- Support for static and database sourced images
- Support for static and/or database sourced watermarks and page identifiers
- Support for multiple detail sections and optional, multiple group heads and footers for each detail section
Database Familiarization and Introduction to SQL and meta-SQL
- PG Admin — Views, Table, Procedures
- Meta-SQL Editor
Introduction to Report Writer and Making Cosmetic Changes
- Components — Capabilities, Structure, Making Changes
Adding a New Field to an Existing xTuple Report
- Change a Query
- Change the Report Layout
- Test
Credit Hours — Six (6)
Seats are available until filled.
Contact Sales for date of Next Class
Price: $345.00