Since they added collections a while back, many of the reports have not been updated to filter by the collection you are currently in. I have several collections and I have want lists within each. When I go to my Frank Thomas collection and run the report to check my Want List with other For Sale/Trade Lists, I get results for all collections. I would expect to see only my Frank Thomas wants. If you have multiple collections and think this would be useful, please help excalate this feature by voting with the link below. Thanks.
New Feature Tracker | Trading Card Database (tcdb.com)