Rob's suggestion might be the simplest, especially if you don't need to qualify with prefixes and suffixes, etc.

Otherwise,  Crystal Reports is only a two-pass system, so Next() or Previous() won't work for three or more linked values. We have a list view that concatenates Makers using a SQL user functions that concatenates the values from a view. This kind of thing, once built into your database, can solve problems elsewhere, and can be used in reports as well.

- Jeff

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