Online — Custom Reporting: SQL Report Writer for Open Source ERP

Use OpenRPT — released under the GNU Lesser General Public License — as you wish

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.

Schedule

  • 9:00 AM — 12:00 PM
  • 1:00 PM — 4:00 PM

Note — This live, online training meets one (1) time with a mid-day break. You are expected to attend all sessions. Eastern Time (GMT-05:00-US & Canada).

Curriculum Overview

  • 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
Who Should Attend?
  • Implementation team leaders
  • Financial managers
  • Operations managers
  • Customers, partners
Additional Detail on Curriculum — what can you do after completing this course?
  • How SQL and meta-SQL are used in a report definition
  • Use OpenRPT for report-writing and make cosmetic changes to reports
  • Edit existing xTuple reports
  • Create a custom report in xTuple and deploy it
Instructional Method
  • Group-live online
Program Level
  • Basic
Prerequisites
  • None
Advanced Preparation
  • Download OpenRPT
  • Paid training helps user obtain full value of this open source product
  • Install PG Admin locally
  • xTuple (latest version) database installed and ensure PG Admin connection before first session
  • Review OpenRPT Product Guide
Recommended Follow-up
  • None
Field of Study
  • Specialized Knowledge and Applications
Cancellation
  • xTuple reserves the right to cancel any online training with ten (10) days notice
Credit Hours
Cost
  • $345

 

Online — Custom Reporting: SQL Report Writer for Open Source ERP

April 15, 2019 — Learn how to make changes and create a custom report with OpenRPT, the open source report writer. Credit Hours — Six (6)

Knowledge Management, Training Options

Training options vary from free online resources to paid in-classroom or live group events to specialized content designed for and delivered at your business location. Find out which is right for your staff needs.

Refund Policy and Cancellations

Requests for refunds for Live Classes must be received in writing at least 30 days prior to scheduled start date of training session. All cancellations will be subject to a $100 cancellation fee. No refunds will be granted within 30 days of scheduled start date. For Web-based Classes, all sales are final. No refunds will be granted for Group Internet Classes. Participants of canceled classes will be offered course credits which may be applied to future courses and must be redeemed within 12 months of receipt.