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