Prev: Group Footer at bottom of page
Next: SSRS2008 Line Chart Axis issue
From: AG on 22 Apr 2010 08:46
Can SSRS reports be sent via email, in the body of the email?
Examples and/or links would be appreciated.

This does not refer to subscriptions.

I need to upload a file (probably an Access database) containing invoice
data for multiple customers and email each their invoice.
My thought was to build an ASP.NET web app to accept the file, place it in
the appropriate folder and use it for the source of an SSRS report, then
email to the appropriate customers.
I know how to generate a PDF from SSRS, but client would like to have the
invoice in the body of the email rather than an attachment.

--

AG
Email: npATadhdataDOTcom




From: "Charles Wang [MSFT]" on 26 Apr 2010 06:18
Hi AG,
Yes, you can configure a SSRS subscription to deliver a report by e-mail.
The following articles will give you detail information:
How to Configure Report Subscriptions in SQL Reporting Services
http://technet.microsoft.com/en-us/library/cc872783.aspx
E-Mail Delivery in Reporting Services
http://msdn.microsoft.com/en-us/library/ms160334.aspx

Best regards,
Charles Wang

From: AG on 26 Apr 2010 08:20
Charles,

I specified in my original post that I was NOT referring to subscriptions.

--

AG
Email: npATadhdataDOTcom


""Charles Wang [MSFT]"" <changliw(a)online.microsoft.com> wrote in message
news:9pJFsnS5KHA.3644(a)TK2MSFTNGHUB02.phx.gbl...
> Hi AG,
> Yes, you can configure a SSRS subscription to deliver a report by e-mail.
> The following articles will give you detail information:
> How to Configure Report Subscriptions in SQL Reporting Services
> http://technet.microsoft.com/en-us/library/cc872783.aspx
> E-Mail Delivery in Reporting Services
> http://msdn.microsoft.com/en-us/library/ms160334.aspx
>
> Best regards,
> Charles Wang
>



From: "Charles Wang [MSFT]" on 4 May 2010 09:32
AG,
For development purpose, you can use SSRS Web Services to render your
report in HTML format and then send the content via email with HTML body.
You can refer to the following article:
http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingservicesweb
service.rsexecutionservice2005.reportexecutionservice.render(v=SQL.90).aspx

Best regards,
Charles Wang

From: AG on 5 May 2010 08:23
Thank you.

--

AG
Email: npATadhdataDOTcom


""Charles Wang [MSFT]"" <changliw(a)online.microsoft.com> wrote in message
news:rdk1J546KHA.4864(a)TK2MSFTNGHUB02.phx.gbl...
> AG,
> For development purpose, you can use SSRS Web Services to render your
> report in HTML format and then send the content via email with HTML body.
> You can refer to the following article:
> http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingservicesweb
> service.rsexecutionservice2005.reportexecutionservice.render(v=SQL.90).aspx
>
> Best regards,
> Charles Wang
>



 | 
Pages: 1
Prev: Group Footer at bottom of page
Next: SSRS2008 Line Chart Axis issue