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

Technology:

Pentaho Report Designer 3.9.0 GA

Details:

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

Viewdata

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

Viewdata

  • 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.

Viewdata

  • 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 .

Viewdata

  • You can observe selected  product_type at group level.

Viewdata

  • 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.

Viewdata

Summary:-

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.

Reference:

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out https://walkingtree.tech/index.php/blog for all latest blogs.

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