Is it possible to perform a web service call inside a reporting services report? (i.e. use a WS call for a data source)
The Report Server Web service is an XML Web service with a SOAP API. It uses SOAP over HTTP and acts as a communications interface between client programs and the report server.
Three types of SSRS reporting services are: Microsoft SQL Server Integration services which integrate data from different sources. Microsoft SQL Server Analytical service which helps for the analysis of the data. Microsoft SQL Server Reporting service allows for generating a visual report of the data.
There are two ways to create an SSRS project, either manually or with a wizard.
The web service URL is to access the SSRS Report Server. It is the URL where the reports get deployed to. You also get a raw report listing from this location if you enter it into your browser.
http://technet.microsoft.com/en-us/library/aa964129.aspx
This white paper will give you information on using both webservices and other XML based sources as a datasource for your reports.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With