Merged cells in Excel output
There is a list report with many columns. The report shows the title in page header. Users mostly access this report in Excel format.
When the output is generated, Cognos puts the output in the first cell (A1). This stretches the A column.
In this recipe, we will see how to get Cognos to generate merged cells so that the columns are not stretched.
Getting ready
Create a simple list report. Put a report title in the page header.
How to do it...
- Insert a Table from the 'Insertable objects' pane into the report header.
- Set the ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.