In Cognos 10.x and 8.x , this was the simple to handle on Cognos Connection or via Repot Studio interface. In Cognos 11.0.6, You need to load classic view (Cognos Connection) to go back to this interface to change the package. In Cognos Cloud environment, we have single environment for Development and UAT. In such cases, when we move content from Dev folder to UAT area, we need to switch to classic mode to change the package.
Below are the properties to set to keep column size and width with text wrapping: Column Merge issue http://www-01.ibm.com/support/docview.wss?uid=swg21674298 Set the advanced server property RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL to TRUE for both BatchReportService and ReportService services. Row Merge issue http://www-01.ibm.com/support/docview.wss?uid=swg21440556 RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL also to be set to TRUE for both BatchReportService and ReportService services. Once done, you can set any column width to be fixed and see same result in Excel as well as HTML. Please note that above properties will not be honored if you have unchecked Grouping repeating cells Report property in Report Properties menu.
Problem: Setup HTML link on email Solution: Create Email ID data item in report query [Report Query].[Email ID] Drag singleton with Email ID field and set property visible to NO. In Singleton, drag Hyperlink object and change properties Text Source: Source Type = Report expression Report Expression: Email ID field URL Source Source Type = Report expression Report Expression: 'mailto:'+[Report Query].[Email ID]