show values from multiple records in 1 cell / same line

[gemu]

Hi,

For example: I have some products that come in different colors and I don't know in advance how many color variations each product can have. Now I have to prepare a report on these products and a normal report would give me as many rows as there are colors for each product. I can group the product attributes but at the end I still have a row per color.

Now I just want 1 line per product and the colors in 1 cell on this line. This can be comma separated or just with a white space in between, whatever, as long as they are in the same cell.

Anyone any ideas how to achieve this? I hope the example is clear, tried to keep it simple...

[Lynn]

You could look at a crosstab layout or use a list with a repeater (or repeater table container) in a column set with a master-detail to the list.