ChristianSteven Business Intelligence Blog

5 Ways To Use Event Driven Subscriptions With SSRS

In the past we have discussed how Data Driven subscriptions can be created in SQL-RD to deliver reports to various users and destinations. In SQL-RD, SSRS reports scheduling can also be accomplished based on certain conditions. Once these conditions are met, then the associated SQL report will be triggered based on given parameters, and then delivered to a specified location. One could build an Event Driven system inside of SQL Server, however, SQL-RD provides the advantage of require little to no coding and shortened setup time. In other words, there is no need for you to provide the logic necessary to drive the report. Moreover, managing the logic and the subscriptions within SQL-RD is both easier and more efficient. There are a number of conditions that could be created with Event Driven Subscriptions. Let’s look a few that are built into SQL-RD.

 

Topics: sql server reporting services ssrs Event Based Schedules SQL server ssrs reports scheduling event driven subscriptions schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports