This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(278.4, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
I wrote a lot of standard SSRS reports, by using VS 2019, and deploying to an SSRS report server. When I design, I'm not connected to the report server.
I would like to write an SSRS Report that can produce a formatted report, and writes that to a PDF file instead of to a ReportViewer. In other words, how can I export to PDF without ever clicking the Export button?
I know a tiny bit about "ReportExecutionService" but what I have doesn't even compile. Is there a tutorial, or a discussion that can get me moving from scratch?
(Note: I have PDFSharp, but I can't seem to figure out how to render the SSRS report to a PDF file instead of to stdout.)
I just worked with ASP.NET, and the ReportViewer object. I just wish there was a way to get the PDF rendered to disk without showing on screen. I'm still working with it, but I'm not sure about that as a solution yet.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Coreysan
What about exporting reports using URL access? I don't know if this meets your requirements. If you have deployed the report, you can use the URL to specify the format of the rendered report. HTML4.0 and HTM5 formats (rendering extensions) will be rendered in the browser. For other formats, the browser will prompt to save the report output to a local file.
For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-ver16.
Best regards,
Aniya
@Anonymous Thanks for your comment. My project is a bit tricky because I'm designing it for users who have almost no skill on computers. They need to be able to copy a list of numbers from Excel into a parameter list, and just click one button. When the button is clicked, then I need to iterate through the numbers and produce PDFs for each number.
I actually just now created one solution using ASP.NET, where it reads in an RDL file and generates PDFs out of that. It works.
In the end, it would be nice to do it via SSRS Report Services, but I don't know enough about it!
@Anonymous I spoke with my project manager about this. We would like to deploy a standard report on our SSRS server, with one filter (a textbox) that accepts a list of numbers. When the button is clicked, voila! PDFs are created on disk. We're trying to make this dummy proof because our end users don't work in IT, and they don't know much about using SSRS, let alone using URLs.
Is that possible?
Hi @Coreysan
I may not be clear about your needs. If you just need to select parameters and send the results of each parameter operation to the customer's mailbox or shared folder in PDF format, then you can use data-driven subscription.
If what you need is that the customer selects multiple parameters when visiting the web portal, and there is a click button to save the results of each parameter operation on the customer's disk in PDF format, then the current SSRS does not have this function, may require you to write additional code. Actually, I'm not very familiar with C#, I found this link for you: https://social.msdn.microsoft.com/Forums/lync/en-US/e6b6306b-abe6-4531-b118-59966afbdeaa/generate-multiple-pdf-files-in-a-report-using-ssrs?forum=aspsqlserverreporting. If you have more in-depth questions about this, I suggest you go to the relevant tag of C# for help.
If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
@Anonymous Thank you so much for following up. We're getting closer!
Please allow me to explain what I need more specifically:
Imagine I run a shop selling bicycles. 100 customers from around the world order a bike, so I have to create 100 invoices for fulfillment/shipping.
Typically, small companies would run an SSRS report, generate the report to show 100 orders, and then export the report to PDF. With one PDF, its easy to print the file and get 100 invoices. No big deal!
But I need the report to behave a certain way:
Continuing with the bicycle scenario, I'd like to have a report with only one filter (parameter), a textbox. A user would run the report, and copy/paste 100 invoice numbers into the textbox. The report would pass those numbers to a stored proc, fetch 100 records, and return the data.
At this point, I'd like the report to iterate through the 100 records and create 100 invoices on disk in a PDF file format. I don't need to see anything on the screen, I just need 100 separate PDF files, without clicking the Export to PDF button.
Regarding the link, I actually have that C# code, but the problem is, the code doesn't explain the class named "ReportServices." That object seems to be a library object that's buried deep in the SSRS Reporting Services product. It's not an open source object, the way I understand it.
So you are probably correct - this might very well be a question for C# coders. Do you think I should go in that direction? Again, I have no idea at all where to get the object (or the code) "ReportServices." That's fundamentally what started with whole nightmare!!!!!
What do you think?
Hi @Coreysan
For compiling and running code in SSRS, you can refer to this link:
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms160695(v=sql.90).
In addition, I found a thread you can refer to: https://social.msdn.microsoft.com/Forums/es-ES/bea93385-8f48-4053-9581-238f1b05c2a2/ssrs-generate-multiple-pdfs-for-a-single-parameter-driven-report?forum=aspsqlserverreporting.
Hope these can help you.
Best regards,
Aniya