COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: valiant on 19 Nov 2013 09:16:59 PM

Title: One column to slipt to multi-column when I export report to Excel 2007
Post by: valiant on 19 Nov 2013 09:16:59 PM
Dear,
   
    I'm working on Cognos 10.2. I designed one list in my report as Excel format. There are two rows in list header. When I export report to HTML or PDF, my report is good. However, when I export report to Excel 2007, my column in list sliptted to multi-column. How can I fix this issue ?  :-\


Thanks
Title: Re: One column to slipt to multi-column when I export report to Excel 2007
Post by: Grim on 20 Nov 2013 07:56:56 AM
This will fix that right up. Just keep in mind the Note...
http://www-01.ibm.com/support/docview.wss?uid=swg21440556

NOTE: This functionality was added to the product and is not available in all releases. Please contact Customer Support if adding this advanced setting does not produce the desired change in Excel 2007 output.
Title: Re: One column to slipt to multi-column when I export report to Excel 2007
Post by: valiant on 26 Nov 2013 12:18:45 AM
Hi Grim,

    I tried to work as you guide but my issue did not resolve. Are there any ideas ?

Thanks
Title: Re: One column to slipt to multi-column when I export report to Excel 2007
Post by: Grim on 26 Nov 2013 12:21:53 PM
Quote from: valiant on 26 Nov 2013 12:18:45 AM
Hi Grim,

    I tried to work as you guide but my issue did not resolve. Are there any ideas ?

Thanks

Yeah...
Quote from: Grim on 20 Nov 2013 07:56:56 AM
NOTE: This functionality was added to the product and is not available in all releases. Please contact Customer Support if adding this advanced setting does not produce the desired change in Excel 2007 output.