Merged cells in Excel output
Let's say there is a list report with many columns. The report shows the title in the 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 as shown in the following screenshot:
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 as shown in the following screenshot:
How to do ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition 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.
