Hi Gabriela,

I've taken and sent my staff to classes at New Horizons (they have a location in Buffalo, too) for general Crystal Reports software training and to the Gallery Systems reports class to get the low-down on TMS table structure.

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


On Fri, Nov 30, 2012 at 10:24 AM, Gabriela Zoller <[log in to unmask]> wrote:

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 Max} + " and " + {@Source Min}
Else
If DistinctCount ({Constituent.CONSTITUENTID}, {Objects.SORTNUMBER}) = 3 then
    {@Source Max} + " , " + {@Source Mid} + " and " + {@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

>>> On Thursday, November 29, 2012 at 12:12 PM, <[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]> 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]] 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.


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. 

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.


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.