[SOLVED] Repeated values in Crosstab

[fgaudin]

 Hello,

 

I have two row groups in my crosstab element and I would like values to be repeated so that the report output can be used effectively in Excel.

 

Here is the output I get:

 

		2008	2009	2010
GA	a	22	3	9
	e	65	4	6
IR	l	4	34	7
VG	a	14	8	6

And this is the output I would like to have:

		2008	2009	2010
GA	a	22	3	9
GA	e	65	4	6
IR	l	4	34	7
VG	a	14	8	6

I have tried selecting and deselecting "print repeated values" for the first row group but it doesn't seem to make any difference to the output.

Does anyone know if I can make the values repeat as in the second example above??

 

 

Code:

Post Edited by fgaudin at 09/14/2011 08:14

[baggypants]

Create another group which is Column1||Column2 and set that above column1 and then hide it?

[fgaudin]

 That does work and might be a workaround in some cases. However the reason I want to export to excel is to be able reorder and filter on the different columns.  If it ends up all concatenated in one cell then that defeats the purpose of exporting to excel... :-(

[baggypants]

Have three columns with the concatenated cell being the first one and then hide it somehow.

[besmirgogu]

Hi,

 

Did you actually manage to find a way to print repeated values in a crosstab?

I have the exact same problem.

 

[fgaudin]

Hi,

Yes, I followed baggypants's advice and it works fine.  Just create an invisible column that contains a concatenation of your columns fields.  In that way the values will always be unique and the repeated values in the other columns will be displayed.

I hope that's helpful.  Let us know what you find...

[besmirgogu]

Hi,

 

thank you very much for your reply. I have another question?

How do you create this invisible column?

 

Regards

[fgaudin]

From memory I think there is a 'visible' attribute if not as a last resort you could set the width to 0 and drag the rest of the columns to take the place.

[ktalarico]

Great post everyone; I can't believe this was so easy and I had been struggling with it for so long.  Thank you!

[dimuthuroshan3]

change the bucket expression of report row group. make the bucket expression by concatenation of few fields.

Eg:

<bucket class="java.lang.String">

<bucketExpression><![CDATA[$F{field1}+""+$F{field2}]]></bucketExpression>

</bucket>

[gollapudi.narasimharao]

Hello,

I have similar problem but here is situation i.e., I have a cross tab with 3 row groups and multiple column groups. When data filled in cross tab,first row group is blank when the second & row groups having the data.What we need is that crosstab should allow duplicate values instead of blanks. I tried to having a invisible column but didn't worked for me.

 

RowGroup1 RowGroup2 RowGroup3 ColumnGroup1 ColumnGroup2

1 11 111 22 23

12 121 24 24

 

So,Here in second row,We need to display 1 in first column.

 

Can any one please help me to succeed from this situation?

Please let me know if you need any further details to get this done?

Thanks,

Gollapudi.

[gotoark]

In bucket Expression, I added the $F{repeatedField}+"     "+$F{nonrepeatedField} as mentioned by @dimuthuroshan3 .It works like a charm Thanks Man :)