RML:XML Reports in OpenERP

RML:XML Reports

In OpenERP you have the possibility to create RML:XML reports using the standard xml reporting engine.  RML reports don’t require too much programming but require two simple XML files to be written:
  • a file describing the data to export (*.xml)
  • a file containing the presentation rules to apply to that data (*.xsl)

The role of the XML template is to describe which fields of the resource have to be exported (by the server). The XSL:RML style sheet deals with the layout of the exported data as well as the “static text” of reports. Static text is referring to the text which is common to all reports of the same type (for example, the title of table columns).

RML File locations

The location of files on the OpenERP 7 (deb installation) are: 
  • /usr/lib/pymodules/python2.7/openerp/addons/<module name>/<reports>/<report name>.rml

for example the purchase order form is located:
  • /usr/lib/pymodules/python2.7/openerp/addons/purchase/report/order.rml
The files are similar to JavaScript code and with some experience can be edited directly. Alternatively use the OpenOffice / OpenLibre plugin