COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Kid_in_Cognos on 26 May 2017 03:10:55 AM

Title: Format issue in Excel
Post by: Kid_in_Cognos on 26 May 2017 03:10:55 AM
Hi,

When I am trying to convert the output to the excel 2007, the columns are merging. Please see the attachment for example and look for the rows 4,5 are merging due to the value in the column D. But the customer does not want to get it merged and wants in single row. Any one can help?

Thanks in advance.

Title: Re: Format issue in Excel
Post by: New_Guy on 26 May 2017 07:00:46 AM
Hi,
Did you try the white space property by setting up to no wrap?
Good luck
New guy
Title: Re: Format issue in Excel
Post by: Kid_in_Cognos on 29 May 2017 06:19:03 AM
Yes New_Guy .White space done the magic :). Thanks a Lot.

Kind Regards.