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.

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...

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... :-(

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