SSRS : Subscription in Report Server

Another helpful feature provided by report server is Subscription. It can also be scheduled to receive reports automatically in the form of Email or File Share. In file share you can specify the format of the file (Pdf,Excel etc..) and schedule to save to ftp location or file path that you specify. If you want to schedule the report via email you can also send it as an attachment by using Render Format (PDF,Excel etc..)

After you deploy reports to report server right click report properties and it shows Subscription. It shows below screens which you can easily set the schedule.

However you also need to configure the RSReportServer.config file location in SQL server/reporting server.

There you may need to provide your SMTP server <SMTPServer>your.SMTP.servername.com</SMTPServer> port number   <SMTPServerPort></SMTPServerPort>

To use a remote SMTP service, this <SendUsing>2</SendUsing> value must be set to 2 in the RSReportServer.config file.

<RSEmailDPConfiguration>

<SMTPServer>SMTP.servername.com</SMTPServer>

<SMTPServerPort>25

</SMTPServerPort>

<SMTPAccountName>

</SMTPAccountName>

<SMTPConnectionTimeout>

</SMTPConnectionTimeout>

<SMTPServerPickupDirectory>

</SMTPServerPickupDirectory>

<SMTPUseSSL>

</SMTPUseSSL>

<SendUsing>2</SendUsing>

<SMTPAuthenticate>

</SMTPAuthenticate>

<From>noreply@From.com</From>

<EmbeddedRenderFormats>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

<PrivilegedUserRenderFormats>

</PrivilegedUserRenderFormats>

<ExcludedRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

<RenderingExtension>NULL</RenderingExtension>

<RenderingExtension>RGDI</RenderingExtension>

</ExcludedRenderFormats>

<SendEmailToUserAlias>True</SendEmailToUserAlias>

<DefaultHostName>

</DefaultHostName>

<PermittedHosts>

</PermittedHosts>

</RSEmailDPConfiguration>