merging fields??

[Former Member]

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

[Former Member · Accepted solution]

Hi Cortni,

Insert a group on Name field and create a formula like this

@Evaluate:

whileprintingrecords;

stringvar txt;

txt:=txt", "{Type field};

now place this formula in details section and suppress the details section

Also create one more formula like

@Initialize:

whileprintingrecords;

stringvar txt:="";

place this fromula in group header and suppress the group header.

Now place the formula and the field Name one beside the other in group footer that shows the out put in horizontal way.

Regards,

Raghavendra

[Former Member · Accepted solution]

Thanks. That worked perfectly.