How to get limited column data from two different data sets in SSRS I have the data on two different data sets and i want to use data from two datasets Ex.: I have 10 employees in one data set and 3 departments on another dataset.

Hi Sateesh, There is no way to use data from two datasets in single table in SSRS. To achieve this you have to do that handling at T-Sql level and than use a single datasets which will have both details(employees and departments)- which were calculated at T-Sql level. Let me know if this helps you or not. Cheers!! Sumit

Can you use T-SQL to combain both queries ? Since SQL Server 2008 you can take a look at LOOKUP function in SSRSBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/