CODEWITHSUNDEEP
reporting-servicesssrs-2012
dhyman
dhyman

Reputation: 35

SSRS set default parameter for subscription only

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.

Upvotes: 1

Views: 1347

Answers (2)

dhyman
dhyman

Reputation: 35

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

Upvotes: 0

Ross Bush
Ross Bush

Reputation: 15155

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.

Upvotes: 1

Related Questions