Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a query in SSRS 2016 which is working perfectly and returning the correct data from a webservice on my live webserver when I hard code the parameter value in, however, I need this to be dynamic, and to be a parameter passed into the report itself. I cannot work out what the syntax for this is though, as nothing I have tried seems to work.and always give me a null answer.

As an additional detail I commented that my webservice is created in Glasfish JSP.

My parameter is clave_usuario that gives me the (=User!UserID)

This is my syntax for my dataset:

<query>
<soapaction>http://ws.ciu.ds.banxico.org/ConsultaADWS
<Method Name="getGsUsuario" Namespace="http://ws.ciu.ds.banxico.org/">
<parameters>
<Parameter Name="clave_usuario">Parameters!clave_usuario.Value


<ElementPath IgnoreNamespaces="true">*


If anyone knows what the correct syntax is for this, I would be very grateful

What I have tried:

SSRS 2016 Cannot set parameters for Web Service query
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900