Name Excel Tabs

[wyconian]

Good afternoon Cognoise Gurus

Think I have an interesting one for you here:

I've got a report which sectioned, the report is scheduled to output as excel 2007 and has page breaks on the sections.  This gives a separate tab in excel for each section which is great. 

What I need to do now is name the excel tabs with the values of a data item.  Does anyone know if this is possible and how to do it via report studio?  I imagine it can be done via a vb macro in excel but that won't be allowed and the users wouldn't be able to do it.

As always thanks a lot for your help.

Simon

[jeemalif]

I have been searching for this functionality for a long time too. So far all I found from other places are two below (never really got it to working anyways, may be I am missing something):


Solution 1
---------------------------------------------------------------------------------------
It is possible in Cognos 8.3 or greater version.
There is a new Advanced Property setting called "RSVP.EXCEL.NUMBEREDSHEETNAMES" to overide this behaviour
Steps:
From Cognos Connection, click Launch -> Cognos Administration.
Click the Configuration tab.
Select Dispatchers and Services.
Click on the Dispacher name.
Beside BatchReportService click the Properties icon.
Click on the Settings tab.
Beside Environment Advanced settings, Click Edit.
Click the checkbox beside Override the settings acquired from the parent entry if displayed.
Add the parameter RSVP.EXCEL.NUMBEREDSHEETNAMES with a value FALSE.
Repeat from step 5 for the ReportService.


Solution 2
------------------------------------------
1.   create a data item which will fetch only the grouping value.
2.   Assign it to PageName()  ( I'm not clear how to assign something to a function? --Javed)
hope this will give you the title as expected.


Sorry don't have the details of where I go these from. I just kept a copy for my references/future research.

--Javed

[Lynn]

I think the first solution has to do with removing the -1 suffix from the first tab in the workbook for each Report Studio page. Nice to know, but not the same as having the tab names reflect a data item name.

https://www-304.ibm.com/support/docview.wss?uid=swg21343184

Not sure about the second solution but zillions of people have asked this question so whoever manages to figure it out could probably make a nice bit of cash charging people for the answer  ;)

[tjohnson3050]

I have had this same requirement come up on several occasions.  When a dynamic page set is created, it only make sense that the name of the excel tab should be the page set data item value.  I finally logged an enhancement request with IBM.
The number to track this enhancement is CQ# COGCQ00647973.

There is not a way to track it online, but perhaps if more people call IBM Cognos support to ask for a status to the enhancement request, it will get pushed up the list  ;)

[nsaxena]

Hello All ,

I saw this old post.

I find this link :-
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_ug_cra_adv_prop_name_worksht_tabs_excel2007.html

which states that now there is way to add dynamic page break to cognos.

Does any one tried this?
is it working?

[Lynn]

Hello All ,

I saw this old post.

I find this link :-
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_ug_cra_adv_prop_name_worksht_tabs_excel2007.html

which states that now there is way to add dynamic page break to cognos.

Does any one tried this?
is it working?

YES! IT WORKS!!! YIPPEE!!

[nsaxena]

Hi Lynn,

I tried the same but it is not working.

I am using cognos 10.2.1.
Is this feature available only in cognos 10.2.2? any idea

[Lynn]

It works in 10.2.2. It is listed in the What's New section of the report studio user guide for 10.2.2 and specifically mentions Excel 2007 output.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_reprting_new_10_2_2_xcel_tabs_names.html

[bindu2008]

Can anyone confirm if the setting the parameter  to true for ReportService would help in 10.2.1? I made the setting changes and it doesn't work. Does this only work for 10.2.2?

[tjohnson3050]

Yes, we have both 10.2.1 and 10.2.2 environments.  It was new in 10.2.2, doesn't work in 10.2.1.  See Lynn's previous post in this thread.

[nsaxena]

Can anyone confirm if the setting the parameter  to true for ReportService would help in 10.2.1? I made the setting changes and it doesn't work. Does this only work for 10.2.2?

Yes, it works only in v.10.2.2 and above.

[kawabunga]

I just tried this in our Cognos 10.2.2 installation and it works! Note, however, that you have to set it up for 2 services:

BatchReportService (for reports run in the background)
ReportService (for reports run now)

Set RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE to "true" in both services (Cognos Administration > Configuration > click on Dispatchers and Services > :

In BatchReportService, click on Set Properties > Settings > click on "Edit" for the Environment category > add parameter with value = "true"
In ReportService, click on Set Properties > Settings > click on "Edit" for the Environment category > add parameter with value = "true"