Excel Sheet Renaming

Case:

When a Cognos report is exported to Excel the tabs are numbered with a sequence.

Sometimes this is not a desired feature. You want to prevent Cognos from adding a “_” and a sequence number.

Solution:

Add a property in the ReportService (BatchService):

RSVP.EXCEL.NUMBEREDSHEETNAMES

Value: “false”

You have to restart the services to make this change effective.

Leave a Reply

Your email address will not be published. Required fields are marked *