list of values (like an array) in a Cognos 8.2 report

[mikiap]

Hi all

I have 2 tables
table1:
cr_id
1
2
3
and
table2:
cr_id, location
1 loc1
1 loc2
2 loc3
3 loc3
3 loc4

I need to show in the excel output the list of cr_ids and associated locations separated by comma for example. Like below
1 loc1, loc2
2 loc3
3 loc3, loc4

I only managed so far with a master-detail relationship, to show the locations one under the other one. But the requirement from the customer is to show all locations for one cr_id in one row.

Thank you very much for an idea
Miki
Does anyone know if this is possible?