I had created a two list one is reportlist1 and another is reportlist2 How can I create SSRS report from these two list I write query as <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>{393F0FFB-BC8E-4DE7-88C6-45A721791290}</DefaultValue> </Parameter> <Parameter Name="listName1"> <DefaultValue>{713134AD-6EB0-4D53-A1BA-99471F87AAE9}</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="True">*</ElementPath> </Query> But it shows values from first list only. How can I get values from both lists ?

Hi vyanku,By default, we can only get values from one list in one query.To get values from two list, I would suggest you creating two dataset in Reporting Services, then geting values from each list in each dataset.I have confirmed with SharePoint team, that we are not able to join two SharePoint library list using list web service.If you have any more questions, please feel free to ask.Thanks,Jin ChenJin Chen - MSFT

OK But how can I crate two dataset in in reporting service for one report ?Because when we create a report it shows only one dataset not other one .Can you explain please. Any link ?

Hi vyanku,We can create the second dataset as we done for the first one.For your information:http://msdn.microsoft.com/en-us/library/ms160345.aspxThanks,Jin ChenJin Chen - MSFT

You can create multiple datasets and use it in single report.You just need to create the required datasets and use it in the report design view of the BIDS.Regards, KarthikShanth. "Mark as Answer" if this helps you!

Lots of people use SLAM, an open source tool our company maintains, to do this. Check out: http://slam.codeplex.com.

Hi Jinchun, I have created two dataset to create SSRS report from the two list. But in query expression and table in BIDS, it does not allow to use second dataset. In expression, it does not show any field of the second dataset and when we try to add field of second dataset to the table it gives error "Only fields from the current dataset can be added" Please help how to use 2 dataset at a time in the SSRS report? Thanks for your help in advance. - Ayaz Shaikh