<p>Hi Everyone,</p>
<p> </p>
<p>Looking for help with using a web service data source. I've got my web service working in my report design using 2 parameters for a single array element having 2 children:</p>
<pre class="_prettyXprint _lang-xml">
<SOAP-ENV:Body>
<m:GetMetrics xmlns:m="http://data.qsi.madweb.madico.com">
<lots>
<LotsArray>
<LotNo>&?LotNumber?&</LotNo>
<ControlLotNo>&?ControlLot?&</ControlLotNo>
</LotsArray>
</lots>
</m:GetMetrics>
</SOAP-ENV:Body>
</pre>
<p>This works well for one element, however, I need to consume this service with 1 or more LotArray elements, like this:</p>
<pre class="_prettyXprint _lang-xml _linenums:1">
<SOAP-ENV:Body>
<m:GetMetrics xmlns:m="http://data.qsi.madweb.madico.com">
<lots>
<LotsArray>
<LotNo>&?LotNumber?&</LotNo>
<ControlLotNo>&?ControlLot?&</ControlLotNo>
</LotsArray>
<LotsArray>
<LotNo>...</LotNo>
<ControlLotNo>...</ControlLotNo>
</LotsArray>
<LotsArray>
<LotNo>...</LotNo>
<ControlLotNo>...</ControlLotNo>
</LotsArray>
</lots>
</m:GetMetrics>
</SOAP-ENV:Body>
</pre>
<p>I've attempted to modify/replace the elements with script in the beforeOpen event with no success. Is this the right approach, or is there a better option?</p>
<p> </p>
<p>LotNumber and ControlLot are returned from an outer table having 1 or more rows which will be needed to pass to the service. The service will return a result set of a differing row count depending on the combination of Lots; i.e., there is not a one-to-one relationship between the outer table and resulting resultset from the web service.</p>
<p> </p>
<p>Daron</p>
