Geek Answers Handbook

Consume web api in SSRS with parameter

I am trying to use webapi in ssrs (XML source).

If you use the parameter in the URL (for testing purposes), then its work is really beautiful, for example, http://some_xyz_url.com/Api/Report/GetReport?id=7 . so i can use web api in SSRS

The real problem is I don’t know how to pass the webapi parameter from SSRS. I tried, but no luck. Also, I was looking for stackoverflow, there are no questions next to my requirement.

I am using VS2012, (.net framework 4.0), SQL Server 2008 (using SQL Server Report Builder)

Any help is really appreciated.

I have an error message when I try to pass a parameter from SSRS to webapi.

enter image description here

Update

, - null, . (. jpg)

enter image description here

enter image description here

404 ( Id, )

.

+4
3

, , web api, wcf , webapi ( ). , wcf- , webapi.

wcf SSRS.

+1

. , - :

="http://some_xyz_url.com/Api/Report/GetReport?id=" & Parameters!ReportParameter1.Value
+5

XML " " WCF, , , , , - , , , .

- SSRS:

  • XML (, ).
  • - HTTP .

  • , "Connection String" . EG :

    http: //localhost/Reporting/ReportService.svc

    , "" ReportService. , Visual Studio, , . , , .

  • "DataSet", . MS "" xml blob, . , , "" node.

    <Query>
<Method Name="GetStateLike" Namespace="http://tempuri.org/">
<Parameters>
<Parameter Name="state"></Parameter>
</Parameters>
</Method>
<SoapAction>
http://tempuri.org/IReportingService/GetStateLike
</SoapAction>
</Query>

, . , , . : WCF SSRS 2008 R2

+1
source

More articles:


All Articles