Since I cannot join two different datasets in SSRS I used MS Access to acomplish this. I created an Access databases and created some tables linked to two different SQL servers. Then I created a query to join the information together; Then I created a dataset in SSRS that pulls information from the Query, which is the data combined that I needed. All is well right? My question is.. When SSRS runs the report and connects to the Access .mdb database does the Access db then connect to get the most recent data from SQL? Or do I have to open Access itself before the report runs each time to update Access with the most current SQL data? I got the idea to use Access to join information from seperate sql servers from these forums. But this weekend I thought...How does the mdb update the information without Access being opened. Hopefully it does automatically update the linked table information or I will have to find another solution. My technical skill limitations stopped me from trying other things mentioned in these forums.

Why dont you create a linked sql server and run the report from it instead of adding an additional access database-------------------------------------------------------- Surender Singh Bhadauria

Thanks Surender. Ive seen that linked server recomendation before but I didnt know enough about it to do it. Well I read and tackled it today. The hard part was figuring out you need to use alias's in the query. All good now. Thanks for the motivation to do it. But I would still like to know the answer to my question.