Access database structure from iReport
Quick summary
A new jasper_reports feature lets iReport access an OpenERP model’s field structure without requiring a manually created XML file. After installing the latest module version, users configure a remote XML file datasource with the XML-RPC URL, the «/jasper/» path and the model’s internal name; this feature is available in version 6.
Contents
We have recently added a new feature to jasper_reports module that allows users to have access to fields structure from iReport, avoiding the need of creating the XML file. Note that although the module works with both v5 and v6 this feature will only be available in v6.
Using this functionality is really easy. Simply install latest version of jasper_reports module and in iReport create a new remote XML file datasource. And in XML URL specify OpenERP's XML-RPC URL and append "/jasper/" and the internal name of the model we want to use (in the example "purchase.order").
After that we can add several parameters, but all of them are optional, because they can be specified in openerp's server configuration file and they also have default values. Here's a list of parameters available:
Frequently asked questions
What does the new jasper_reports feature provide in iReport?
It allows iReport to access the OpenERP model’s field structure directly, so the XML file no longer has to be created manually.
Which version includes this feature?
Although jasper_reports works with versions 5 and 6, this particular feature is available only in version 6.
How do you configure the datasource in iReport?
Create a «remote XML file datasource» and set «XML URL» to OpenERP’s XML-RPC URL followed by «/jasper/» and the model’s internal name.
Are the additional parameters mandatory?
No. They are all optional because they can be defined in the OpenERP server configuration and also have default values.
Related articles
ERP and Business
Creating Basic Reports with Basic Business Intelligence (BABI)
This article explains how to create and activate a basic Business Intelligence report from the templates supplied with BABI. It covers expressions, measures, dimensions, ordering and user groups, then shows how to refresh data, browse the tree view, create charts and apply filters.
Developer
jasper_reports for Windows
The jasper_reports module version available from Bazaar runs correctly on Windows and only requires Java to be installed. This stable version was planned for inclusion with Koo 5.0.3.
Developer
Translations and user information in Jasper Reports
The `jasper_reports` module adds a virtual User relation so reports can access information about the person running them, even when the document is not related to a company. It also supports designing and previewing translations in iReport with `i18ngroovy`, the required libraries and the `tr()` functions.
