question

DervishiErald avatar image
0 Votes"
DervishiErald asked OlafHelper-2800 answered

Embed SSRS rdl Reports to an existing ASP.NET application

I have a project scenario that requires embedding SSRS rdl Reports to an existing ASP.NET Core application. I have made some research prior to posting here and I came across a library called ReportViewer, was able to get some results but only showed one Report not a list of Reports that I am trying to accomplish. I also have followed this tutorial as well but I have the same issue, showing only one report while I want all the reports I have created in SQL Server Reporting Services. Any recommendations or suggestions would be helpful.

Thank you in advance.


dotnet-csharpsql-server-reporting-servicesdotnet-aspnet-core-mvcdotnet-aspnet-mvcdotnet-sqlclient
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DervishiErald,

As far as I know, the ReportViewer apply to the ASP.NET 4.x (.NET Framework) webform application, it doesn't apply to the .NET application (.NET Core 1.0 - 3.1, .NET 5, and later versions of .NET). The difference between .NET and .NET Framework, see Choose between ASP.NET 4.x and ASP.NET Core.

In asp.net core application, to display the SSRS reports, you can create an .NET Framework application and use a webform to display the report, then in the asp.net core application, use an Iframe tag or send http request to call the web page and get the report. Besides, you can also search some third party package, perhaps they can help to display the SSRS reports in the asp.net core application.

Best regards,
Dillion

1 Vote 1 ·

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

but only showed one Report not a list of Reports

Now guess why it's called Report Viewer; it's a control to show a report.

SSRS offers a API to get list of existing reports and much more, see [Integrating Reporting Services into Applications][1]


[1]: https://docs.microsoft.com/en-us/sql/reporting-services/application-integration/integrating-reporting-services-into-applications?view=sql-server-2016
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.