I am working on a report and I need to merge a couple of fields. The problem is the fields are essentially the same field. I've done this before in SAS, but I was wondering if there is a way to do this in Crystal. I know I can group the data, but I'm at a lost after that. Here is the example:
Name Type
Joe dog
Joe cat
Joe snake
Ann dog
Ann snake
Expected Results:
Name Type
Joe dog, cat, snake
Ann dog, snake
Any help would be greatly appreciated. Thanks
Edited by: Cortni Haralson on Sep 23, 2008 8:38 PM