Geek Answers Handbook

What is the best way to create an OpenERP report

I am trying to create an OpenERP report. There are several methods to accomplish this task (openoffice plugin, XML files, RML files, etc.).

What is the fastest way to do this (and / or the most beautiful)?

+7
source share
7 answers

I used only RML files and I was pleased with the result. I have not tried the OpenOffice method, but it seems the transition from SXW to RML will be more difficult. When I edit the RML file, I just save it and click on the report button on the client to try. No compilation or conversion is required. OpenOffice may be useful if I want business users to make small changes to the reports, but I suspect that all the strange code to extract the data will confuse them.

I have not tried the XML report method, so I cannot comment on it.

I assume you saw the documentation when writing reports . I just noticed a section that talks about changing corporate default headers, and this seems to only be described for XML reporting. I did not look further, but this may be the reason for using XML instead of RML. I know that we would like to get rid of corporate headers for some internal documents.

+5
source

If you know html , then report webcams using mako . Webkit reports are very easy to create compared to rml.

+4
source

Web recruitment report is the easiest way to make a report, set up a webkit report

sudo apt-get install wkhtmltopdf

and install the report_webkit module in OpenERP, it will display a tab in the company, inside the company you can make a simple report using the OpenERP GUI,

for a preliminary report. You should learn the maco template,

Thanks..!!

+4
source

For simple reports, I prefer to use rml reports by first creating the sxw file and then converting it to rml using the script in the openerp base_report_designer module.

For a complex report, as well as to make the report more beautiful, I prefer to use the jasper_reports module. With iReport we can create beautiful reports. We can also use jdbc datasource, which can be connected to our database and pull data. Subreport can also be used with jasper_reports

There are also other reporting tools, such as aero-ad reports, using the xsl file, openoffice plugin, etc.

0
source

The jasper report can be used to create an OpenERP report using an SQL query.

0
source

This is how I showed in my post, which describes creating a report based on an SQL query in OpenERP 7. Please follow this link for more details. Hope this helps others.

http://sajjadhossain.com/2013/06/30/openerp-7-creating-report-using-sql-query/

0
source

The easiest, easiest and fastest way to edit, configure and create your own report is to edit .rml knowledge from experience so far

-one
source

More articles:


All Articles