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

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.