InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:28:26 GMT20http://www.sqlservercentral.com/Forums/Topic756396-150-1.aspxNO i cudn`t find the solution. I gave up.. I wrote a web service to fetch data from SharePoint list and dumped it in DB tables with the help of ETL and on the top of the tables I have created my reports...this is much easier.....i guess there is not much details available on the quering list through xml... .thanks,ShaileshSat, 26 Sep 2009 03:27:12 GMTshailesh.thapliyalhttp://www.sqlservercentral.com/Forums/Topic756396-150-1.aspxdid you find the solution of your problem. I get the same error message when I try to create a Dataset to call my webMethod. Please, let me know if you find anything on this issue. thanks.vivek shyamThu, 24 Sep 2009 16:30:06 GMTvivekshyam 25589http://www.sqlservercentral.com/Forums/Topic756396-150-1.aspxHi,I am trying to create SSRS reports using lists.asmx web service. I am trying to create XML data set. I am able to create the data source but when i am writing query <Query> <Method Namespace=http://schemas.microsoft.com/sharepoint/soap/ Name="GetListItems"/><SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction></QueryAnd setting up the parameters listName as AAA5026A-C08E-481C-978B-6C71FFD5C0CE(GUID for my list)It gives me error "An error occurred while setting the Command Text property of the data extension command. The XmlDP query is invalid. (Microsoft Report Designer)"Please suggest how to proceed on this?Thanks in advanceShaileshTue, 21 Jul 2009 02:52:26 GMTshailesh.thapliyal