Concatenate rows of data by a common group
Posted on 2006-06-04
Hello, I'm using Crystal 8.5. I've got a db with two columns - Region and Zip Code. For each Region there are multiple Zip Codes. I need to display all the zip codes for each region in 1 row. For example:
Result would be:
NY-NJ-MA 23412, 74657, 38472
TX-LA-OK 09384, 01983, 28952, 37561, 04827, etc
There are about 30 regions and some regions have 60+ zip codes. I tried to use variables where the details part added the next zip in the list to the last (with ", " in between), reset on each Region and the display in the Region footer. This worked until the zips for each region became too long. Any other suggestions...