Complex report

[sven2]

Hello,

for the moment I have a report that is showing for each customer a product. It look like this:

customer a - product 1
customer a - product 3
customer a - product 4
customer b - product 1
customer b - product 2

I want to change this like:

customer a - product 1, product 3, product 4
customer b - product 1, product 2

Is this possible? And if so what is the way to do it?

Best regards,
Sven.

 

[pr2-eugin]

I think Allen Browne's - Concatenate values from related records, is the one you are looking for. Good Luck !

 

[bigalpha]

I think Allen Browne's - Concatenate values from related records, is the one you are looking for. Good Luck !

Yep. I've used this method to create concatenated queries.