Thursday, 3 May 2012

Jasper Report in OpenERP

Hello Friends ,
     You all about to search "How to create Report attractive in OpenERP" or "How to vreate Jasper Report in OpenERP".
I hope this blog will helpful to you all.

 Step 1 : 
                    Download  (jasper_reports.zip (40mb))
                    also download from  http://apps.openerp.com/addon/get_module_as_zip/6987/jasper_reports.zip
Step 2 :
                   To install this module you have to unzip the jasper_reports.zip because of the size of the module( approx.  
                   50Mb) 
                   it is difficult to import this zip file. 
                   So unzip the module to your openerp addons folder, then restart the server and update the module
                   list,
                   install the jasper report module.Thats it!!

 Step 3 : 
                  Download ireport from Click Me!!! To Download
Step 4 :
                 Install Jasper Report in Your OpenERP.
Step 5 :  
                 create Data Template from
                ->setting > customization > jasper > jasper data template
                















               


Posted by at
Labels: , , , , , , , ,

32 comments:

  1. gl81818 February 2013 at 00:56

    I wonder will that work for OpenERP version 7

    ReplyDelete
  2. http://pinakinnayi.blogspot.com/18 February 2013 at 01:17

    Ohh.. May be not compatible to version 7.

    ReplyDelete
  3. Unknown26 February 2013 at 23:09

    hi Pinakin thanks for your post but still i am facing problem

    ReplyDelete
  4. http://pinakinnayi.blogspot.com/27 February 2013 at 03:55

    Can you please tell me at which point you are facing problem.

    ReplyDelete
  5. Unknown3 September 2013 at 05:16

    my jasper module not shown under openerp module list . I restarted the openerp server and update the modules, but can't see the jasper module.

    ReplyDelete
    Replies
    1. http://pinakinnayi.blogspot.com/3 September 2013 at 05:58

      is it version compatible ? Because normally its not like that but if there is version incompatible than there may be chances to not shown in module list. So, first check is it version compatible ?(or path ,etc)

      Delete
  6. Unknown3 September 2013 at 22:39

    I am using openerp 7 . I am not sure if my downloaded jasper is for openerp 7 or not

    ReplyDelete
    Replies
    1. http://pinakinnayi.blogspot.com/3 September 2013 at 23:01

      I think jasper is not compatible to version 7 but its depend from where you have downloaded(i don't know if somebody changed and make it compatible or not). So, in this you need to first make it compatible to version 7 to use.

      Delete
  7. Unknown3 September 2013 at 23:57

    ok I have downloaded and installed it. Now what I have to do for creating reports . Do I have to do some developing in the ireport designer or is it be ready enough to start creating reports

    ReplyDelete
    Replies
    1. APW22 April 2014 at 02:14

      Hi how can you installed jasper module in openerp 7.0 .please tell me. i also need to konw that. please..

      Delete
  8. Unknown4 September 2013 at 05:55

    I dont understand which xml file should I import in ireport jasper designer . Can u plz help me

    ReplyDelete
    Replies
    1. http://pinakinnayi.blogspot.com/10 September 2013 at 00:00

      Sorry for late reply ...
      when you create data template at that time it will create a new xml file(from openerp) that file you have to import in jasper design.

      Delete
  9. Unknown10 September 2013 at 23:16

    when I create data template , I receive " OpenERP server error " .I dont seem to understand this issue . Plz help

    ReplyDelete
  10. Unknown10 September 2013 at 23:49

    I think there is some other config for openerp-7 . Because I am following exactly the same way told in the tutorials , but still I m getting this error. Pls reply as soon as possible

    ReplyDelete
  11. Unknown18 September 2013 at 00:32

    Hello Pinakin , I need your help regarding OpenERP reporting in Ubuntu 12.04

    ReplyDelete
  12. Unknown31 October 2013 at 07:20

    Hi Pinakin Nayi,
    I'm in a trouble. your link to download jasper_report is not available. can you send the link. or send me that in my mail. arrakaizen@gmail.com.

    ReplyDelete
    Replies
    1. http://pinakinnayi.blogspot.com/31 October 2013 at 22:06

      Hello,

      You can download Jasper from openerp apps store : https://www.openerp.com/apps?search=jasper&series=

      Delete
    2. Unknown1 November 2013 at 15:49

      In the list I don't see Jasper Report. so what module can I download. please help me.
      And I download the I have a trouble when I install this module.
      please help. it's a bussness of dead or alive

      Delete
  13. Unknown14 November 2013 at 09:31

    Hello,
    I use jasper_report with openerp-6.0.4 but I have a problem to create a report for orders. when create my report only the first ligne of the sale.order.lines is taken. so I want to know how can I do to create a order report with all lines of orders.

    ReplyDelete
  14. Kovai Senthil24 December 2013 at 23:21

    Hi Jean Jonatha Follow this Steps.

    1) I've exported from the Web client the xml data template of account.invoice model using depth=3
    2) Using ireport 3.7.5, I've created a new datasource selecting the xml file from the previous step.
    3) I've created a jasper report with the invoice details: invoice number, date, customer details and invoice lines. I've set the property OPENERP_RELATIONS =['invoice_line'] for this master report.
    4) I've created a jasper subreport with the tax lines of the invoice using the same datasource (xml) of step 2. I have set the property OPENERP_RELATIONS = ['tax_line'] to this subreport. I only used the bands "column header" (for the titles) and "detail" for the tax lines data.
    5) In the master report, I've created a parameter called "SUBREPORT_DS" of type java.lang.Object and checking "use as a prompt". Then I've added the subreport from step 4 (the compiled .jasper file) in the master report inside the "detail" band with the following properties: connection type ="use a datasource expression" and datasource expression = $P{SUBREPORT_DS}
    6) In the Web client, from administration menu, I have created a new jasper report indicating the jrxml file of the master report. I have copied the subreport .jasper file in the custom_reports folder of the server addon "jasper_reports".
    7) I go to the customer invoices list and I can see the new report. I click on it to print the PDF of a selected invoice and all the content for the master report is displayed, but the content from the subreport is empty (the tax lines of the invoice). If I launch the subreport independently, it shows the tax lines correctly.

    ReplyDelete
    Replies
    1. AMDR20 January 2014 at 09:59

      Dear Kovai Senthil,
      I have the same problem, the subreport works independently but it shows nothing in the main report.
      Did you find a solution?

      Delete
  15. SK28 January 2014 at 23:10

    Hi,

    how to store data template in desktop ? Please refer screenshot number 11.

    ReplyDelete
    Replies
    1. http://pinakinnayi.blogspot.com/28 January 2014 at 23:19

      Hi,

      There is "Save as" button click on and it will open dialog box to save. Now, you can save...

      Delete
    2. SK29 January 2014 at 02:47

      Thanks for the quick response .
      Infact I tried that option. As you mentioned dialog box opens with button as 'Open' and not 'Save'. Please have a look.

      Delete
    3. SK31 January 2014 at 03:56

      Hi Pinakin Nayi ,

      Did you get a chance to see my above comment ? Thanks

      Delete
    4. SK13 February 2014 at 02:27

      Hello Sir,

      Any updates on this issue ? Thank you

      Delete
    5. SK17 February 2014 at 04:11

      Sir,

      Any more updates on my query ?

      Delete
  16. APW22 April 2014 at 02:22

    Hi Pinakin,

    Can you please help me to link jasper server to openerp 7.0. I m doing openerp project for my Masters degree. Please help me. any how i have to do this end of May 2014. Please help me.I have already installed jasper server and created reports using postgresql DB. now i need to create link in openerp system .please help me.

    ~APW (Sri Lanka)

    ReplyDelete
  17. Arjun10 April 2015 at 02:44

    Hi Pinakin,
    I have downloaded the jasper_report Module(v.7 for openerp), and also succefully installed in openerp 7.
    I have followed all the steps according to your doc.
    Here my problem is that when i am taking print out for the particular report in openerp 7 it throws a error//

    "Uncaught SyntaxError: Unexpected end of input
    http://localhost:7069/?db=Jasper&ts=1428647654974&debug=#id=2&view_type=form&model=purchase.order&menu_id=336&action=399:0"

    Kindly suggest me how to solve this bug ?

    ReplyDelete
  18. bala28 March 2016 at 04:10

    need solution

    Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: FATAL: password authentication failed for user

    ReplyDelete
  19. Unknown7 December 2016 at 21:38

    Hello Pinakin,

    when we print report first time it's take more time.
    then after reload the screen it's working perfect.

    ReplyDelete
  20. ibradin3 July 2021 at 05:26

    RML is not available at specified location or not enough data to print!: (None, None, None)
    can someone help me?
    thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)