Automatically Queue an SSRS Report for output to PDF

vsslasd 556 Reputation points

Is there a way to send a request to print a specific SSRS report with parameters and have output to a PDF file via a SSRS Report queue? Similar to the SSRS Execution log ? But instead of what is actually executed, a request to execute a specific SSRS Report ?
Thank you,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points

    Hi @vsslasd ,

    A data-driven subscription provides a way to use dynamic subscription data that is retrieved from an external data source at run time.

    Data-driven subscription could filter the report output using report parameter values that are retrieved at run time.

    In other words, data-driven subscription can deliver the report with e-mail or windows share file and specify parameters and change the output format, such as PDF like shown below.


    In this way, it could meet your requirement about specific SSRS report with parameters and have output to a PDF file.


    You could try to delivery the report to network printer to Auto-print, details please refer this.



    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October