Making report run for different users in a single subscription.

  • mharbuz

    Say Hey Kid

    Points: 678

    I have created a report that has a filter on the dataset that filters the information on the report based on the user that is viewing the report.


    What I am wanting to achieve is to use one single subscription to email a PDF of the report to all users however when I try this it just emails a PDF of the subscription owners report to everyone. Is it possible to email a different version of the report for each user in the subscription?


    And just to throw another spanner in the works, I only have the standard edition of SQL not the enterprise edition so I don't have access to Data Driven Subscriptions.

  • Thom A

    SSC Guru

    Points: 98505

    The simple answer is, you can't (not out of the box). What you are looking for is a Data Driven Subscription, and that is an Enterprise feature.

    That's not to say, however, you can't do it, and there are guides on how you can achieve similar functionality; but there are hoops you need to jump through. A couple of searches gave me this and this.


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

  • mharbuz

    Say Hey Kid

    Points: 678

    Hi Thom,


    Thanks for the reply, I was sort of clutching at straws posting on here as I have already found this which is a bit long winded but I was hoping there would be an easier way. I guess there isn't 🙁

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

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