question

vsslasd-3371 avatar image
0 Votes"
vsslasd-3371 asked ·

Automatically Queue an SSRS Report for output to PDF

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered ·

Hi @vsslasd-3371,

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



· 5 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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


0 Votes 0 ·

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

0 Votes 0 ·

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


0 Votes 0 ·