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?
If you have Enterprise Edition, data-driven subscriptions might work for you:
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).
Thanks for the response. Unfortunately we only have Standard Edition.