January 15, 2018 at 7:31 am
Can someone point me to asp.net code to send a SSRS rdl report to a PDF file instead of displaying in browser?
January 15, 2018 at 7:59 am
SSRS has many web service methods which can be used.
Have a look at these examples:
https://weblogs.asp.net/srkirkland/exporting-a-sql-server-reporting-services-2005-report-directly-to-pdf-or-excel
https://forums.asp.net/t/1549431.aspx?Code+to+render+the+report+in+PDF+format+using+C+in+SSRS+2008
There are loads more on the internet.
January 15, 2018 at 8:00 am
dlchase - Monday, January 15, 2018 7:31 AMCan someone point me to asp.net code to send a SSRS rdl report to a PDF file instead of displaying in browser?
That's a bit of a broad question since there are different approaches depending on what you are using.
Using ReportViewer or not? Using what language or how if not with the ReportViewer? VIew or just export to somewhere? Just export a report in PDF format in SOAP, web service code?
Here are some examples of doing this in a few different ways:
Export SSRS Report to PDF without using ReportViewer in ASP.Net
Render SSRS .RDL to PDF and just open it
directly export to pdf from ssrs viewer in asp.net mvc 5
Create a PDF using the .Net ReportViewer control
Programmatically export an SSRS report to pdf file
Sue
January 15, 2018 at 8:52 am
We are not using ReportViewer, we are just opening the SSRS report via URL. Also, we are using SQL Server 2016 so was wondering if these references to 2005 and 2008 are relevant.
January 15, 2018 at 9:10 am
SSRS continues to make use of web services:
https://docs.microsoft.com/en-us/sql/reporting-services/report-server-web-service/report-server-web-service
You'll just have to check if any of the method names have changed or deprecated in the SQL 2016 version.
I don't think the methods would have changed too drastically, but regardless the links are just a guide to see how others have achieved it.
January 15, 2018 at 11:06 am
dlchase - Monday, January 15, 2018 8:52 AMWe are not using ReportViewer, we are just opening the SSRS report via URL. Also, we are using SQL Server 2016 so was wondering if these references to 2005 and 2008 are relevant.
Yes - The second one uses URL and adds the render format.
Sue
January 15, 2018 at 11:15 am
Agree, but it is not creating a physical PDF file.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply