Online — Custom Reporting: SQL Report Writer

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.


  • 10:00 AM — 1:00 PM
  • 2:00 PM — 5: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
  • 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
  • xTuple reserves the right to cancel any online training with ten (10) days notice
Credit Hours
  • $345


Online — Custom Reporting: SQL Report Writer

Next Class — 2020 or on demand — 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 thirty (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 thirty (30) days of scheduled start date. For Online 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 twelve (12) months of receipt.