COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nikki_cognos on 25 Nov 2013 11:56:24 AM

Title: Tab name truncated while exporting a report into Excel format
Post by: nikki_cognos on 25 Nov 2013 11:56:24 AM
I have the below issue in one of my report developed in Cognos 10.2.

While testing, I noticed that some of the tab names in the UAT reports appear to have the tab name truncated to add the number suffix "_#".  In Production reports, the tab name is complete and the tab number suffix "_#" is truncated

Please refer the attached screenshot. In the attachment, tabs marked with Red circle is giving the issue.

Could you please give suggestions to resolve this issue asap.
Title: Re: Tab name truncated while exporting a report into Excel format
Post by: bdbits on 25 Nov 2013 05:44:00 PM
A bit of a guess here as I need to be leaving in a minute and no time to test, but... I note the truncation occurs on the 28th character in both instances. Since this does not happen on prod, I am going to venture a guess that your Cognos server admin changed an Excel option. You should ask them to make the same changes to your UAT environment.
Title: Re: Tab name truncated while exporting a report into Excel format
Post by: nikki_cognos on 25 Nov 2013 08:53:37 PM
Many thanks for your reply.

As per my Admin, some fix pack is available in UAT, but it is not in PROD.

Is this issue related to only fix pack? Please advice if any permananet solutions available from reporting side wihout any involvement of Admin to fix this issue.
Title: Re: Tab name truncated while exporting a report into Excel format
Post by: nikki_cognos on 26 Nov 2013 07:04:14 AM
Can you please tell me the Excel options available to the Cognos Admins to define the settings for excel exports.
Title: Re: Tab name truncated while exporting a report into Excel format
Post by: Grim on 26 Nov 2013 12:20:19 PM
Might want to see my post here:
http://www.cognoise.com/index.php?topic=23250.0