Resolved: Trying to disable default row heading Grouping in a Crosstab.

[FerdH4]

I'm using v11.2.3.

My Report Crosstab contain has nested date-parts as row headings - like Year, Month Name, and Day.

By default, the multiple occurrences of the Year and the Month Name are being "grouped" which looks fab in HTML. 

But my audience needs to be able to easily export to MS Excel for further manipulations.  The grouped row heading make it difficult on them to use the rows within Excel.

I've Googled for ideas but seems like all hints I've come across seem to want to help prevent auto aggregation of the values in the body of the Crosstab.  None of those hints influenced the formatting of the row headings.


Any other ideas anyone might be able to share???

   

[dougp]

Adjust the "Group repeating cells - export to Excel" property of the Report object.

[FerdH4]

Mark this Resolved! 

Thanks dougp, I had trouble finding that Property as I was looking for it relevant to either the Query or the Crosstab container when it is instead a Property of the Report page.