Custom Reporting:
SQL Report Writer

Next Class — 2020 or on demand

Contact Training

About the Class

Learn how to make changes and create a custom report with OpenRPT, the SQL-based report writer included with xTuple.


Note — This live, online training meets one (1) time with a mid-day break. You are expected to attend all sessions.

Course Schedule

Session 1
Session 2

Course Details

  • Implementation team leaders
  • Financial managers
  • Operations managers
  • Customers, partners
  • Features of OpenRPT
  • Database Familiarization and Introduction to SQL and meta-SQL
    • Views
    • Table
    • Procedures
  • Introduction to Report Writer and Making Cosmetic Changes
    • Capabilities
    • Structure
    • Making Changes
  • Adding a New Field to an Existing xTuple Report
    • Change a Query
    • Change the Report Layout
    • Test
Additional Detail on Curriculum — after completing this course you can:
  • Understand 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

Group-live online


  • Download OpenRPT
  • Install PG Admin locally
  • xTuple (latest version) database installed and ensure PG Admin connection before first session
  • Review OpenRPT Product Guide

Specialized Knowledge and Applications

Six (6)


Contact Training

Refund Policy & 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.

Training Options & Earning Credits

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

Every annual Support Contract includes — at no additional cost — an allowance of Training Credits to be used for any regularly scheduled xTuple training offering. For every $200 spent, earn one (1) Training Credit hour. Example: Spend $3600/year earns a free ticket to the 18-hour online ERP Basics class.

Featured Events 

5 Pain Points of Choosing (and Implementing) ERP

Learn how your company can avoid the major pitfalls of choosing an ERP and learn realistic ways to compare ERP solutions.


Learn More

News Center