ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,248 questions
Integrate SSRS Reports to existing ASP.NET Appliation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Dervishi, Erald
66
Reputation points
I have a project that I am working on that consist of embedding SSRS reports to an existing ASP.NET application
The idea is to embed these reports that were created in the SSRS and
show all of them within the application
and send them by email based on the parameters and filters that the user chooses for that report
I've been doing some research but not any specific information, except
their SOAP Webservices
https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/integrating-reporting-services-using-soap-web-application?view=sql-server-ver16
Let me know if you have worked on a similar project before.
Thanks in advance.
{count} votes
-
AgaveJoe 26,191 Reputation points2022-06-22T22:11:40.98+00:00 Ae you looking for the Report Viewer?
Integrate Reporting Services Using the Report Viewer Controls - Get Started
I use the SOAP services. Is there some reason you cannot use the SOAP services? Have you tried and it did not work?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT 25,471 Reputation points Microsoft Vendor2022-06-23T07:28:52.12+00:00 Hi @Dervishi, Erald ,
I think you can use the Report Viewer control which can be used to integrate Reporting Services RDL reports into WebForms and WinForms applications.
https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/integrating-reporting-services-using-reportviewer-controls-get-started?view=sql-server-ver15
Or to use another approach is to embed the iFrame into an ASP.NET application that uses SSRS services.
https://learn.microsoft.com/en-us/sql/reporting-services/access-report-server-items-using-url-access?view=sql-server-ver15Best regards,
Lan Huang -
Dervishi, Erald 66 Reputation points
2022-06-23T13:58:14.177+00:00 In my understanding Report Viewer shows only one report, I would like all the reports that are built in SSRS server to be shown in a list and if one of the reports has parameters the user uses it and send the report result by email, all this within the ASP.Net application.
Thank You. -
Dervishi, Erald 66 Reputation points
2022-06-23T14:00:12.73+00:00 I have downloaded the wsdl but a bit confused about where to start with them in my ASP.NET application, I would appreciate any guidance or links to follow.
Thanks -
AgaveJoe 26,191 Reputation points
2022-06-23T14:44:54.133+00:00 I'm not sure what guidance is needed.
Typically, Visual Studio is used to create a service reference from the WSDL.
How to: Add, update, or remove a WCF data service reference
The Svcutil.exe command line tool is another option
ServiceModel Metadata Utility Tool (Svcutil.exe)
Both options above generate code based on the WSDL. Essentially, the generated code behaves like the SOAP service is a local library. Reading the service documentation is a must to understand how to interact with the service. You need to understand how to populate the method arguments as well as what the methods actually do.
-
Dervishi, Erald 66 Reputation points
2022-06-23T18:48:28.54+00:00 Thank you Joe
Sign in to comment