Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

5

Jasperreport and openerp 7 with parameters How-to

By
Oscar Cascante F
on 10/9/13, 8:12 PM 14,286 views

Hello,

I would like to share this mini-howto about use jasperreport server, ireport and openerp 7 passing parameters. I hope this help somebody. Again, sorry for my english

1- Install jasperreport server

2- Download and extract jassperreport file for openerp from https://github.com/syleam/openerp-jasperserver. This extract two folders.

3- Install "python-pip" library from command line or synaptic

4- Download and install 3 libraries from command line: "sudo pip install httplib2 pypdf python-dime"

5- Untar the openerp jasperreport file and install the jasper_server module.

In jasperreport server:

create needed folders in jasperserver:

6- Create "openerp" folder inside the root directory

7- Create "datasources" folder inside the openerp directory

8- Create "inputs" folder inside the openerp directory

9- Create "bases" folder inside the openerp directory

10 Under "bases" folder, create a directory with the name of your working openerp database and complete the necesary data parameters.

11 In openerp go to menu /configuration/jasper report/configuration/jasperserver configuration/ and create a new database parameter access.

11 Right click over datasources folder and create a new datasource.

12 Use ireport to create a new report with a basic query without parameters

13After create the sql query, define two parameter that we are going to use to pass data from openerp.
This parameters have to be named as OERP_<name of="" parameter="">

Repeat, name of parameters must be in uppercase.

14 In jasperreport server go to tree openerp/inputs option and create an input control for each parameters you created in openerp. You have to use the same parameters name.

15 In openerp/bases/<databasename> folder create a new jasperreport resource with the same report name of your ireport report name and choose the <reportname>.jrxml file.

16 Then in "resources and controls" add two input controls from jasper server

17 In "datasources" select the repository just created

18 Create a new class inside your module ( the one you are going to call the report ) This class is used to call the report and give the parameters from openerp to jasper.

Example tested:

( change the values inside <> with yours )

class <report_class> (osv.osv):

def <nameoffunction>(self, cr, uid, ids, context=None): # you can use a button to call this funtion to execute the report

    <reg> = self.browse(cr, uid, ids, context=context)[0]
    data = {}
    data['model'] = '<modelname>'
    data['jasper'] = {
        '<jasperparameter1>': <reg>.<param1>, # without "OERP_"
        '<jasperparameter2': <reg>.<param2>,
    }

    return {
            'type': 'ir.actions.report.xml',
            'report_name': 'jasper.<openerp/jasperdocument/servicename>',
            'datas': data,
    }


_name = '<modelname>'

_columns = {
    '<param1>' : fields.char('From', size=15, required=True),
    '<param2>' : fields.char('To', size=15, required=True),
}

19 Now create the xml to show the report parameter form in openerp

20 In openerp go to menu configuration/jasper report/jasper document and create a new one using this parameters:

objet model = <report_class> in your module

service name = field report_name in your class without "jasper."

service unit = jasperserver report name

jasper file = jasperserver report name

21 Go to "parameter" tab and create the two parameters with the same name you write in jasperreport

22 Test

My openerp parameter screen:

image description

My pdf jasper report screen question:

image description

As soon as posible we are going to upload a video of the process

This is about the only information I can find about using Syleam's Jasperserver module. I still don't understand it, though. I have it installed, and I really have no idea where to go from here.

Gary Dunnaway
on 10/15/13, 2:42 PM

If you have a concrete question i would try to answer it.

Oscar Cascante F
on 10/15/13, 5:00 PM

Oscar, i've tried to understand how to use the module. What i don't understand is what to fill in service name. You've said <openerp/jasperdocument/servicename>, is this literal? Another question is what you are referring as jasperserver report name. I think is the name in jasperserver (not the jrxml file), is that right?

Marcelo Hamra
on 10/27/13, 8:20 AM

It is great with the information. I tried to follow the steps. At step 11, is it pointing to the Jasper server, datasources folder newly created under the openerp folder? I really wish you have time to create the video howto so that we can follow it easily. Thanks in advance.

