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.