IBM Support

How to remove the -1 from Excel Multisheet Ouput Tabs

Troubleshooting


Problem

A Cognos multi-page report output to Excel 2002 will have the worksheet tabs named as -1 -2 -3 -4 etc How can the suffix be removed the first page name in each set so it looks like: -2 -2

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.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Viewer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21343184