TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Crystal Reports - concatenating values
From:
"French, Ariana" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 29 Nov 2012 20:07:00 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2248 bytes) , text/html (10 kB) 
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.

ATOM RSS1 RSS2