0

i need to get data from web service via reporting services. the xml schema i got showing structure as follow:

........
<element name="methodname">
<complextype>
<sequence>
<element name="prm-in">
<complextype>
<element name="prm1" type="decimal">
<element name="prm2" type="decimal">
.......
</sequence>
</complextype>
</element>

how can i retrieve data from this schema via the query designer of the ssrs?

Y.D
  • 95
  • 8

1 Answers1

0

I solved it this way:

<Query>
<Method Name=methodname Namespace=somenamespace >
<Parameters>
<Parameter Name="prm-in" Type="xml">
<DefaultValue>
<prm1>11</prm1>
<prm2>22</prm2>
</DefaultValue>
</Parameter>
</Parameters>
</Method>
Y.D
  • 95
  • 8