title: Dynamically Set the to Address in SSRS reports Subscription
body: <p>I show a list of items with a field Assigned to, which are email addresses. Right now I have set up a subscription with distinct list of assigned to email addresses and sent the entire items list to all the users. I want to sent only the items assigned to a particular user to that user; Instead of having to sent all the items to all the users.
  Can this be done in SSRS? I would have to dynamically set the To address, and filter out the result dataset.</p>