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