COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: laxmnarao83 on 28 Sep 2012 02:06:52 AM

Title: Excel sheet name in cognos report studio 10.1.1
Post by: laxmnarao83 on 28 Sep 2012 02:06:52 AM
Hi,

I have created a list report using page sets. And also applied page set sorting on Product line, so each product line data would display on each page.
Same report I am exporting in to excel format. Hence each product line generates a separate excel sheet in excel.

Now my concern is I want to show the product line name of each sheet. But currently sheet name is shown as page name e.g. page-1, page-2, page-3, page-4.......

Is it possible to give sheet name dynamically or is there any trick to do so?

Thanks in advance.
Laxman Rao

Title: Re: Excel sheet name in cognos report studio 10.1.1
Post by: tjohnson3050 on 28 Sep 2012 11:27:02 AM
No

http://www.cognoise.com/community/index.php/topic,15888.msg52899.html#msg52899
Title: Re: Excel sheet name in cognos report studio 10.1.1
Post by: MFGF on 04 Oct 2012 09:36:41 AM
Hee hee. Deja vu? :)
Title: Re: Excel sheet name in cognos report studio 10.1.1
Post by: tjohnson3050 on 04 Oct 2012 09:55:41 AM
Amazing how often this comes up  :)

IBM really should add this functionality...
Title: Re: Excel sheet name in cognos report studio 10.1.1
Post by: MFGF on 04 Oct 2012 10:59:03 AM
Thay will probably do it the day after I retire :)
Title: Re: Excel sheet name in cognos report studio 10.1.1
Post by: mr j on 07 Jun 2013 03:45:28 AM
Up!    ;D

I mean, really, they should...

Quote from: tjohnson3050 on 04 Oct 2012 09:55:41 AM
Amazing how often this comes up  :)

IBM really should add this functionality...