Forgot to mention: you'll need to suppress group header and details, and the group footer display formula is what you actually display (i.e. the concatenated list of names).

Ariana

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of French, Ariana
Sent: Thursday, November 29, 2012 3:04 PM
To: [log in to unmask]
Subject: Re: Crystal Reports - concatenating values

Hi Jeri,

Here's what I use for a similar purpose:

In group header, use a formula (I call it "reset"):
whileprintingrecords;
stringvar x := "";

In details, use a formula (I call it "accumulate"):
whileprintingrecords;
stringvar x := x & {Constituents.DisplayName} & ", ";

In group footer, use a formula (I call it "display"):
whileprintingrecords;
stringvar x;
if length(x) > 2 then
left(x,len(x)-2);


and adjust the "-2" portion to whatever makes sense for your particular formatting needs to lop off the final comma. Hope this helps,

Ariana


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri
Sent: Thursday, November 29, 2012 2:45 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Crystal Reports - concatenating values

Hi All,

To have all of the co-curators of an exhibition, or multiple artists of an artwork, appear in a Crystal Report as a single string:

Name, Name, Name

How would you do that?

Thanks!
Jeri

Jeri Moxley
Manager, Collection and Exhibition Technologies
The Museum of Modern Art
11 West 53 Street, New York, NY 10019-5497
Tel. (212) 708-9599 Fax. (212) 333-1102
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.