Crosstab with separate column groups

0

 

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?

yamanika's picture
Joined: Apr 4 2012 - 1:46am
Last seen: 6 years 9 months ago

0 Answers:

No answers yet
Feedback