I'm trying to do this...

I have a two databases.

The first database I have a list of users and dates. Using a date as a parameter, I get a list of users for that day. The second database has a list of billing info for users.

I want to put a parameter in the main report... and for each record in the main report, pull the bill for that user.

     SELECT User FROM Tbl_1 WHERE Date = Yesterday

Would it be possible to either have the sub-report ran for each record in the main report?

     SELECT Bill from Tbl_2 WHERE User = ?

OR have a list built for a Select * From Tbl2 Where user in ({LIST})?

     SELECT Bill from Tbl_2 WHERE User in {List_Of_Users}

Without going into a rant or extreme detail... Database2 is dated, slow, basic and very messy to deal with. If I do anything more than basic select statements, the return time increases drastically.

So my goal is to do all the select, joins, case statement on Database1, then for each record in results pull bill from Database2.

Just as an example... Doing the select by date on DB1 takes seconds. A similar select in DB2 (Select users on a couple joined tables where date = yesterday, this in that, etc) takes 10 minutes to run. While "select bill from table where user = ?" is almost instant.

I've tried quite a few things and for some reason the Sub Report doesn't seem to be getting the user as a parameter and I can't seem to figure out why. I'll post more detail shortly about how I've got it setup and maybe something will stand out.