How to remove the -1 from Excel Multisheet Ouput Tabs
Problem(Abstract)
A Cognos 8 multi-page report output to
Excel 2002 will have the worksheet tabs named as <Page1 Name>-1,
<Page1 Name>-2,<Page2 Name>-3, <Page2 Name>-4, etc
How can the suffix be removed the first page name in each set? Eg:
<Page1 Name>, <Page1 Name>-2,<Page2 Name>, <Page2
Name>-2
Environment
Excel 2002
Resolving the problem
As of Cognos 8.3, there is a new Advanced Property setting to override this behaviour: RSVP.EXCEL.NUMBEREDSHEETNAMES=FALSE
Steps:
1) From Cognos Connection, click Launch
2) Cognos Administration.
3) Click the Configuration tab.
4) Select Dispatchers and Services.
5) Click on the Dispacher name.
6) Beside BatchReportService click the 'Set Properties' icon.
7) Click on the Settings tab.
8) Beside Environment Advanced settings, Click Edit.
9) Click the checkbox beside 'Override the settings acquired from the parent entry' if displayed.
10) Add the parameter RSVP.EXCEL.NUMBEREDSHEETNAMES with a value FALSE.
11) Repeat from step 5 for the ReportService.
Steps:
1) From Cognos Connection, click Launch
2) Cognos Administration.
3) Click the Configuration tab.
4) Select Dispatchers and Services.
5) Click on the Dispacher name.
6) Beside BatchReportService click the 'Set Properties' icon.
7) Click on the Settings tab.
8) Beside Environment Advanced settings, Click Edit.
9) Click the checkbox beside 'Override the settings acquired from the parent entry' if displayed.
10) Add the parameter RSVP.EXCEL.NUMBEREDSHEETNAMES with a value FALSE.
11) Repeat from step 5 for the ReportService.
Comments
Post a Comment