Taking the report out of the equation for the moment, how do you perform the query against these two tables directly against the database? Do you add a few additional tables to the query solely for linking purposes? Or do you use two separate queries, and join the result sets?
Naith