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 froClick Me!!! To Download
Step 4 :
                 Install Jasper Report in Your OpenERP.
Step 5 :  
                 create Data Template from
                ->setting > customization > jasper > jasper data template
                















               


32 comments:

  1. I wonder will that work for OpenERP version 7

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

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

    ReplyDelete
  4. 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. 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
  5. I am using openerp 7 . I am not sure if my downloaded jasper is for openerp 7 or not

    ReplyDelete
    Replies
    1. 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
  6. 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. Hi how can you installed jasper module in openerp 7.0 .please tell me. i also need to konw that. please..

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

    ReplyDelete
    Replies
    1. 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
  8. when I create data template , I receive " OpenERP server error " .I dont seem to understand this issue . Plz help

    ReplyDelete
  9. 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
  10. Hello Pinakin , I need your help regarding OpenERP reporting in Ubuntu 12.04

    ReplyDelete
  11. 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. Hello,

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

      Delete
    2. 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
  12. 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
  13. 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. 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
  14. Hi,

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

    ReplyDelete
    Replies
    1. Hi,

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

      Delete
    2. 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. Hi Pinakin Nayi ,

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

      Delete
    4. Hello Sir,

      Any updates on this issue ? Thank you

      Delete
    5. Sir,

      Any more updates on my query ?

      Delete
  15. 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
  16. 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
  17. need solution

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

    ReplyDelete
  18. Hello Pinakin,

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

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

    ReplyDelete