David,
Group the report by the Lender
(Constituent.AlphaSort), then you can write a formula that asks "if the
objects is accessioned (ObjectStatusID), then the groupname = "Our
Museum" otherwise, "Groupname." So:
If {Objects.ObjectStatusID} = 1
then "My Museum"
Else Trim(GroupName
({Constituents.AlphaSort}))
That's one way to do it. I made
a SQL View to merge all the ExhObjXRef, Loan and Object info together, because Loan
and ExhObjXRef data are separated, and that helps as well.
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of Aylsworth,
David
Sent: Tuesday, August 25, 2009 6:25 PM
To: [log in to unmask]
Subject: Checklist sorted by owners when there is no owner
I’m trying to wrap my mind around a crystal report
that I can’t quite figure out. So, of course, I have to pester your
collective wisdom…
We have an exhibition that is predominantly composed of
loans from other institutions, but will also include objects from our own
collection. They wanted a report that grouped the objects that are from
each lender, but they also want the objects that are from our collection to
appear, grouped with our museum as the owner.
For objects that are borrowed, we have an acquisition
related constituent with a role of “owner”, but for works from our
collection, we do not list ourselves as the “owner”. An easy
fix to this would be to just add ourselves as the owner, but I wonder if
there’s a not so difficult way of having the report recognize when things
do not have an owner and knowing to group the objects under our name? Has
anyone written a formula that does something like that? Is it even
possible?
I hate to manipulate the records so that the report will
print out right, but I sort of don’t see any other way around it.
Naturally, I’d appreciate any help you can give
me…
Thanks,
David
David Aylsworth
Collections Registrar
Museum of Fine Arts, Houston
telephone: 713-639-7824
fax: 713-639-7780