How to configure Jasper Server with Odoo.

- March

2020

Posted By : Mohsin Yaseen

Comments Off

In this blog, we will be explaining the step by step and briefly explained procedure of configuring Jasper Server with Odoo.

Table of Contents

(Note: User name and user id can be same.)

Data Sources:

Download the jasper server using the link https://community.jaspersoft.com/project/jasperreports-server/releases
After installation, First, create data source for which you want to add resources for, by right clicking on the data source option located at left.

Mention the port number, the name of the data base whose are intended, user name and password which is same as configured while setting up data base in Odoo.
In case of single db data sources, the user needs to mention the dbname as it is shown.
In case of multiple db data sources, the user needs to mention the db name in the following syntax: {attribute(‘dbname’,’user’)}. The db name and user is written as generic example. It can be changed as per user’s setting.

When a new data source is added successfully, set the data source type and properties.
Select the type of data source you wish to add and then enter the required property values.

Set the required values for the report, then, optionally, proceed to other pages in the flow.

You can test connection in order to check that all entered fields are valid or not and then save.

Right click on reports to add a folder which will distinguish your existing database from other databases.
Right click on the folder that you have created, then add resource-> Jasper Report.
Set the required values for the report, then, optionally, proceed to other pages in the flow.
Upload a local jrxml file of report. Name of report and resource id should be same as local jrxml file.
Click on data source and browse data source path (it can be found by right clicking on the report) from repository and then submit report.
Sub reports: If the submitted report has any sub report, it will automatically be loaded. Follow the number 4 and 5 steps to submit sub report.

Open technical settings in Odoo and go to reports for reports settings.
Edit the username, password, server IP address, server port, report path and data source path.
If you have entered everything correct then all reports are ready to print.