Skip to Content

Jasper Reports

by ,
Odoo
v 14.0 Third Party 5925
Download for v 14.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Invoicing (account)
Community Apps Dependencies
Lines of code 1774
Technical Name jasper_reports
LicenseAGPL-3
Websitehttp://www.nan-tic.com, http://www.serpentcs.com
Versions 8.0 10.0 11.0 12.0 14.0 15.0 16.0 17.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Invoicing (account)
Community Apps Dependencies
Lines of code 1774
Technical Name jasper_reports
LicenseAGPL-3
Websitehttp://www.nan-tic.com, http://www.serpentcs.com
Versions 8.0 10.0 11.0 12.0 14.0 15.0 16.0 17.0

Jasper Report

This Module Gives The Features for creating Jasper Reports

Configure Java path

In your Odoo web interface, under the Company Data -> Jasper Configuration, add java path.

Jasper Report Menu

In your Odoo web interface, under the Technical section, jasper reports menu is there.

Jasper Data Template

From your Jasper Menu, Create a jasper reports data template file.

Design Jasper Report

In Jasper Studio, import the .xml file which was generated from Odoo and design your Jasper Report as .jrxml.

Create Jasper Report

Create a jasper reports for your module with your .jrxml file.

Demo reports can be founded in jasper_reports/demo folder.

Print Jasper Report

Example Of Jasper Report

Jasper Report 'uuid' error

Error:

"Attribute 'uuid' is not allowed to appear in element 'jasperReport'."


Solution:

Solution 1: Open the .jrxml file created and remove uuid attributes.
Solution 2: Go to the Jasper Studio --> 'Window' --> 'Preferences'
Jasper Studio --> Compatibility --> In the drop down select/apply 'JasperReports 3.5.1'

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
by
Mihai Pop
on 11/29/22, 7:57 AM

Hi Jay and thank you for getting back to me. I am busy trying to downgrade it to v13 from v14. I got stuck on two things. Perhaps you could assist: 

1. in the main.py controller the line 123 is complaining. Actually it complains about the "import time" portion. Is there a lib I am supposed to install for that?

2. After removing that, I got this error: 

    File "/home/erpsys/erp/system/odoo/sql_db.py", line 250, in execute
    res = self._obj.execute(query, params)
    psycopg2.ProgrammingError: can't adapt type 'dict'

    So I am assuming I need to do something like this: 

    df['bets'] = list(map(lambda x: json.dumps(x), df['bets']))

    But I am unsure where that occurs. The normal Jasper Load extension loaded. 


Would you be kind to guide where I could look into?


Thanks a mil...

Re:
by
Jay Vora - SerpentCS
on 12/1/22, 7:38 AM Author

Mihai,

1. The 'import time' is a standard one, it should work, its a usage in official odoo too :

https://github.com/odoo/odoo/blob/16.0/addons/web/controllers/report.py#L132

Please make sure you use latest code of v13.

But v13 would not work with safe_eval.time().. so follow https://github.com/JayVora-SerpentCS/Jasperreports_odoo/blob/12.0/jasper_reports/controllers/main.py#L67

2. You will not get the error if you fix 1.

by
Mihai Pop
on 11/18/22, 8:50 AM

Hello awesome people... I have a few questions about this module:

1. Does this need the whole Jasper Server stack (tomcat, etc?). Or can we use the JasperStarter Library from here: https://sourceforge.net/projects/jasperstarter/

2. Does this support sub-reports?

3. Does this plug into the Odoo Report module? What I mean by that: When I click "confirm" on a Sale Order, will it be possible that the email template uses Jasper Report instead of the normal QWeb ones?

4. When we run the report, can we add parameters which will pop-up like a form where they can choose options? Things like - choose start-date and end-date or a checkox or whatever? Which will then be passed to the report when running it?

5. Where is the version for Odoo13? I see you skipped this one! Could I use the v14 and work it backwards or do you happen to have it?


Thanks you guys! Have an awesome day!

Re:
by
Jay Vora - SerpentCS
on 11/29/22, 12:32 AM Author

Mihai,

Sorry for the late response.

1. It needs jasper server libs, not the whole stack. https://github.com/JayVora-SerpentCS/Jasperreports_odoo/wiki/Documentation

2. It does.

3. Yes it should be possible. 

4. Yes you can add parameters.

5. You may make backward compatible.

Thanks,

by
Samuel
on 10/26/22, 11:06 AM

Please help us resolve this error on Community V14:

com.nantic.jasperreports.JasperServer: Could not initialize class groovy.lang.GroovySystem'>


by
Agilis Group
on 9/28/22, 11:35 AM

Can you upgrade it please to V15?

Re:
by
Jay Vora - SerpentCS
on 9/30/22, 4:15 AM Author


by
Agilis Group
on 9/28/22, 11:34 AM

Hello!

Good Day,

What will it take to have a Jasper Report for v15?

Re:
by
Jay Vora - SerpentCS
on 10/6/22, 4:23 AM Author

Hello Agilis,

We started working and publish it soon.
Please email at contact@serpentcs.com will update you via mail also

Thanks.

by
Naun Flores
on 7/19/22, 8:21 PM


Good morning, what can I do to solve this error?

Report Error <Fault 0: 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: java.lang.ClassNotFoundException: '>

Re:
by
Jay Vora - SerpentCS
on 7/20/22, 2:50 AM Author

Hello Naun Flores,

Kindly mail us your in detail query at support@serpentcs.com so it will be easier for us to understand and help you out accordingly

Thanks.

hello please upgrade it to 15
by
mohamed ali
on 3/16/22, 6:58 PM

thank you 

please upgrade it to 15

Re: hello please upgrade it to 15
by
Jay Vora - SerpentCS
on 3/17/22, 1:28 AM Author

Sure!