Repeating the GROUP BY data items in impromptu report

[Nchd15]

Hi All,

I am creating a report containing nested grouped data which the user then saves as 'Excel with Format' file. The problem is as the Grouped field is not repeated, there are blank cells for the column corresponding to outer group. What can be done to repeat the grouped data values in every row.

 

[griffindm]

A quick and dirty fix is to include the grouped by data element a second time (ungrouped). It will then export the value on every Excel row.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[Nchd15]

It works. Thanks a ton Dave