Reporting Services and XML Datasource

Reporting Services and XML Datasource

Querying a XML Datasource

Query:

<Query>

    <SoapAction>http://ns.tld/MethodName</SoapAction>

    <Method
Namespace="http://ns.tld/"
Name="

MethodName" />

    <ElementPath
IgnoreNamespaces="True">*</ElementPath>

</Query>

Passing Parameters

You only have to define your parameters in the parameter tab of your dataset. They are passed automatically to the Webservice Method. If you want to define your parameter yourself and not use a Reporting Services Parameter, just type

<Query>

    <SoapAction>http://ns.tld/MethodName</SoapAction>

    <Method
Namespace="http://ns.tld/"
Name=" MethodName">

        <Parameter
Name="ParamName">

            <DefaultValue>ParamValue</DefaultValue>

        </Parameter>

    </Method>

    <ElementPath
IgnoreNamespaces="True">*</ElementPath>

</Query>

Leave a Reply