Name tabs in excel export based on field values used in break page

[sanchoniathon]

Hello to all,

Anyone has the steps in order to automatically name the excel "TABS" created when exported to excel based on the values of the field used in our Page Break ?

I read somewhere tah we first need to make sure a specific variable is set to some value in cognos administration ? Is this really necessary ?

Thanks to anyone for any valuable tips  !

[Raghuvir]

Hello to all,

Anyone has the steps in order to automatically name the excel "TABS" created when exported to excel based on the values of the field used in our Page Break ?

I read somewhere tah we first need to make sure a specific variable is set to some value in cognos administration ? Is this really necessary ?

Thanks to anyone for any valuable tips  !

Hi,

Please refer the following link. Few steps are provided at the bottom of the page. Hope that helps.

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014460129#77777777-0000-0000-0000-000014460866

Regards

[Raghuvir]

hi,

i tried using page set in Cognos 10.2.2 and it automatically renames the excel sheets as per the data item set in the grouping and sorting property of the page set.

Regards

[sanchoniathon]

Thanks to all for your posts !

To make sure i understantd, we currently use (for this client) Cognos 10.1.1 and in OUR case IT WILL NOT BE possible for Report Studio to automatically RENAME excel tabs even when going in the admin and setting the appropriate RSVP.EXCEL.NUMBEREDSHEETNAMES ?

Thanks again for any additional information !