Jaspersoft Studio – Creating Cross-Tab Report for 2-Dim Data Display

Home  >>  Jaspersoft Studio  >>  Jaspersoft Studio – Creating Cross-Tab Report for 2-Dim Data Display

Jaspersoft Studio – Creating Cross-Tab Report for 2-Dim Data Display

23
Jun,2015

4

Hello All!!!
Was bit busy with my work and could not find much time to do this. But this made me write this blog.

This is a simple step by step explanation to create a cross tab report.

1) For this tutorial, I have created a simple .csv file with the test data provided by the person who has asked teh question.

Img1

2) Create a report. Drag the Cross Tab from Pallete and add it on to a summary section.(As you know the Tables, Lists, CrossTab and Charts work best in Summary band or Title band).

Img2

3) Since the requirement id to display (G1, G2…) in column, we will select Field2 as column field

Img3

4) And X1, X2…as Row field, so will use Field3 as row field.

Img4

5) Then For Data Field, we will use Field4 and this time, change the default function from “Count” to “Nothing”, as the requirement is to display teh data directly.

Img5

6) Click Next button and click Finish.

Img6

7) Re-size the Cross-tab section and click preview to get the data as required.

Img7

Img8

4 Comments so far:

  1. Mario Mejia B says:

    Thank you very much Rajesh…it worked just I wanted to.
    I will do some cosmetic adjustments to get the final report.
    Best regards,
    Mario.

    • rajeshsirsikar says:

      Hi Mario,
      I am Glad that it helped.
      Cheers
      Rajesh

      • Mario Mejia B says:

        Hi Rajesh:

        I have two questions:
        a) How do I “insert” a column/row in the crosstab to display a variable? The crosstab is only displaying the fields from the main dataset query only.
        b) The Total values for both columns and rows are displaying the las row/colum value and not the SUm of all the values from the row/column!

        regards,
        Mario

  2. Tess Iskra says:

    So the crosstab report solves the Jaspersoft downside of not being able to report off of two dims? For instance, I have a Resource dim and a Project dim, so now I can join them and see resource allocations and actuals on specific projects?

Leave a Reply

Your email address will not be published. Required fields are marked *