SummaryConfiguring SSRS to use an XML Data Source can be done with just a few steps. First, you add a shared data source that points to your web service. Second, you add a data set that defines the parameters for the web method. Once you have these defined you can build your report as normal. The only caveat I have found is the lack of strongly typed fields returned from the web service. You will need to cast each field appropriately within the report for grouping and formatting functions to work.
Add Shared Data Source
- Right Click Shared Data Sources
- Choose Add New DataSource
- Give it a name and choose Type: XML
- Enter the path to the web service as the connection string
- Click OK
Add Data Set
- Right click Datasets
- Click Add Dataset...
- Enter a name
- Choose the name of your shared data source
Enter the following query replacing WebMethodName and WebMethodParameter. Include as many parameters as necessary. Leave the tempuri.org as is.
<Query> <SoapAction>http://tempuri.org/WebMethodName</SoapAction> <Method Namespace="http://tempuri.org/" Name="WebMethodName"> <Parameters> <Parameter Name="WebMethodParameter"></Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="true">*</ElementPath> </Query>
- Click Parameters
- Add each parameter required for your web service
- Click OK