COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srinivas.inbox83 on 24 Sep 2013 07:19:20 AM

Title: formatting issue in Excel 2007 because of repeater
Post by: srinivas.inbox83 on 24 Sep 2013 07:19:20 AM
Hi
I am using cognos 10.1 version
In my report header I need to show report title which has a column ASSOC , it is fetching multiple values so we have used a repeater to show them in a single line separated by comma , the problem is when I run report in excel 2007 , the values are coming in different cells
eg: report title is say ,  xxxxxx 10,2 xxx this has to come in one cell instead it is splitting in to 3 cells like xxxxxx    10 ,      2

is there any way to achieve this in single cell

Thanks in advance ...
Title: Re: formatting issue in Excel 2007 because of repeater
Post by: srinivas.inbox83 on 01 Oct 2013 05:20:24 AM
Hi

looking for some help on this issue, I was trying hard but no luck .. thnx....
Title: Re: formatting issue in Excel 2007 because of repeater
Post by: Lynn on 07 Oct 2013 12:13:08 PM
Did you try putting the repeater inside a block?
Title: Re: formatting issue in Excel 2007 because of repeater
Post by: srinivas.inbox83 on 17 Oct 2013 02:23:16 AM
Yes I tried to put the repeater in block, table and even in a list ... but no luck .... still the same issue