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