Reputation: 1195
What are the difference between subscription and data driven subscription in SSRS?I have read about these two,but i didnt get the exact difference.both are scheduling,so both will be execution at scheduled time or different?
Upvotes: 0
Views: 10085
Reputation: 10880
A data driven subscription is dynamic. This is directly from MSDN. With a data driven subscription you can:
Distribute a report to a fluctuating list of subscribers. For example, you can use data-driven subscriptions to distribute a report throughout a large organization where subscribers vary from one month to the next, or use other criteria that determines group membership from an existing set of users.
Filter the report output using report parameter values that are retrieved at run time.
Vary report output formats and delivery options for each report delivery.
Meanwhile... with a standard subscription (again from MSDN) "the report consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters."
Upvotes: 1