Question reg. formulas 1

[cestonina]

Hi,

Currently I have created two groups (Date and Names) in Crystal Reports. My reports look like the ones below:

10/24/2004
John Doe
Lisa Marie
John Preston
etc.
10/25/2004
Erwin Days
Selvis Richmond
Welwin Darrack
etc.

I would like to achieve the above with the following,

10/24/2004
John Doe, Lisa Marie, John Preston, etc.
10/25/2004
Erwin Days, Selvis Richmond, Welwin Darrack, etc.

This way I can save huge amount of space in each page. Any ideas how I can achieve this via formula? I tried to use Multi-column in details pane properties but apparently it would affect the alignment of the first group as well.

Appreciate any help and thanks in advance.

Regards,
Chris

 

[synapsevampire]

The version of Crystal is important here, as with most questions.

Group by the date, and then use the 3 formula method:

GH1 formula
whileprintingrecords;
stringvar Names:=""

Details
whileprintingrecords;
stringvar Names:=Names+{table.name}

GF1 formula (display at the group footer)
whileprintingrecords;
stringvar Names

You may run out of room as the max output for formulas in CR 8.5 and below is 254

-k

 

[lbass]

To include commas, change SV's detail formula to:

whileprintingrecords;
stringvar Names:=Names+{table.name}+", ";

Change the display formula to:
whileprintingrecords;
stringvar Names;
left(Names,len(Names)-2);

-LB

 

[cestonina]

Thanks guys. Will try this out.

Cheers,
Chris