Post reply

One subscription, multiple recipients, different parameters

  • October 6, 2016 at 3:11 am

    #313612

    Hi All,

    Not sure I can do this in SSRS 2008 R2 so just wanted to check.

    This is just an example not my specific need.

    Say I have a Monthly Sales Figures report that would go to 5 Different Sales Team Leaders. Each of these reports would include only those sales figures for the sales people in the specific team. The reports has a Sales Team parameter.

    Now I know that I can create 5 different subscriptions, one for each Team but I would like to some have one subscription which would send out the 5 different reports but if they add/remove teams well it just becomes a pain to maintain.

    Is that possible?

    FWIW, I do have a way top do this using SSIS to drive the reports but wanted to first see if it can be done with just SSRS

    Thanks

    Steve

  • October 6, 2016 at 4:19 am

    #1905116

    You can't send out 5 copies of the same report with a single subscription no. In fact, from experience, if you start off the same subscription while it's already running (say it takes a few minutes to get the data and render the report), then any progress on the previous subscription is lost!

    The only way you could achieve sending the same report with different parameters to different people is to have separate subscriptions, I'm afraid.

    P.S. There might be something in Enterprise Edition, with the Data based subscriptions, however, not something I've made use of, as I only have Standard.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 6, 2016 at 5:08 am

    #1905130

    Thanks Thom A,

    I just wanted to make sure that I wasn't missing something. My SSIS solutions works just fine, though I am sure some SSIS developers would have a fit me using SSIS as a Report Distribution System 😉

    Thanks

    Steve

  • October 6, 2016 at 5:15 am

    #1905132

    SteveD SQL (10/6/2016)

    My SSIS solutions works just fine, though I am sure some SSIS developers would have a fit me using SSIS as a Report Distribution System 😉

    Thanks

    Steve

    I do the same thing with repeating subscriptions. Inside a For Loop, I use a SQl Task to amend the XML, then do the subscription, then check if the subscription has finished (if not loop a wait timer till it has or a certain time has passed), and then do the next one.

    it's "ugly" but it works 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply