Using Web Service as a Data Source in Sql Server Reporting Services

Suppose this is a simple web method inside a web service in ASP.NET.

[WebMethod]

public string HelloWorld(String FirstName, String LastName) {

return “Hello “ + FirstName+ ” “ + LastName ;

}

Now we would to add the above as a xml data source in out Report.

For this we need to do the following

• Create a new Report
• Select <New DataSet..>
• For Type (inside General Tab) select XML as DataSource type.
• Inside connection string give the path to the web service.
• i.e. http://localhost:2584/WebSites/Service.asmx
• Define query for the data source in the following manner

<Query>

<Method Namespace=“http://tempuri.org/“ Name=“HelloWorld“>

</Method>

<SoapAction>http://tempuri.org/HelloWorld</SoapAction>

</Query>

 

We can create report parameters for FirstName and LastName parameters of the method.

Or we want to define default values for these parameters define the query as following

 

<Query>

<Method Namespace=“http://tempuri.org/“ Name=“HelloWorld“>

<Parameters>

<Parameter Name=“FirstName“>

<DefaultValue>Nishant</DefaultValue>

</Parameter>

<Parameter Name=“LastName“>

<DefaultValue>Rana</DefaultValue>

</Parameter>

</Parameters>

</Method>

<SoapAction>http://tempuri.org/HelloWorld</SoapAction>

</Query>

 

Bye..