Automatically Queue an SSRS Report for output to PDF

vsslasd 556 Reputation points
2021-03-03T23:01:52.4+00:00

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
    2021-03-04T02:35:44.943+00:00

    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.

    74043-screenshot-2021-03-04-102321.jpg74044-screenshot-2021-03-04-102351.jpg

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

    data-driven-subscriptions
    create-a-data-driven-subscription-ssrs-tutorial

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

    Regards,

    Zoe


    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