I know I have seen some ideas and threads about this, but it is not really what I need. I have a report in CR XI that seems to be on the right path. The problem I am having is one field that needs to be in details could provide multiple results (products and services) which duplicates all the records. Some customers I'll have 3 lines, the next 9 ... depending on how many P&S they have.
What I have done is moved all fields from the details section to group1 which so far seems fine and left my P&S field in details.
The output is normal:
What I need is this: prod1, prod2, prod3, prod4, etc.
Any ideas greatly appreciated.