Wednesday, October 24, 2012

SSRS- How to create Email subscription for a Report

1.     Background

The purpose of this article is to provide a way of implementing Email subscription for a report using SQL server reporting services. Email Subscription of reports provides a way of delivering the reports in Email to individual users or groups in the required format and at a specific point of time.

2.     What is Subscription?

A subscription is a standing request to deliver a report at a specific time or in response to an event, and then to have that report presented in a way that you define. Subscriptions provide an alternative to running a report on demand. Subscriptions can be used to schedule and automate the delivery of a report.

3.     Delivery Extensions provided by SSRS

Delivery extensions are used to determine how to deliver a report and in which format. SQL Server Reporting services support two types of delivery extensions.
·         File Share Delivery : To deliver report to a folder
·         Email Delivery: To deliver a report to email recipient

4.     Pre-requisite for Email Subscription    

·         SQL Server Agent service should run.
·         Email address that is going to use as Sender address should have send mail permission on the SMTP server. Go to Reporting services configuration Manager è Email Settingsè Check whether correct Email Address and SMTP Server are mentioned or not:
·         In Reporting service configuration Manager, go to Execution Account tab and check whether unattended account mentioned is your domain account that is used for Report Data source connection, Report processing and sending emails:

·         Credential required connecting to Data source should store securely in the report server.
Below is the screenshot from report server showing that we are storing credential in the report server itself:
·         Run the report from Report Manager to ensure Report is working fine. Below is the screenshot of report preview showing report is working fine:

5.     Step by Step procedure to implement Email subscription:

                    I. Go to Report Manager URL e.g http://servername/reports  è go to folder which is having reports.
                  II. Below is the screenshot from my Report manager URL showing that there is a report named “ProductSalesReport” under MyReports folder.

                III.   Before creating subscription, run the report to ensure that Report is working fine.
                IV.   Go to “ProductSalesReport” report and click on down arrow and select Subscribe

It will open the Report subscription form. Below is the screenshot of Report Subscription form:

                  V. Fill the required details for Email Subscription and Click Ok.
                VI.  We are going for email subscription with below details:

              VII. Click Ok to create the subscription
            VIII.  Go to Report Manager home page and click on “My Subscription”. It will show the list
              of  all the subscription created by you.

                IX. For Demo purpose, I have schedule the subscription per minutes. We can set the subscription as per the business requirement.
                  X. Click on “My Subscription” to check the status of the subscription

                XI. The above screenshot is showing Report is delivered to
              XII. Open the mail and check whether report is delivered to mail or not.

6.     Conclusion

By using above steps, we can create email subscription for a report and we can deliver the report to an individual as well as group at a specific point of time in a required format.

----------------------------------------------------End of Document---------------------------------------------------


  1. You have nice blog on email delivery service. Thanks for sharing very informative details on email delivery service.
    Email delivery service
    what are webhooks


  2. I’ve been surfing online more than 5 hours today, yet I never found any interesting article like yours without a doubt. It’s pretty worth enough for me. Thanks... visit this site

  3. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. Team Activity Training

  4. it is in reality a correctly-researched content material and high-quality wording. I got correspondingly engaged in this fabric that I couldnt wait analyzing. i am impressed in the end your positioned it on and skillability. thank you. Buy Email List


  5. Here's a complete guide on how to login into your account. How to login into account.

  6. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free.

  7. The create page alternative clearly permits you to create pages of substance.Wikipedia editors for hire

  8. Really impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.

  9. We are really grateful for your blog post. Thanks for sharing the grate useful information. Mailbox in Switzerland

  10. A very excellent blog post. I am thankful for your blog post. I have found a lot of approaches after visiting your post. crie uma conta no Hotmail email gratuito

  11. Fabulous post, you have denoted out some fantastic points, I likewise think this s a very wonderful website. I will visit again for more quality contents and also, recommend this site to all. Thanks. acesse sua conta do Hotmail entrar aqui

  12. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work entrar hotmail

  13. Step-by-Step create website Easy to Customize, Publish Now! Custom domain name. Multiple payment methods. Free multilingual fonts. 24/7 support center. 1000s of free images. Top industry hosting. 100s of Apps. Easy-to-add blog. Mobile optimized. Create Website

  14. Any mobile device together with a mobile telephone, netbook, computer... Can be used as your faxing gadget so long as it is related to the internet.fax scanned documents online

  15. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. bulk email marketing services

  16. Thanks for the blog post buddy! Keep them coming... how to send fax from cell phone

  17. We have sell some products of different custom is very useful and very low price please visits this site thanks and please share this post with your friends. can i send a fax from my computer using my android phone

  18. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. targeted email extractor free software

  19. Your blog has piqued a lot of real interest. I can see why since you have done such a good job of making it interesting. I appreciate your efforts very much. bulk email service

  20. Who is sending the email-It is legitimately commanded that contact data is attached to your email crusade. This adds validity to your message and makes trust about your business. lawyers email list

  21. The expression "SOCIAL MEDIA" frequently alludes to exercises that incorporate innovation, social (or human) communication, and the development of words, pictures, recordings and sound - otherwise called "client created content" [an illustration of UGC would be recordings on YouTube.] SMM Panel

  22. Superior post, keep up with this exceptional work. It's nice to know that this topic is being also covered on this web site so cheers for taking the time to discuss this! Thanks again and again! one funnel away challenge

  23. For the excellent company Begin with the internet site, the customer service over the cell phone, to the detailed care they deliver in your presence
    leather jacket

  24. hi,
    it is possible enable subscription in a version sql express?