I don't need a solution, I just need a starting point.
When I run a report from SQL report manager I run it for a certain user (userid is a parameter for the report). I have an application. What I would like to happen is when a user hits a button in the application the report is sent to them in an email. How should I do this? Or can this even be done?