Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list).
Here is what I've been doing:
Created a simple SharePoint list in a test site - only one column (Title) with one record of data.
Started Visual Studio 2008 and created a new Report Server Project Wizard project.
I named the data source "dsTest". Type: "XML". As connection string I used:
http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)".
Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box:
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" />
</Query> Clicking Next I get this error:
An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
Now if I view the Details when trying it inside the Query Builder I get this:
View Complete Post