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

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

Developer Notes:

1. The writer was originally available only inside of the ERP system, and the renderer was built into the backend as well. You may still notice legacy behavior associated with this.
2. The writer (OpenRPT binary) is similar in functionality to Crystal Reports or the Microsoft Access report writer.
3. The renderer (RPTrender binary) lets you take your report definitions (created with the OpenRPT writer) and process them against a database to create printed reports.
4. The renderer uses a simple scripting language called 'MetaSQL' which allows you to write more dynamic SQL queries.
5. There's certainly a great deal of work left to do, but we hope you'll agree we're off to a good start. Some things on our TODO list:

• Add support for columns
• Multi-lingual support
• Additional drawing primitives
• Additional supported databases
• Ability for OpenRPT to call RPTrender in order to test a report definition for proper results
• Auto read tables to create SQL and report definition objects
• Auto create SQL and MetaSQL
• Visually define table joins We welcome any and all constructive feedback on both the software and the documentation - with the understanding that both are still very rough.

Pricing
We offer developer support for the open source OpenRPT at a flat rate of $225/hour. Support is included under either of the commercial options described below.

There are two pricing options for an OpenRPT commercial license: A perpetual license for developer seats (with no runtime license cost for end-users), or a less expensive subscription offering for developers, with a modest runtime license that is passed along to the end-user.

Perpetual License

 Annual Subscription

The end-user runtime license starts at $50 per user, and is negotiable with volume. The susbcription prices below are for the developer seats only.

 Please contact us for more information.

Thanks very much for your interest and support. We look forward to working with you.