Prev: date format
Next: conditional color formatting for line chart background color
From: Sam on 1 Jun 2010 12:09
Hello:

I am using a SOAP webservice as the datasource for my report.
How should i specify the report query to retrieve data from a SOAP web
service?

The input to the web service is of type 'filter' which has teh following 4
properties:

The web service wants the request to be of the form:

<soap:Body>
<GetInformationXml xmlns="http://tempuri.org/">
<filter>
<StartDate>dateTime</StartDate>
<EndDate>dateTime</EndDate>
<EmployeeID>string</EmployeeID>
<PolicyID>string</PolicyID>
<OrRoom>string</OrRoom>
</filter>
</GetInformationXml>
</soap:Body>

SQL Server Reporting Services Query format is:

<Query>
<Method Name="GetInformationXML"
Namespace=".............">
<Parameters>
<Parameter Name="Item">
<DefaultValue>/</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
</Query>

How do i send in a complex object as an input parameter?

Appreciate your help.

Regards,
Sam




 | 
Pages: 1
Prev: date format
Next: conditional color formatting for line chart background color