What is Subscription in SSRS - SQL Server Reporting Services(SSRS) Interview Questions and Answers

After developing the reports by SSDT ( SQL Server Data Tools) or by Report Builder, we save our reports to Report Server. Once the reports are deployed/Published, Users use Report Manager Interface to access the report/s.
Think about a scenario we we need to save these reports to some folders on schedule or email the report to some users on regular interval.

SSRS Subscription is the way to solve above problems. We can create subscription for our report to run on schedule and save in a folder or email to recipients.

11 comments:

  1. Hello Sir,
    This is awesome content.
    Can we have an demo for this blog.

    ReplyDelete
  2. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. 代理翻墙软件

    ReplyDelete

  3. Enjoyed every single word of your blog article. Thanks to share it!
    daikin 1.8 ton 3 star inverter split ac price

    ReplyDelete
  4. As we said, there are a lot of VPNs 翻墙 out there. But there are also a lot of VPN reviews. With so many biased choices, it can be difficult to separate fact from profit-driven fiction.

    ReplyDelete
  5. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting upVPN

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. A VPN that can be used no matter what country you are in, all websites and social APPs in the world can be accessed at high speed without any problems. For details, click : Try PandaVPN anonymously

    ReplyDelete
  8. Great article, thanks for sharing, and I recommend an excellent article to everyone: 中国VPN香港VPN台湾VPN

    ReplyDelete
  9. Android VPN requires no additional setup, just one click to connect: Get it now

    ReplyDelete
  10. The never-ending model of subscription permits clients to pay enormous forthright expense for the option to utilize programming everlastingly, with programming organizations.
    https://www.spotifyfame.com/

    ReplyDelete
  11. Hi Amir,
    I have a question. I have created a subscription in SSRS and it got failed due to some reason(query/conversion/data issue). So, I want to get an email alert when the subscription gets failed. How can I do that, please help me ?

    ReplyDelete