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.
|