SSRS + multiple subscriptions with different default values
Posted on 2011-05-12
I have a report built in SSRS, and I was wondering if there is a way to set up a subscription that will run reports for each of the available options for a given parameter.
ie: One of the parameters is VendorID. At the moment, there are 11 VendorIDs, so I'd like to have a subscription that will run 11 reports, one with each VendorID as the default value. Then later, if a new VendorID is added to the database, the subscription would run 12 reports etc.