Microsoft SQL Reporting Services (SSRS) can use data from SharePoint web services by configuring a Data Source as XML type. SharePoint web services are found under http://[server]/_vti_bin virtual directory. The commonly used web services are _vti_bin/Lists.asmx and _vti_bin/SiteData.asmx. In this post, I'm going to use GetListItem method in _vti_bin/Lists.asmx web service.
As an example, I decided to create a report for all contacts in Washington state. I'm going to add records to Contacts l