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