ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171


ZestyBeanz Technologies Pvt Ltd
61/3236, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254


Zesty Labs
Office # 2003, Millennium Plaza Building
Sheikh Zayed Rd, Dubai, UAE
Phone: +971 4333 2222​
Mobile: +971-52-7553466


ZestyBeanz Technologies GmbH
Reuterstraße 1
90408 Nürnberg
Fon: +49 911 4801 444
Fax: +49 911 4801 445

Pentaho Report with OpenERP

Contact Form

Ranjith's picture

Pentaho Report with OpenERP

Pentaho Report Designer

Pentaho report designer is one of the best  tool that allow us to create pixel-perfect reports of our data in PDF, Excel, HTML, Text, Rich-Text-File, XML and CSV combined with  OpenERP.

Using pentaho we can easily transform all our data into meaningful information to our audience. A screenshot of pentaho report designer is shown below.

1.Designing Elements

Screenshot from 2014-10-13 15:04:51.png

As any other reporting tool there is pentaho report is  also separated by different bands.

Page  Header   : It will display at top of the report.

Report Header : Its the header for the entire  report. its only print once for a report.

Groups : We can group particular things as group. Whenever the group value change the item will be printed as new group

Details Band    : It contains all the iterated details.

Report footer : Its the footer for whole report. It prints only once.

Page Footer  : This is the footer page for each page.

In pentaho report designer have a tool bar at left panel. It includes several useful designing tools. that are describing below.

- It is used to provide labels which are static .

  • - Its used for variable text fields. That depends on a field which described in our Data set

  • - Its used for variable number field. That depends on a field value which described in our dataset, and , are also used to variable date and message fields.

  • and are used to setup images in our report.

  • Screenshot from 2014-10-15 11:09:00.png are used to place Round,Rectangle ,vertical line, and horizontal line in our report respectively

  • Survey scale is used to represent a graphical band having value in between 0 to 10

  • using this tool we can insert chart representation in our report

  • is used to include barcodes in our report

  • Band is used to separate our data and provide different properties for elements that contains in this band

  • We can add subreport by using this tool and include independent reports in our main report

  • Screenshot from 2014-10-15 11:36:03.png are used to manage index of report

We can change the properties of each element from the panel which shown in right side as follows

We can setup font size, style, position,etc from here.

Data Elements

We  can integrate our postgresql database details in to pentaho report dynamically with the help of sql queries. There is toolbar in right panel named as Data is used to integrate our data in to report.

Steps to connect our database with pentaho report

Data sets

  • Right click on and select JDBC

  • In connection filed add new connection as follows

    • Connection name : Any name that you wish

    • Connection type  : PostgreSQL

    • Access : Native (JDBC)

    • Hostname : your database host name

    • Database name : your current database name

    • Port number : your database port number(normally 5432 for postgresql)

    • username : your database use name

    • Password : your database password

    • Then press test connection if it correct it will show success message

  • Next we need to add data selection by using the connection that we configured in previous step.

    • In available query press button to add new query. We can use any query as per our requirement.Then press OK

    • All the selected data fields will displayed under our data panel. We just need to drag and drop the elements in our report.


  • Pentaho report designer provide several default functions for several functionalities like pagenumber, find sum of columns,etc. we can easily add this functions to our report using


parameters are used to pass values into our report. pentaho automatically collect the following parameters from openerp

  • ids: the context ids when the report action is called. This is almost always needed for object based reports to be meaningful.

  • user_id: the id of the user running the report.

  • user_name: the display name of the user running the report.

  • context_lang: the language in effect when the report action is executed.

  • context_tz: the time zone in effect when the report action is executed.

We can also pass our own parameters from openERP by passing {'pentaho_defaults': { .... }} in context that can also be accessible from pentaho.


programmingshark's picture

Here I am sharing wonderful

Here I am sharing wonderful platform for students in Australia , US and UK seeking for programming assignment help. This is , world's no1 programming help company since 2014. They cover almost all wide range of programming subjects, here you go:
C Programming Assignment Help , C++ Programming Assignment Help , Python Programming Assignment Help , R Programming Assignment Help , and MATLAB Assignment Help . Visit now!

matlabsolutions's picture

Are you in search of MATLAB

Are you in search of MATLAB Homework Help or any assistance with MATLAB Assignment Help ?? Nothing to worry when MATLAB Solutions team is here. Leave all your Matlab Programming problems on us.

Norma Miller's picture

Node is manufactured for the

Node is manufactured for the utilization of the goals for the humans. The node and is vital for the reformers. The struggle is done for the facial expressions of the terms for the citizens.

Maniganda's picture

Hi ranjith, Is there an

Hi ranjith,
Is there an option to print multiple copies of same report many times in pentaho reports ,
if yes how to achieve it ?

Khudrath Ali's picture

hi Ranjith, I am using to

hi Ranjith,
I am using to pentaho report for my project but to generate Pdf report its taking 15-20 seconds. can you help out regarding this?

thanks in advance

Ranjith's picture

In the reporting engine, the

In the reporting engine, the performance of the report is usually limited by the layouts and text processing that is necessary to produce the report. Performance is mainly dependent on the amount of content printed. The more content you generate, the more time we will need to perform all layout computations.

MATLAB solutions's picture

It’s good to share

It’s good to share information with others. I am also sharing something very important for students seeking MATLAB Assignment Help. Visit MatlabSolutions and get best assistance in your MATLAB, Simulink Assignments and Projects.

You can also get CDR Report Engineers Australia if you look to immigrate to Australia.

amanse9's picture

This is sounds good post

This is sounds good post having useful information.

amanse9's picture

Good post found here.

Good post found here.

Anonymous's picture