Development

How to Fix Excel Merged Columns in Cognos Report Studio

The Cognos default output is ‘HTML’. When we design a report in Report Studio, not only in HTML format, but also in Excel and PDF, the report output should be good. Most of the time when we export to Excel, we experience Merged Cell issues in Excel. Hence it is difficult for the user to sort and filter the records.

To avoid this issue, we found a work around. We can apply a fixed width in Cognos Reports.

Covid 19
COVID-19: Digital Insights For Enterprise Action

Access Perficient’s latest insights into how you can leverage digital technologies to not only respond to the pandemic, but drive your operations forward and deliver experiences your customers need.

Get Informed

Size and Overflow: Increase the column width

Steps to apply Size and Overflow in Report column:
We should apply size and overflow in each text item within the column body. Hence we will not get any merged column issues in Excel and standard width across all reports.
Recently we found there should be an Admin setting to resolve the issues properly.

Steps below for admin setting:
– in IBM Cognos Administration portal, click on the Status tab then click System on the left menu
– Click on the blue arrow next to System (in Scorecard part) and choose set Properties
– Click on the Settings tab
– on Advanced settings click Edit…

Then add this parameter:
Parameter column:
RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL
Value column:
TRUE

About the Author

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories