Jasper Reports are mainly used for creating stylish reports other than black and white report. We can add tables, charts,crosstabs etc., in to the jasper report and also we can generate different forms of reports like pdf,xls,html etc. For creating Jasper Report, iReport plays an important role. Using ireport we can simply create Jasper Report. I'm using iReport 4.0.1.
Jasper report and openERP integration can be done by adding jasper_reports module to our openERP server. Now Open the opneERP client. In customization menu under the administration menu we can find the a menu for creating jasper report template.
Pop-up window opened for creating data template |
Click on it, provide the model name and depth and then click create. Then an xml file wil be generated. This file is needed for the creating Jasper report. Save the file. For now our work in the openERP client is completed. Now go to iReport open a newblank report template. Change the datasource or create new datasource by clicking on in iReport toolbar. Add a new xml datasource and providing the path of xml file generated from the openerp client.
xml data source configuring |
After creating the xml datasource change the query language by clicking on
in the iReport designer bar. Then a window will open for changing the query language.
window for changing query language |
These are the basic things to be done for creating a jasper report. Now we can create a module in our openerp server and start creating jasper report.
Hi how do you print a report for a range of dates. i.e. using parameters
ReplyDeleteHi,
ReplyDeleteYou have to create a wizard with start and end date, then pass this information to the jasperDataParser.Now define these date fields as parameter in the jrxml file.Thats it..!
how can i generate report from wizard using xpath method?
ReplyDeletewould you provide steps, i am stack in xpath report generation from wizard filter by wizard paramerts
ReplyDeletehttp://www.zbeanztech.com/blog/creating-jasper-report-using-osvmemory-openerp-6
Deletethis is my company blog. it has a sample wizard module attached with it. it will be helpful for you