Hundreds of companies of varying verticals and sizes rely on SQL Server’s reporting system. Known as SQL Server Reporting Services (SSRS), it is used to design and generate reports on a scheduled or ad hoc basis. SSRS has a basic scheduler designed for simple automated report distribution, but what if your business requires complex event driven and data driven subscriptions? What if you not only needed to automate SQL reports, but you require tasks to be automated such as database updates or system alerts? In this blog, I will discuss how SSRS automated report generation, Data Driven Subscriptions, and business process automation using PBRS (formerly SQL-RD) can solve this problem. Additionally, I will give a little insight into Zintel, a leading provider of communications technology solutions to businesses across New Zealand and Australia, and how PBRS solved this problem for them.