Print Page - Cognos Execl Format Issue

Title: Cognos Execl Format Issue
Post by: JaiCognos on 28 Jul 2010 01:35:50 PM

Hi All,

I have a cognos report studio report which has 20 report pages and when i am trying to run in excel the data gets exported to excel and tab names of the excel sheet differ from the report page name.

For Eg: If the two report page names as SALES,PRODUCT in Reort when exported to excel the the tab name comes as SALES_1 and PRODUCT_20. Is there any setting i could make in server to exclude this number and get exact report page name which has been mentioned in report.

User is ok if number comes but he wants this number to have some sequence. But i want to understand on what basis cognos attaches this number to report page name when the multiple page report exports to excel.

Please let me know if any server setting has to be changes or any other solution.

Thanks in Advance.
Jai

Thanks in Advance.
Jai

Title: Re: Cognos Execl Format Issue
Post by: the_xxx on 23 Sep 2010 05:41:38 PM

Hi,

I hope this will help you.

http://www-01.ibm.com/support/docview.wss?uid=swg21343184

--Satish

Title: Re: Cognos Execl Format Issue
Post by: geinel on 19 Sep 2012 12:37:07 PM

Hi,
I am having a same issue. The above doc is for cognos 8 not cognos 10. I tried and no luck!
kindly help...

Title: Re: Cognos Execl Format Issue
Post by: ml11758 on 14 Aug 2013 07:43:20 PM

Thanks for the link. Got rid of the appending numbers.

ML

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: JaiCognos on 28 Jul 2010 01:35:50 PM