Passing parameter do WebService not working RSS

• • Reply
  

  fabiobarreir...

  Member

  10 Points

  24 Posts

  Passing parameter do WebService not working

  Dec 29, 2011 07:23 PM|LINK

  Hi all!

  I'm trying to consume a webservice as a data source in a Report.

  the Data Source is configured as:
  type: XML
  connection string: http://localhost/p2/WSPersa/COMService.asmx 
  credentials: Windows

  the DataSet:

  Parameter Name: id
  Parameter Value: 17261 (fixed value just for testing) 
  Query: 

  <Query>
  <SoapAction>http://tempuri.org/CalcularIndicadoresProposta</SoapAction>
  <Method Namespace="http://tempuri.org" 
          Name="CalcularIndicadoresProposta">
  <Parameters>
         <Parameter Name="id">
             <DefaultValue>17261</DefaultValue>
         </Parameter>
  </Parameters>
  </Method>
  </Query>

   The WebService:

  [WebMethod(Description="Retorna todos os indicadores da proposta")]
  public Indicadores CalcularIndicadoresProposta(int id)
  {

  ...

  ...

  }

  The WebService works when invoked through a browser,
  but when trying to test it using the Query Designer and
  clicking on ! the parameter id is not passed to the webservice.

  Any ideas?

  Thanks!

   

• • Reply
  

  AngelSolutio...

  Member

  2 Points

  1 Post

  Re: Passing parameter do WebService not working

  Jan 16, 2012 09:46 AM|LINK

  Hi,

  You have to double-click on the DataSet and brind the dataset Properties dialog. Go to the Parameters tab on the left and make sure your "id" parameter is defined there.

  In the Parameter Name column you have to enter "id" and in the Parameter Value "@id" (or whatever name you have given to tye parameter that you pass through to the report). That way you are linking the parameter that you pass to the report with the parameter that the query uses.

  Hope that helps