Automatically Queue an SSRS Report for output to PDF

Question

Automatically Queue an SSRS Report for output to PDF

vsslasd 556

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,

1 answer

Your answer

Answer 1

ZoeHui-MSFT 41,491

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.

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

vsslasd 556 Reputation points

2021-03-04T19:32:46.117+00:00
Thank you,
So that could be used, if it is considered a "templated", and if I could use TSQL to update the parameters with the various values.

Is that possible to do safely? Utilize a TSQL Update Statement to update those parameters on demand for a single use report, and then execute that immediately.
Then from my automated procedure keep updating that one record in the same way but with different parameters to execute the same report with different parameters on demand as well ?

This is the SSRS Subscription Table:

[dbo].[Subscriptions]

So I would need to do something like:

Update dbo.Subscriptions
Set Parameters='<ParameterValues><ParameterValue><Name>Job</Name><Value>1-20-6149</Value></ParameterValue></ParameterValues>'
Where SubscriptionId='xyz'
I would also need to change the time schedule to execute immedately.

And is it safe to do this ?

Thank you
vsslasd 556 Reputation points

2021-03-04T19:56:48.703+00:00

I don't see data driven subscription as an option. Is Data Driven Subscription functionality only available in SQL Server Enterprise ?
vsslasd 556 Reputation points

2021-03-04T20:52:52.497+00:00

I think this article is helpful:
http://thoughtsfrommylife.com/creating-data-driven-ssrs-reports-in-sql-server-standard-edition/
Olaf Helper 47,436 Reputation points

2021-03-05T06:52:19.683+00:00

Is Data Driven Subscription functionality only available in SQL Server Enterprise ?

Right, see SQL Server Reporting Services features supported by editions => Data-driven report subscription
ZoeHui-MSFT 41,491 Reputation points

2021-03-05T07:23:17.427+00:00

You may modify report subscription parameters with T-SQL like this. It should be safe and you may also test it in your test environment.

SQL Server Standard Edition doesn't support Data Driven Subscriptions, you may refer this to create-ssrs-data-driven-subscriptions-on-standard-edition

Share via

Automatically Queue an SSRS Report for output to PDF

1 answer

Your answer