Creating Jasper Reports- Installation Guide
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.
Click on it, provide the information asked 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 the ireport toolbar. Add a new xml datasource by providing the of the xml file generated from the openerp client.
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.Change the query language to xpath.
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 reports.
Hi trung, Can dont get it.
Hi trung, Can dont get it. can you explain it.
Thanks for your reply. I
Thanks for your reply.
I Created Datasource by using Database JDBC connection instead of XML file datasource to connect openerp database and use SQL.
Instead Xpath i used SQL.
With Xpath, when send report to server, user filter some conditions and print report. The report will contain data which user filtered.
I want to ask: With Creating report via SQL method, how can report show data which user filterd before.
Hi, If we are using the
Hi,
If we are using the JDBC datasource, we have to do the filtering in using the SQL itself but we can specify the condition in which the filtering has to be done. For example if i want to display the lang of the partner which the user selects, we can pass the id of the partner that the user select to iReport using parameter. The parameter can be passed from the report python file as:
These parameters will be available in the iReport if we create a parameter in iReport as "partner_id" and can be used in our SQL query. So my query will be:
"SELECT lang FROM res_partner where id = $P{partner_id}"
if I want to display by
if I want to display by 'purchase_order.id' for parameter $ P {order_id} what the best solution?
example:
SELECT * FROM WHERE purchase_order purchase_order.id = $ P {order_id}
I ran into this error: Report
I ran into this error:
Report Error
Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: 459; cvc-complex-type.3.2.2: Attribute 'uuid' is not allowed to appear in element 'jasperReport'.
Any ideas??
View this:
View this: http://es.scribd.com/doc/76732576/NPG-Jasper-Reports-Guide-v1pt1 Good luck, again!
Hi againd, I found a
Hi againd, I found a permanent solution: You must check your JasperReports version. If you will use JasperReports x.y.z, you must have iReport x.y.z. I was using iReport 4.7.0 for JasperReports 4.0.1! :P You should download the files from: http://sourceforge.net/projects/ireport/files/iReport/iReport-4.0.1/ https://launchpad.net/openobject-client-kde/5.0/5.0.5/+download/jasper_r... The official project page for JasperReports OpenERP's OpenObject is: https://launchpad.net/openobject-jasper-reports/ (obviously to download you must clone the repository with bazaar) The former was: https://launchpad.net/openobject-client-kde Good luck!
Hi! I found a solution
Hi! I found a solution (temporal, I think). It's error is due to the parser, conflict of versions of JasperReports and iReport (I think :P). I don't exactly where is the problem but you can use Kate (or another decent text editor with regular expressions support) for open you *.jrxml file to find and replace using the regular expressions option: Find: \suuid=\".{36}\" Replace: It will clear you file of this conflictive attribute. My best regards!
Thank you Zorobabel
Thank you Zorobabel
You're welcome, Also do you
You're welcome, Also do you help me