Chapter 28. Data alerting

In Chapter 27, you learned about the options you have for scheduling the execution of a report, with the option to email the report each time the schedule runs. However, you might prefer to limit the email delivery of a report. Rather than receive a report every Monday morning, which you must then review to determine whether a condition in the report requires you to take action, you can set up a data alert to send an email notification only when that condition is true, as long as you are running a report server in SharePoint integrated mode. The report server continues to execute the report on a scheduled basis and tests the data values in the report against the rules that you specify when you create the data alert. In ...

Get Microsoft SQL Server 2012 Reporting Services now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.