Jump to content
Changes to the Jaspersoft community edition download ×

Crosstab with separate column groups


Recommended Posts


Hello everyone!


Using the following data:

7 gender Male 423 Color? Red
7 gender Male 456 Animal? Koala
7 profession Student 423 Color? Red
7 profession Student 456 Animal? Koala






I am currently generating the crosstab below in an Excel document, using a row group on recipientId (number 7) and a column group on questionId (numbers 423 and 456):

recipientId Color? Animal?
7 Red Koala

However, I need a crosstab that would look like:

recipientId gender profession Color? Animal?
7 Male Student Red Koala


According to the crosstab sample (http://jasperreports.sourceforge.net/sample.reference/crosstabs/index.html), column groups are enclosed in each other. But I need to repeat both my tag columns and question columns, separately.

Should I keep trying to do this using a crosstab and coluùmn groups? Maybe by adding fake empty questionId columns? Or should I use a subreport? Or is there a better solution?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...