explain XML as datasource in reporting services

Hi,

its new for me to use XML as datasource and webservices. Can you please explain below snippets

<Query>
<SoapAction>http://tempuri.org/GetDataset</SoapAction>
<Method Namespace="http://tempuri.org/" Name="GetDataset">
<Parameters>
<Parameter Name="sql" Type="String">
<DefaultValue>Select * From Customers</DefaultValue>
</Parameter>

</Parameters>
</Method>

<ElementPath IgnoreNamespaces="true">GetDatasetResponse{}/GetDatasetResult{}/diffgram{}/NewDataSet{}/Results</ElementPath>
</Query>

Read this article below

http://www.codeproject.com/cs/webservices/myservice.asp

|||

Hi,

The code you provide are queries for Datasets with XML Data Sources, a dataset includes a query, which is the command text that runs against a data source to retrieve a specific result set. The result set maps to the collection of fields in a dataset. You can also set filter values on the dataset to limit results returned from the data source. The following are possible XML Query elements:

XML data source

Required XML elementsOptional XML ElementsFor a Web service<Method Namespace="namespace" Name="MethodName" />-- or --<SoapAction>soap action</SoapAction><ElementPath> element path </ElementPath><Method Namespace="namespace" Name="MethodName" />-- or --<SoapAction>soap action</SoapAction>For an XML document<ElementPath> element path </ElementPath>For an embedded XML document<XmlData> inner XML </XmlData><ElementPath> element path </ElementPath>-- or --<ElementPath IgnoreNamespaces="true"> element path </ElementPath>

Besides, here are some materials for you.

Step-by-step instructions on how to retrieve XML data for a Reporting Services report using the XML data processing extension
http://msdn2.microsoft.com/en-us/library/ms345334.aspx

Defining Report Datasets for XML Data
http://msdn2.microsoft.com/en-us/library/ms159741.aspx

Thanks.