XML Report Datasource - Web Service Issue With Parameters

Hi,

I have set up a report to access a web service and consume one of its methods - a method that returns a datatable set up with a table adapter. Query code example below:





Code Block

<Query>

<Method Namespace="http://AcornExportWebServices.org" Name="GetAllEnquiries"></Method>

<SOAPAction>http://AcornExportWebServices.org/GetAllEnquiries</SOAPAction>

<ElementPath IgnoreNamespaces="true">
GetAllEnquiriesResponse{}/
GetAllEnquiriesResult/diffgram{}/
DocumentElement{}/Enquiry
</ElementPath>
</Query>
This works fine and returns expected results.

However, when I try and return a set of results from a web service that has a parameter specified I get nothing returned. I have tried various different methods including adding the parameter in the dataset dialogue and specifying the parameter and specifying the parameters as in the code example below but still with no joy. Here is the code example with parameters:







Code Block


<Query>

<Method Namespace="http://AcornExportWebServices.org" Name="GetEnquiry">

<Parameters>

<Parameter Name="EnquiryID">

<DefaultValue>1</DefaultValue>

</Parameter>

</Parameters>
</Method>

<SOAPAction>http://AcornExportWebServices.org/GetEnquiry</SOAPAction>

<ElementPath IgnoreNamespaces="true">
GetEnquiryResponse{}/
GetEnquiryResult/diffgram{}/
DocumentElement{}/Enquiry
</ElementPath>
</Query>
When I remove the ElementPath declaration I get back the schema of the table so I believe that is proof that the web method is being contacted but whatever I seem to try I cannot return any results (or the 1 result that the web service should return).

I would be grateful to know if anyone has any ideas or suggestions about this problem.

Thanks.