I have a requirement to develop a report for bursting where there are several crosstabs nested with a master - detail relationship as follows:
Division
Region
District
District..
Region
District
District
Division...and so on.
All is fine in every output except Excel (any format), where the formatting goes bad. Cognos ends up making the first column of the master crosstab wide enough to nest the detail crosstab under it. Is there any way to avoid this?
Any direction would be appreciated!
Cheers,
Tim