Gene Leung
on 11/13/13, 6:15 AM

First of all, thank you for your time and effort. In general, is this method necessary for me to print invoices through JasperServer? Or only if I want to pass parameters back and forth? I want my client to be able to do everything through the OpenERP web interface, without having to open the /jasperserver web page. As for your tutorial, I am a bit confused here: 10 Under "bases" folder, create a directory with the name of your working openerp database and complete the necesary data parameters.

Parameters? On a folder? I don't understand. Perhaps you meant something else there?

Gary Dunnaway
on 12/7/13, 5:08 PM

Is the best info that I found about Jasper Reports and Openerp. But I can't find "11 In openerp go to menu /configuration/jasper report/configuration/jasperserver configuration/ and create a new database parameter access." I've also the same question that @Gary Dunnaway has... Can you help me ?

Versão Integral, Anabela Damas
on 9/2/14, 10:43 AM
0
Gary Dunnaway
On 10/15/13, 2:42 PM

This is about the only information I can find about using Syleam's Jasperserver module. I still don't understand it, though. I have it installed, and I really have no idea where to go from here.

0
Marcelo Hamra
On 1/2/14, 12:14 PM

Hi Oscar, have your tried an XML report using SYLEAM jasper_server module?

I receive the following answer after SOAP call:

<faultcode>soapenv:Server.userException</faultcode><faultstring>org.xml.sax.SAXException: SimpleDeserializer encountered a child element, which is NOT expected, in something it was trying to deserialize.</faultstring>

Any clue?

Another question: does openerp send the id/s of the selected rows when you launch the report from the sidebar in a tree view? Does it send the ids in a jasperreport parameter?

Thanks!

0
Paula Neves
On 2/6/14, 7:47 AM

Hello there.

So me and some collegues of mine have been trying to actually put this to work but we still havent managed to do this, i think there is something wrong with the class that we have created but we don't know.

# *****************************************************
# JASPER - início
# *****************************************************

class hr_contract_jasper(osv.osv):

    _name='hr.contract.jasper'

    def relatorio_contrato_consultor(self, cr, uid, ids, context=None):

        res = self.pool.get('hr.contract').browse(cr, uid, ids, context=context)[0]

        data = {}
        data['model'] = 'hr.contract.jasper'
        data['jasper'] = {
            'IDCONTRACTO': res.id,
        }

        #raise osv.except_osv('Error !', _(data))
        #data = {'model': 'hr.contract.jasper', 'jasper': {'IDCONTRACTO': 897}}
        """
        ERRO

        if hasattr(cur_obj, 'company_id') and cur_obj.company_id:
        File "/opt/openerp-source/server/openerp/osv/orm.py", line 497, in __getattr__
        return self[name]
        File "/opt/openerp-source/server/openerp/osv/orm.py", line 385, in __getitem__
        self.__logger.debug(''.join(traceback.format_stack()))
        """

        return {
                'type'          : 'ir.actions.report.xml',
                'report_name'   : 'jasper.report_1',
                'datas'         : data,
        }    

hr_contract_jasper()

# *****************************************************
# JASPER - fim
# *****************************************************

Can you see if there is something wrong with this?

I am almost 100% sure that the way we are handling the other parts of the toturial are correct.

Thanks in advance.

PS: if you could provide a video i would be gladly appreciated.

0
ARRA Jean Jonathan
On 11/18/13, 9:48 AM

Hi Mister Oscar, I have a problem about the parameters in jaspserserver I don't know how can I create a parameters to link that ith my jasperserver. Pleas help me

0
Oscar Cascante F
On 11/1/13, 1:27 PM

Hello,

Sorry about the delay...

In openerp->settings->jasper documents-> you create a new report. Here, you have a field name: Service name. This is the name you have to use. About the jasper report name, is the name used in jasperreport server.

Hope this help

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

4 follower(s)

Stats

Asked: 10/9/13, 8:12 PM
Seen: 14286 times
Last updated: 6/4/15, 5:23 AM