Link to home
Start Free TrialLog in
Avatar of ram27
ram27

asked on

ssrs report in webapi /angular

how to generate SSRS report /consume in WEBAPI with parameters
 ssrs report  in web api and display in angular js
Avatar of Misha
Misha
Flag of Russian Federation image

You can add a wcf service in the solution which was consuming webapi. It can solve the purpose to pass parameters to the webapi.
You need to add the client  web service reference to your web API project and consume this service.
https://docs.microsoft.com/en-us/sql/reporting-services/report-server-web-service/net-framework/building-applications-using-the-web-service-and-the-net-framework?view=sql-server-2016
A simple wrapper is shown here:
https://www.codeproject.com/Articles/1110411/How-to-Write-a-Csharp-Wrapper-Class-for-the-SSRS-R

From experience run a report with NO parameters first, then build one with simple interger parameters and then date parameters if needed.

If you are using the latest SQl server (2017), there is a REST API with samples on how to consume it at:
https://docs.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-2017

You can use the link above as a guide to build a similar API.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.