Creating and Emailing reports with Sql Server

[Todd]

We are in the process of adapting our Winform application into a MVC Web Application and we have Telerik Reports that we use to generate Invoices and Statements which we attach to emails.

 

Ideally we would call a stored procedure while passing an Id, from there we would call the sp_send_dbmail stored procedure and pass it the file attachments and other data gathered using the Id which would make our sp call look like this:

    EXEC msdb..sp_send_DBMail
    @profile_name ='Profile'
    ,@subject = @Subject
    ,@body = @Body
    ,@recipients= @Recipients
    ,@body_format = 'HTML'
    ,@reply_to = @ReplyTo
    ,@file_attachments = 'C:\Report\Invoice 123'

[Nasko]

Hello Todd,

Regardless of the application type (WinForms or MVC) the reporting engine can process and render a report, which you can then save to the file system. For more information, please check the Exporting Report Programmatically help article.

Regards,
Nasko
Telerik

[Todd]

The link is showing how to export a report using C# or VB, I want to tell the SQL Server to send an email and then have the SQL Server generate the report.

[Nasko]

Hello Todd,

The Report Engine should be accessed using C# or VB.NET code to call the RenderReport Method, as explained in the provided article. The SQL Server itself cannot generate the report.

Regards,
Nasko
Telerik