Making report run for different users in a single subscription.
-
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.
-
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
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