SSRS + multiple subscriptions with different default values

Posted on 2011-05-12
Last Modified: 2012-05-11
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.
Question by:Josh_Blade
    LVL 11

    Accepted Solution

    Hi... have a look at my solution in the following question.

    In summary, you will need a version of reporting services that supports data driven subscriptions. As part of the setup, you write sql that will return a list of vendorID's which you use as a parameter for your subscription.

    hope this helps



    Author Comment

    Hmm, are data driven subscriptions only supported by SQL Server Enterprise editions?

    Author Closing Comment

    Very quick response, with an excellent guide!
    LVL 11

    Expert Comment

    Unfortunately, only Enterprise and Developer editions suport it according to Microsoft.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video discusses moving either the default database or any database to a new volume.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now