Dear Kate, Thank you! Best, Gabriela Gabriela Zoller Art Cataloger Department of Research Resources Albright-Knox Art Gallery 1285 Elmwood Avenue Buffalo, New York 14222 716.270.8277 (ph) [log in to unmask] -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Collen, Kate Sent: Friday, November 30, 2012 3:29 PM To: [log in to unmask] Subject: Re: Crystal Reports - concatenating values I highly recommend Ken Hamady www.kenhamady.com. He is an expert in Crystal Reports & familiar with museum data sets. He can probably travel to your museum or use GoToMeeting to connect to your PC to help with one-on-one report editing. ~Kate Collen Smithsonian National Postal Museum [log in to unmask] ________________________________________ From: The Museum System (TMS) Users [[log in to unmask]] On Behalf Of Gabriela Zoller [[log in to unmask]] Sent: Friday, November 30, 2012 10:24 AM To: [log in to unmask] Subject: Re: Crystal Reports - concatenating values Somewhat related to this topic: can anyone recommend a good course/program for learning about writing Crystal Reports? Best, Gabriela Gabriela Zoller Art Cataloger Department of Research Resources Albright-Knox Art Gallery 1285 Elmwood Avenue Buffalo, New York 14222 716.270.8277 (ph) [log in to unmask] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey Sent: Thursday, November 29, 2012 4:38 PM To: [log in to unmask] Subject: Re: Crystal Reports - concatenating values That's cool! From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Carole Campbell Sent: Thursday, November 29, 2012 3:52 PM To: [log in to unmask] Subject: Re: Crystal Reports - concatenating values Hi Jeri, I use Minimum, Maximum and NthLargest when I know I have a limited number of possibilities and want to change up the text between the values: SourceMin Formula: Minimum{Constituent.DISPLAYNAME}, {Objects.SORTNUMBER}) SourceMid Formula: NthLargest(2,{Constituent.DISPLAYNAME}, {Objects.SORTNUMBER}) The "2" chooses the second occurrence SourceMax Formula: Maximum({Constituent.DISPLAYNAME}, {Objects.SORTNUMBER}) Print Source Formula: If DistinctCount ({Constituent.CONSTITUENTID}, {Objects.SORTNUMBER}) = 1 then {Constituent.DISPLAYNAME} Else If DistinctCount ({Constituent.CONSTITUENTID}, {Objects.SORTNUMBER}) = 2 then {@Source<mailto:%7b@Source> Max} + " and " + {@Source<mailto:%7b@Source> Min} Else If DistinctCount ({Constituent.CONSTITUENTID}, {Objects.SORTNUMBER}) = 3 then {@Source<mailto:%7b@Source> Max} + " , " + {@Source<mailto:%7b@Source> Mid} + " and " + {@Source<mailto:%7b@Source> Min} I group by Object SortNumber and place my final formula in the Group Footer area. Thanks, Carole Carole Campbell Registrar for Collections Management J. Paul Getty Museum 1200 Getty Center Drive, Suite 1000 Los Angeles, CA 90049 Tel: (310) 440-7083 Fax: (310) 440-7746 [log in to unmask]<mailto:[log in to unmask]> >>> On Thursday, November 29, 2012 at 12:12 PM, <[log in to unmask]<mailto:[log in to unmask]>> wrote: NICE! Thanks, Ariana! 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 On Thu, Nov 29, 2012 at 3:07 PM, French, Ariana <[log in to unmask]<mailto:[log in to unmask]>> wrote: 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]<mailto:[log in to unmask]>] On Behalf Of French, Ariana Sent: Thursday, November 29, 2012 3:04 PM To: [log in to unmask]<mailto:[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<tel:%28212%29%20708-9599> Fax. (212) 333-1102<tel:%28212%29%20333-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]<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]<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. Albright-Knox Art Gallery Celebrating 150 Years 1862 - 2012 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. Albright-Knox Art Gallery Celebrating 150 Years 1862 - 2012 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.