Cognos Execl Format Issue

[JaiCognos]

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

[the_xxx]

Hi,

I hope this will help you.

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

--Satish

[geinel]

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

[ml11758]

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

ML