Working with Crosstab Component In Pentaho Report Designer

Posted on by By admin, in Business Intelligence, Open Source Business Intelligence, Pentaho | 3

This blog will teach reader about Working with Crosstab Component In Pentaho Report Designer

Crosstab is an experimental feature in Pentaho Report Designer . By default we can’t see crosstab component in PRD.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

To enable this feature we need to do some modifications in Edit – > Preferences

1

In this Panel , go to “Other Settings” Tab and check the 2nd Option i.e, “Enable (unsupported) experimental features”.

Then Crosstab component will be automatically visible in PRD.

Data Source : JDBC : Sample Data Memory

Query :

2

If we will preview this query then we will get the data like below :

3

But In the above resultset it is very difficult to analyze the data .

So , its better visualization , I decided to create report with crosstab on this query .

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Steps :

  1. Go to Master Report in Structure Tab
  2. On the right click of Master Report click on Add Crosstab Group

4

  1. Then you will find the below window

5

  1. Here you need to decide which field you want to see in row and which in column , accordingly set the fields you will get the output .

EXAMPLE :

6

Now Preview the report you will find something like below :

7

 

 

Rupam Bhardwaj

Helical IT Solutions

logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

A Business Intelligence Framework

0 0 votes
Article Rating
Subscribe
Notify of
3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Hi Rupam
I am Alvaro from Peru, in Southamerica.
I am a newbie in Pentaho and I’m practicing report designer for Pentaho, your example is awesome and it helps me a lot driving crosstab in PRD but, please, may you explain, how to edit a crosstab? and how to apply format to crosstab?… thank you very much.

how you got grids in cross tab output?
can you please brief about it.

Hello Rupam,
Very nice blog. Could you please give us the steps to get the grid layout, that you showed in this blog? I am working on report that looks similar to your’s but having hard time to get the grid layout.

Appreciate your inputs.

Thanks.