Thanks, Christine, and Susan, and all those who answered off-list.  I'll be pondering all of this in the coming days, but it's now officially a snow day up here.  Best to all,

Joe


-----Original Message-----
From: The Museum System (TMS) Users on behalf of Christine Droll
Sent: Thu 12/13/2007 12:24 PM
To: [log in to unmask]
Subject: Re: object-related constituents in reports
 
Joe,

Here's my stab at multiple artists-in-one-record Crystal Report.  It's
not nearly as comprehensive as Susan's (very nice, indeed!), but it may
be another possibility for you.  Our cataloguing differentiates the
artists by Roles, and this report prints out those as well.

(NB:  We've recently upgraded to CR version 11, so you'll need that to
open and use this.)


Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO  64111-1873
Office: 816.751.1333
Fax: 816.751.0499



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Joseph Leduc
Sent: Thursday, December 13, 2007 9:42 AM
To: [log in to unmask]
Subject: object-related constituents in reports

Hello,

I've been a subscriber for the little more than a year since our
institution adopted TMS, but this is my first message to the group, and
it's regarding a question that's been driving me crazy.  I've been
trying to put together a new catalog sheet report, almost all of which
is completely straightforward except for one issue that I can't manage
to figure out.  We frequently have objects, especially prints, that have
mutiple Object-Related Constituents--first the artist, then another
artist the work was done after, sometimes a publisher, perhaps a
printer, etc.  The only consistent aspect of the Display Order is that
the creator of the object at hand will be 1, with the "after" artist
generally 2--but if it's not "after" anyone, it's possible that the
printer or publisher will be 2, there's just no way to have a general
rule.  It's the Role that they play that really identifies them.

The problem is, I need to have separate lines on the catalog sheet where
these Consistuents will be displayed all in their proper place.  Getting
the artist to appear is no problem, but how can I get Crystal Reports to
drop the artist's Display Name where it should go, but also sort out the
other Object-Related Constituents to drop into the "Artist After:",
"Printer:", "Publisher:" slots?  I'm hoping there's some simple way that
my inexperience with Crystal has blinded me to, causing much amusement
to the readers of this list before someone takes pity and points it out
to me.  Then again, I haven't seen any report doing this among the ones
from GS or that we've picked up from here, so I'm a little concerned.
Thanks to anyone who can help.  Best wishes--

Joe Leduc, Associate Registrar
Worcester Art Museum
55 Salisbury Street
Worcester, MA 01609-3196
508-799-4406 x.3029
fax: 508-798-8498
[log in to unmask]