What's the best way to create a report on OpenERP

I t开发者_C百科ry to create a report on OpenERP. There is several methods to do this task (openoffice plugin, XML files, RML files, etc.)

What's the quickest way to do that (and/or the most beautiful) ?

I've only used the RML files and I've been happy with the result. I haven't tried the OpenOffice method, but it seems like the conversion step from SXW to RML would be more hassle. When I edit an RML file, I just save it and click on the report button in the client to try it out. No compilation or conversion necessary. OpenOffice might be useful if I wanted to let business users make minor changes to reports, but I suspect that all the weird data extraction code would confuse them.

I haven't tried the XML report technique, so I can't comment on it.

I assume you've seen the documentation on writing reports. I just noticed a section that talks about changing the corporate default headers, and it only seems to be described for XML reports. I haven't looked any further, but that might be a reason to use XML instead of RML. I know we would like to get rid of the corporate headers for some internal documents.

Web kit Report is the easiest way to make a Report, to install webkit report

sudo apt-get install wkhtmltopdf

and install report_webkit module in OpenERP, it will show the tab in the company, within company you can make simple report using OpenERP GUI,

for Advance report You must learn the maco template,

Thanks..!!

If you know html then webkit report using mako. Webkit reports are very easy to create compare to rml.

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

For complex report and also for making the report more beautiful, I prefer to use jasper_reports module. With the help of iReport we can generate beautiful reports. We can also use jdbc datasource which can be connect to our database and pull the data. Subreport is also possible using jasper_reports

There are also other reporting tools like aeroo reports,using xsl file, openoffice plugin etc.

jasper report can be used to create OpenERP report using sql query.

Here is a way I have shown in my post which describes creating a report based on SQL query in OpenERP 7. Please follow this link for the details. Hope this will help others.

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

the most easiest and simple and quickest way to edit,customize and create your own report is editing the .rml files knowledge from experience so far