Hi In my report, i need join data from both sql server and web service and display that on ssrs report. is this possible in ssrs ?

Hi rukmar-xp, In SQL Server Reporting Services(SSRS), we can only join two SQL Server datasets by redesigning the query statement. In this case, we can design a new web serivce to merge the two data, and then retrieve data from this new web service directly in the SSRS. If in SSRS 2008 R2, we can use the new functions(Lookup functions) to get data from other datasets. For more information about this new feature, please see "Lookup Functions" in the following article: http://msdn.microsoft.com/en-us/library/ms170438.aspx#Aggregates If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT