Our Products

More Open Source

	OpenRPT report writer  PostgreSQL database  Pricing for all services

Our Community

	xTuple.org Home  Forums & Mail  Issue/Bug Tracker  Search xTuple.org  Downloads

Industry case studies

	Automotive aftermarket  Bearings and pulleys  Fresh/frozen foods  Garments (make to order)  Inks and ink technology  Pumps and valves   - View all case studies

Free Demo Download

	Please login: username: password:  ... or click here to register:   ... End Users   ... Solution Providers

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.

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

• 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

No. of users	Discount	Per-user license	Total license cost	Support @ 15%	Total Y1 cost
1	-	$1,500	$1,500	$225	$1,725
5	20%	$1,200	$6,000	$900	$6,900
10	40%	$900	$9,000	$1,350	$10,350
Unlimited	Really Big	-	$15,000	$2,250	$17,250

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.

No. of users	Discount	Per-user license	Total license cost
1	-	$300/year	$300/year
5	20%	$240/year	$1,200/year
10	40%	$180/year	$1,800/year
Unlimited	Really Big	-	$2,500/year

Please contact OpenRPT Commercial Sales for more information.

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