Combining Multiple Details

[CappsRLO]

In my report I have a total of 8 fields in the Details section. Only 2 of the 8 ever have different data.
Currently each row duplicates for each time there is new data in the 2 fields. It would look something like this:
001 Row 1 05/10/2008 123 999
001 Row 1 05/10/2008 321 999
001 Row 1 05/10/2008 321 111

As you can see the last 2 columns are the only fields that ever change.
I would like to combine the multiple rows into a single field like this:
001 Row 1 05/10/2008 123, 321 999, 111

Any suggestions?

 

[lbass]

Collect the values in variables that are reset in the group header, accumulated in the detail section, and displayed in the group footer. Group on fields that are repeating.

-LB