SQL Server Reporting Services allow your users to subscribe to reports. Using report subscriptions, you can deliver reports to your end users' mailbox in the desired format on a scheduled interval.
Before you can make use of reports subscriptions, e-mail delivery options need to be configured for SQL Server Reporting Services.
Log on to the server that hosts SQL Server Reporting Services with an account that has administrative privileges on both the local computer and SQL Server.
Start Reporting Services Configuration Manager. This program can be found under Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools.
Check the Server Name and Report Server Instance to make sure that you are connecting to the correct instance of SQL Server Reporting Services. Click on Connect.
Under E-mail Settings, enter the e-mail address that you want to use as the sender address for report delivery.
Enter the SMTP Server...