I'm just starting to use SQL Server 2005 Reporting services to fetch and use SharePoint 2007 lists data. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: Connection String: http://<YourServerName>/sites/sitename/_vti_bin/Lists.asmx Xml Query: <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetList"> </Method> <ElementPath IgnoreNamspaces="true">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath> </Query> Dataset Parameter: Name: listName, Value: The name of the list you want from the site. Problem: But while doing so I am getting the following error: =================================== An error occurred while executing the query. Failed to execute web request for the specified URL. (Microsoft Report Designer) =================================== Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions) ------------------------------ Program Location: at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteWebRequest(ICredentials credentials) at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.Execute() at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.<>c__DisplayClass1.<ExecuteReader>b__0() at Microsoft.ReportingServices.DataExtensions.XmlDP.WebRequestHelper.ExecuteServerCallAsNtUser(ServerCall serverCall, WindowsIdentity ntUser) at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.ExecuteQuery() =================================== <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.</faultstring><detail><errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/"> View does not exist. The page you selected refers to a view that does not exist. It may have been deleted by another user. </errorstring><errorcode xmlns="http://schemas.microsoft.com/sharepoint/soap/">0x82000005</errorcode></detail></soap:Fault></soap:Body></soap:Envelope> ------------------ Question: What is causing this problem and how can I solve this? I have spend a lot of time solving this one but not getting the desired result or online help. The only data i am able to fetch is GetList and GetListCollection Looking fwd for your assistance!