Now this looks like it might be rather an interesting extension to the capabilities of OpenOffice.org, it appears Sun and Pentaho are planning to integrate the business reporting engine from Pentaho into OpenOffice.org 2.3, tentatively due for September this year.
With the integration of Pentaho’s reporting engine and the new OpenOffice.org Report Designer, developed by Sun, OpenOffice.org users will be able to create reports with content from the OpenOffice.org Base database as well as a wide range of proprietary and open source relational databases, OLAP and XML sources. For example, users will be able to generate customer invoices by creating a customer invoice template and then pulling customer names, addresses, and current due balances from an accounts receivable application or database. They can then produce the invoices as OpenOffice.org Writer documents.
Given that this is only at the thinking about stage at the moment there’s precious little real information asides many rewordings of the press release (including this), the best real information I could find was from Ocke Janssen’s blog at Sun which has real information, including a couple of very early screenshots!
The new report designer will extend the database application. You then have the possibility to create reports not only with the famous wizard, but also manually. As output format you have the choice between text documents or spreadsheets. (OASIS Open Document Format). The designer uses the classical way of presenting reports. To navigate through the components of your report, you’ll have a navigator as you for sure already know from forms. Each repeating section of the report has its own area where text can be inserted. In the first release you’ll be able to create groups (with header and footer), functions, page header/footer, report header/footer. The best way to find all features is to try it when a stable version is available;-)
Must. Have. Patience! 🙂