Skip to Content
Former Member
Aug 26, 2009 at 08:01 AM

Combine Multiple Records in Crystal Reports


I have a table with our clients buying preferences, The first three columns is the client ID, Name and Last name and the fourth and fifth columns is the clients buying preference, I have multiple records per client depending on the preference the client has chosen.

ID First Name Surname Type Suburb

5 John Smith House Melrose

6 John Smith House Rosebank

7 John Smith House Kilarney

8 John Smith Cluster Melrose

9 John Smith Cluster Rosebank

10 John Smith Cluster Kilarney

I need to combine the fourth column into one string and the same for the fifth column.

ID First Name Surname Property Type Suburb

5 John Smith House, Cluster Melrose, Rosebank, Kilarney

I have been getting closer by using the formula in a similar post,

but still struggling a bit

Any help with this would be greatly appreciated.