How to send a ReportViewer report using sp_send_dbmail?


  • Greetings,

    I need for my users to be able to:

    1) Run a report and have it display on my aspx page in the ReportViewer control  (working)
    2) Let the user enter an email address in a textbox
    3) Click a Button that will send the entire report in the ReportViewer to the email address

    Database is Sql Server 2012 Express so I don't have the ability to use Subscriptions to deliver reports.

    All reports were created using the report designer and are saved as ".rdl" files.

    Would like to let my users do this without any additional steps if possible.

    Any insight would be greatly appreciated...

    Best, CM+

    Monday, July 08, 2013 6:21 PM