Data-driven Subscriptions in SSRS

Here I get into an elegant method for giving users a report that has a dynamic distribution list. As DBAs we don’t want to be in the business of managing DLs, so here we’re going to use a data-driven subscription to put DL management back in the users’ hands.