Stephanie, 

attached are two reports that should work for both objects and object and component records.

Tricky stuff sometimes. We use the SubLevel field for boxes, and the data entry has to be spot on or they don't come up!

Hope this helps.

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Stephanie Hansen
Sent: Thursday, October 08, 2009 1:49 PM
To: [log in to unmask]
Subject: Location by Location Report component trouble

Hello,

We like to use the canned location by location report that came with TMS, 
except that when you query for a location and the record has components, 
the location report will include all those other locations too. I've been running 
them in Crystal so I can filter by room to get just the components that are 
actually in that room, but is there a way I can edit this/create a report to 
work within tms so that the users will be able to filter the results of their 
query in the report for one room or site?

Thanks in advance for any help!
Stephanie Hansen
Milwaukee Art Museum