Repeat Group labels on every row of Cross Tab

All,

Our Excel users would like the Group labels repeated for every row of a Cross Tab when being exported as .xls. I'd like to use the normal single Group label when emitting to the browser, but repeat the Group Labels when emitting to xls. See attached SingleGroupLabel.jpg and RepeatingGroupLabel.jpg with outlines in red for desired effects.

Any ideas on how this can be done?

Thanks,

Daron

Find more posts tagged with

Comments

mwilliams

If you put a 3 column grid in your 3rd dimension column in and put the first two dimension elements in the grid in the third column, they will repeat for each row. I don't think there's a way to make the dimensions repeat if you leave them in their grouped columns. Hope this helps.