Site logo
OpenRPT
Free Open Source SQL Report Writer
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.
Download OpenRPT from our SourceForge project site. OpenRPT is released under the GNU Lesser General Public License. You are free to use it as you wish; if you would like to purchase commercial support or embedded licenses, please see below.

 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 

Formats Supported
  • Bar Code Formats
  • Code 3of9
  • Code 3of9 Extended
  • Code 128
  • UPC-A
  • UPC-E
  • EAN-8
  • EAN-13
  • Support for Avery Standard Labels
  • Support for portrait or landscape, Letter, Legal and A4 documents

Platforms Supported
  • Operating Systems:
  • Windows 98/ME/NT/2K/XP
  • Linux
  • Mac OS X
  • xBSD
  • Solaris
  • AIX
  • HPUX
  • Databases (right now):
  • PostgreSQL
  • Generic ODBC connections
  • Oracle
  • With a little work:
  • DB2
  • SQL Server
  • MySQL 

Screenshots

openreports_screen_windows

Editing a barcode in a Packing List form, in Windows XP (above) and Linux (below).

openreports_screen_linux
!-- Start of StatCounter Code -->