Using the following data:
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):
However, I need a crosstab that would look like:
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?