Concatenating Multiple Rows - Repeater

[keating101]

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

[Francis aka khayman]

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

[keating101]

Any body out there that has a possible solution ?

[Francis aka khayman]

whoah? i'm not good enough for you?  ;D

[keating101]

Hi Khayman,

Thanks for your idea but i couldnt get it to work.
Cheers

[Lynn]

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.

[keating101]

hi Lynn,
Thanks for your help - seems to have done the trick
Shaun