1
votes

Is it possible in SSRS to set a default parameter value for a report subscription only, but not set a default when the report is run manually?

I have the default dates I want to use for the subscription generated in a dataset, but I'd like to only use default dates for the subscription.

2

2 Answers

1
votes

Here is one idea.

  1. Select the target report and click manage.
  2. Select Create Linked Report and Rename it to denote Subscription
  3. Set the desired parameters for subscriptions on the new linked report.

    NOTE : Parameters can be set independently for linked reports.

  4. Point your subscriptions to the linked report.

    NOTE : If you modify the original report the changes will show up in all linked reports as well.

0
votes

I was able to resolve the issue by using data-driven subscription and creating a query inside the subscription to generate default parameters