Troubleshooting
Problem
A Cognos multi-page report output to Excel 2002 will have the worksheet tabs named as
Environment
Excel 2002
Resolving The Problem
There is an Advanced Property setting to override this behaviour:
RSVP.EXCEL.NUMBEREDSHEETNAMES=FALSE
Steps:
1) From Cognos Connection, click Launch IBM Cognos Administration.
2) Click the Status tab and click on System then the Dispatcher name.
3) Beside BatchReportService click the arrow and then the Set Properties icon.
4 ) Click on the Settings tab and beside Environment Advanced settings, Click Edit.
5) Click the checkbox beside 'Override the settings acquired from the parent entry' if displayed.
6) Add the parameter RSVP.EXCEL.NUMBEREDSHEETNAMES with a value FALSE.
7) Repeat from step 5 for the ReportService.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21343184