• If you could use SSRS 2008 R2 or later version, you can utilize the SSRS Lookup features that joins multiple datasets. Follow the below link to use multiple datasets in report using LOOKUP:

    http://www.sqlcircuit.com/2012/03/ssrs-2008-r2-lookup-how-to-use-multiple.html

    Thanks,

    Vishal