COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: keating101 on 10 Jun 2014 09:45:50 PM

Title: Concatenating Multiple Rows - Repeater
Post by: keating101 on 10 Jun 2014 09:45:50 PM
Hello,

I have multiple records which i want to concatenate into one record (it is a note record that is stored in multiple lines).

I have used a repeater table successfully to do this. Problem is once i further build on this report and add in some fact items, the repeater loses its data - see attachment.

Any ideas how to get around this?

Thanks in advance
Shaun
Title: Re: Concatenating Multiple Rows - Repeater
Post by: Francis aka khayman on 10 Jun 2014 10:19:55 PM
I'm not quite sure about this but if that is data item in a list, you can try to set the group property to the appropriate group
Title: Re: Concatenating Multiple Rows - Repeater
Post by: keating101 on 14 Jun 2014 06:58:39 PM
Any body out there that has a possible solution ?
Title: Re: Concatenating Multiple Rows - Repeater
Post by: Francis aka khayman on 15 Jun 2014 08:46:24 PM
whoah? i'm not good enough for you?  ;D
Title: Re: Concatenating Multiple Rows - Repeater
Post by: keating101 on 15 Jun 2014 11:54:06 PM
Hi Khayman,

Thanks for your idea but i couldnt get it to work.
Cheers
Title: Re: Concatenating Multiple Rows - Repeater
Post by: Lynn on 16 Jun 2014 07:02:50 AM
What does the master detail relationship look like between your list and your repeater? Did you take a look at the generated SQL with and without the fact columns or with and without the repeater? I suspect you'll find some clues there.
Title: Re: Concatenating Multiple Rows - Repeater
Post by: keating101 on 16 Jun 2014 09:07:03 PM
hi Lynn,
Thanks for your help - seems to have done the trick
Shaun