Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: FerdH4 on 03 Oct 2025 10:36:10 AM

Title: Resolved: Trying to disable default row heading Grouping in a Crosstab.
Post by: FerdH4 on 03 Oct 2025 10:36:10 AM
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???

   
Title: Re: Trying to disable default row heading Grouping in a Crosstab.
Post by: dougp on 03 Oct 2025 10:54:16 AM
Adjust the "Group repeating cells - export to Excel" property of the Report object.
Title: Re: Trying to disable default row heading Grouping in a Crosstab.
Post by: FerdH4 on 03 Oct 2025 11:11:40 AM
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.
Text only | Text with Images