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.

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 .

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

3 comments

  1. Alvaro

    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.

    • kishore

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

  2. Dhavan

    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.

Leave a Reply