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