question

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 asked ZoeHui-MSFT commented

SSRS report - email delivery over internet

If I run a SSRS Server on-prem can I deliver reports over the Internet to the external users to whatever emails they might have? Each user should be getting a personal version of the report.

Thanks

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @markgoldin-3750,

Of course you can.

SQL Server Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups.

To distribute a report by e-mail, you 1) configure the report server for e-mail delivery and 2) define either a standard subscription or a data-driven subscription.

The report server connects with an e-mail server through a standard connection. It does not use communication that has been encrypted using Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL).

The e-mail server must be a remote or local Simple Mail Transport Protocol (SMTP) server on the same network as the report server.

More details you may refer:

e-mail-delivery-in-reporting-services

create-and-manage-subscriptions-for-native-mode-report-servers

create-modify-and-delete-data-driven-subscriptions

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 answered ZoeHui-MSFT commented

What if I need to send a report to multiple users at once and each copy should have data specific for an email recipient. Can that be done?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you mean that e-mail a report to multiple users and the report data for each user is specific different at once, it seems couldn't be done temporarily, we need to create multiple subscriptions to meet your need.

0 Votes 0 ·