COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nald_p56 on 06 Aug 2007 02:53:48 AM

Title: Control the tab name of excel when the report is view in excel
Post by: nald_p56 on 06 Aug 2007 02:53:48 AM
Hi!

I have a report showing records per country.

I used a repeater to segragate records per country, when i export it to excel, each country is placed in a different tab or sheet in excel.

  The excel sheet name is labeled as page 1-1, page 1-2 and so on..

   Is there a way to control the label of the tab when exported to excel?

  It would be great to hjave the country as the name of each tab.

  Thankz a lot!


 
Title: Re: Control the tab name of excel when the report is view in excel
Post by: COGNOiSe administrator on 09 Aug 2007 10:01:33 PM
I think that has been logged as an enhacement request.
Title: Re: Control the tab name of excel when the report is view in excel
Post by: tupac_rd on 21 Apr 2008 12:53:26 PM
Hi Gurus,

Does any body know if this enhancement request is included in Cognos 8.3 or 8.3 SP1.

Is there a workaround for this ....

Title: Re: Control the tab name of excel when the report is view in excel
Post by: tupac_rd on 22 Apr 2008 03:15:40 PM
Hi Gurus,

In the Fix List document for Cognos 8.3, I saw that the enhancement request has been fixed. I saw a line which says

456483 [Enh] Name Worksheets When Exporting to MS Excel.

If somebody knows how to do this please let me know.

Thanks
2pac