I was getting this error while trying to build a report ( using sql server reporting services) using xml as a data source against Lists web service of SharePoint.
I was making use of GetListItems method of the Lists web service.
Finally the error was fixed by using Fiddler(web debugging tool) within which we easily view the request and responses sent back and forth.
http://www.fiddlertool.com/fiddler/
Using it I checked the soap request being passed to the web service and was able to correct the error.
For using the web service (Lists) I followed the following steps.
Selected Data Source type as XML
Connection String as the url of the web service
http://servername/_vti_bin/lists.asmx
And the following query
<Query>
<Method Namespace=“http://schemas.microsoft.com/sharepoint/soap/“ Name=“GetListItems“>
<Parameters>
<Parameter Name=“listName“>
<DefaultValue>Employee Satisfaction Survey</DefaultValue>
</Parameter>
</Parameters>
</Method>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
</Query>
Bye..
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.
Share It -
Nishant Rana's Weblog 
trjjuigucaiqoxkwwell, hi admin adn people nice forum indeed. how’s life? hope it’s introduce branch 😉
LikeLike
If you want to set other credentials, xml data source doesn’t work in reporting services.
LikeLike
So what was the fix??!!
LikeLike
Okay…so, you had an issue and figured it out??? That was worth a blog entry? How about the friggin solution???
LikeLike
thank you, it works!
LikeLike
Thanks for another informative website. Where else could
I get that type of info written in such an ideal means?
I’ve a challenge that I am just now working on, and I have been at the glance out for such
information.
LikeLike