SQLTeam.com | Weblogs | Forums

SSRS Reports


#1

I have an SSRS Report that needs to be emailed to a dynamically changing list of people. Each person has a slightly different report delivered to them (figures based on their performance) and they need to be confidential. Is there a way of executing a report to be emailed to somebody from a Stored Procedure passing the name as a parameter? Or can it be done using SSIS?


#2

If you have Enterprise Edition, data-driven subscriptions might work for you:

https://msdn.microsoft.com/en-us/ms159150.aspx

However it sounds like you'd have to create one subscription per person. If there are a lot of folks that could be problematic. There are ways to automate SSRS but subscriptions may be tricky to do (I haven't done it myself).


#3

Thanks for the response. Unfortunately we only have Standard Edition.