CHAPTER 10 MANAGING REPORTS
The most important of these steps is step 4, in which you specify the settings for the delivery
extension. This is where you’ll use the data from the driving query to instruct SSRS how to send the
subscription. Every selection in step 4 has the option to retrieve the value derived from the query used in
step 3, which is much more versatile than a standard subscription.
You paste the query into the query box in step 3, as you can see in Figure 10-22, and verify it by
clicking the Validate button. From this point, the fields you selected in the query, namely
EmployeeTblid, Email, HWUserLogin, and ActivityDate, can all be used as criteria in the remaining
steps.Figure 10-22. The verified query that drives the subscription