Microsoft SQL Server 2014 Unleashed

Subscriptions

An important advantage to having reports available on a Report Server is that you can use its subscription features to push reports to users.

You can create subscriptions using Report Manager. Start by publishing a report to the catalog. Start Report Manager, click the Details View link, hover over a report of your choice, and then click Subscribe.

The first step in the Subscription dialog is to choose a delivery mode. There are three built-in delivery methods: email, file share, and null. The null delivery, as its name suggests, doesn’t deliver anywhere; however, you can use it as a way to periodically load reports into the Report Server cache. For details, see the section, “Report Execution Options,” later in this chapter.