Concatenating Rows from one field into one column
Posted on 2005-05-02
I have a report in which all the fields are being duplicated except for one. Instead of suppressing duplicates and showing up to 10 records because of this one field, I would like concatenate that field so that for each row, all the different values for that field would go into one row.
Data brings back the following of employees with their children:
I want to see the following (using only Crystal):
Sue Jane, Dick, Les
Matthew Tyler, Jordan