COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 20 Aug 2015 07:58:57 AM

Title: report issue when export to excel
Post by: kvchow on 20 Aug 2015 07:58:57 AM
Hi ,

I have 2 pages in report ,I ran the report and when i export to excel page 1 comes in first tab and page 2 comes in second tab,it's working correctly but numbering i am getting like in first tab page_1 and in second tab in excel sheet getting like page_2

but my user wants 2 names like detail and summary but i am getting detail_1,summary_1 in excel

How to acheive this one
Cognos 10.1 is env

Thanks
Title: Re: report issue when export to excel
Post by: BigChris on 20 Aug 2015 08:35:03 AM
You can't do it I'm afraid - I believe you can do it in later versions, but I can't do it in 10.2. I seem to remember it being in the 10.2.2 release, but I can't swear to that.
Title: Re: report issue when export to excel
Post by: ramakrishnamanne on 20 Aug 2015 09:00:00 AM
Try this one..

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014768376
Title: Re: report issue when export to excel
Post by: kvchow on 20 Aug 2015 09:21:52 AM
Thanks Bigchris&Manee

I am not able to do in Cognos 10 version

Any idea?
Title: Re: report issue when export to excel
Post by: BigChris on 20 Aug 2015 09:58:22 AM
Upgrade to 10.2.2?

https://www.ironsidegroup.com/2014/11/05/whats-new-in-cognos-10-2-2-the-top-10-features-you-need-to-know/
Title: Re: report issue when export to excel
Post by: MFGF on 20 Aug 2015 10:09:10 AM
Quote from: BigChris on 20 Aug 2015 09:58:22 AM
Upgrade to 10.2.2?

https://www.ironsidegroup.com/2014/11/05/whats-new-in-cognos-10-2-2-the-top-10-features-you-need-to-know/

Sadly the worksheets in Excel still appear with -1 -2 etc at the end of the page names in 10.2.2. I just tried it.

MF.
Title: Re: report issue when export to excel
Post by: kvchow on 24 Aug 2015 03:53:02 AM
Hi all,

Thanks for your responses,issue got resolved by using this link

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

Thanks
kvchow