India

ZestyBeanz Technologies Pvt Ltd Thejaswini, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

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

  UAE

ZestyBeanz Technologies FZE, P.O Box 53261, HFZA, Sharjah, Phone: +971-56-2708993​

  Germany​

ZestyBeanz Technologies UG Fürther Str. 27 90429 Nürnberg Phone: +49-911-28707070

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.

ibrahim's picture

I am trying to create a

I am trying to create a report from iReport, but there is a warning error:
File "/opt/OpenObject/OpenERP/addons/addons_6.1/jasper_reports/JasperReports/JasperServer.py", line 100, in execute
raise osv.except_osv(_('Report Error'), e.faultString)
except_osv: ('Report Error', 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null')
2013-06-11 07:03:06,857 8366 ERROR ? openerp.netsvc: Report Error
Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null

anyone know a solution this problem?

omalbastin's picture

Hi, Please install/update

Hi,
Please install/update java jdk package in your system. Also please check the  versions of  iReport you use to create jasper report and the jasper_report jar package is same. If problem exits try by deleting the *.jasper file from your custom jasper report module.

ibrahim's picture

Hi omalbastin, I tried other

Hi omalbastin,
I tried other versions of iReport and in the beginning of the trial reports can be printed, but if there is an improvement in jrxml file then the error alert appear again:
Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null

ibrahim's picture

Hi, thank you for your

Hi, thank you for your comment.
I've updated java jdk package. Now I use iReport version 5.1.0 and JasperReports Server CP 5.1.0, but after trying again the result remains the same, there is the same error warning.
except_osv: ('Report Error', 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null')
2013-06-11 14:28:42,088 2893 ERROR ? openerp.netsvc: Report Error
Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null

Prajul P T's picture

Hi,     Inside your

Hi,

    Inside your jasper_reports module go to folder java -> lib. Please check weather there is a jar called jasperreports-5.1.0.jar. If not please update the library using the file update-jasper-reports.sh inside the same folder. Command format for updating is:

python update-jasper-reports.sh <path to your iReport 5.1.0>

ibrahim's picture

Hi Prajul, I run the

Hi Prajul,
I run the command:
python update-jasper-reports.sh /opt/iReport-5.1.0/
there is an error warning :
File "update-jasper-reports.sh", line 3
if [ -z "$1" ]; then
^
SyntaxError: invalid syntax

Which command should be run?
python update-jasper-reports.sh
or
./update-jasper-reports.sh

Prajul P T's picture

Hi,     Please run

Hi,

    Please run as ./update-jasper-reports.sh. 

ibrahim's picture

warning error persists, ERROR

warning error persists,
ERROR ? openerp.service.web_services: Exception: ('Report Error', 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null')

is there any other suggestions?

trip from LA to Vegas's picture

This is a topic that's close

This is a topic that's close to my heart... Take care! Exactly where are your contact details though?

trung's picture

hi omalbastin, i created a

hi omalbastin,
i created a report using sql method.
How can i import dynamic parameters in report.
parameters depend on search, filters.. on openrep.
This is possible?
Any suggestion?
Thanks