Content grouping in report through pentaho report designer

Problem Statement :

Content grouping is pretty standard need in any reporting solution. Does pentaho report designer support content grouping? Does it support multi level content grouping?

The answer is yes. Pentaho report designer supports content grouping and it supports multi level grouping.

Scope of this Article:

This article demonstrate how can we enable content grouping in a report and how a report structure changes after applying content grouping


Pentaho Report Designer 3.9.0 GA


  • Create a prpt report . Add the required data source from Data Sets


  • Select Product Type, Product Vendor, Product Name and Price from product_details (Sample data DB).


  • Now your data is ready to create a report.
  • Now drag a rectangle element on to the report header and add respective labels for these 4 selected fields.
  • Now go to data -> product_details Query  -> drag the values respective values into the details band.
  • Save and Run the report , this would give us a basic report.


  • Now let us apply grouping at product type.Follow the steps that are highlighted in the screen shot to apply grouping.
  • in below diagram at step6, select the field(product_type) that you wanted to group by from the drop down list .


  • You can observe selected  product_type at group level.


  • Move Product Type label to Group header , Move product_type value to group header to know the category of grouping .
  • Now the grouping is done at product type level in a report.



Hope u understood how a grouping is applied on standard pentaho report.

Walking Tree promotes Pentaho and we support the corporates as well as the developers to ensure that the business is able to take complete advantage of Pentaho’s wonderful capability. In case you are looking for a professional assistance then do visit our website to get in touch with us.


Advanced HTML.prpt  file under \design-tools\report-designer\samples\Advanced folder in standard pentaho distribution

BI developer

Tagged with: , , ,
Posted in Data Warehouse & BI, Pentaho

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out for all latest blogs.

Sencha Select Partner Sencha Training Partner
Xamarin Authorized Partner
Recent Publication
%d bloggers like this: