We are pleased to announce the general source code availability for the OpenRPT graphical report writer and rendering engine - the first fully cross-platform SQL report writer.
OpenMFG, LLC is a company who markets a multiplatform ERP system for small to midsized manufacturing and distribution companies. You can read more about OpenMFG at www.openmfg.com. As part of our ERP, which is built with the PostgreSQL database and the Qt GUI client framework, we built our own 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 General Public License. Please note: If you are a software or hardware OEM, and do not wish to be bound by the terms of the GPL, please contact OpenMFG sales to discuss a commercial license. This "dual license" approach allows us to provide OpenRPT for free to anyone without trying to second-guess your business objectives; it is your decision whether you wish to "opt out" of the GPL by purchasing a commercial license.
Thanks for your interest! - Ned Lilly (Project Admin), nedlilly at users.sourceforge.net
1) Up until very recently, the writer was available only inside of the ERP system, and the renderer was built into the backend as well. You will probably 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:
We welcome any and all constructive feedback on both the software and the documentation - with the understanding that both are still very rough. Our goal is to make it especially useful for PostgreSQL users, as we're big fans of The World's Most Advanced Open Source Database - but we'll want it to be serviceable for those who want to use, ahem, other DBs as well.
Thanks very much for your interest and support. We look forward to working with you.