As part of all three xTuple ERP Editions, built with the PostgreSQL database and the Qt GUI client framework, we built our own SQL report writer from scratch. Like the ERP, it runs equally well on Windows, Linux, and Mac OS X. We call it OpenRPT.

 OpenRPT Features

• Report Definitions are saved in the industry standard XML format
• 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 

Web Site
Download