Save SQL Report on Server using C#

Question

Hi All,

I want to save SQL report on server on button click event,
but I dont want to display this report to user, I want that When user clicks on that button
I will pass parameter to SQL Report and then save it to server without displaying it to user,
and then send this report to client wia email along with some oter attachments.
Thanks in advance.
Regards,