India

ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd
61/3236, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254

  UAE

Zesty Labs
Office # 2003, Millennium Plaza Building
Sheikh Zayed Rd, Dubai, UAE
Phone: +971 4333 2222​
Mobile: +971-52-7553466

  Germany​

ZestyBeanz Technologies GmbH
Reuterstraße 1
90408 Nürnberg
Fon: +49 911 4801 444
Fax: +49 911 4801 445

Creating Jasper Reports- Installation Guide

Contact Form


omalbastin's picture

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.

omalbastin's picture

Hi trung, Can dont get it.

Hi trung, Can dont get it. can you explain it.

trung's picture

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.

Prajul P T's picture

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}"

ibrahim's picture

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}

Marc's picture

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??

Zorobabel's picture

View this:

Zorobabel's picture

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!

Zorobabel's picture

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!

omalbastin's picture

Thank you Zorobabel

Thank you Zorobabel

Zorobabel's picture

You're welcome, Also do you

You're welcome, Also do you help me