Have you ever needed to send a data set to an individual when certain conditions were met? Have you ever needed to slice up a data set for different users and send their individual reports to them on a schedule? Have you ever needed to do either or both of these in multiple formats such as Excel, csv, pdf, or embedded in an email body?
SSRS has a very useful feature called ‘Data-driven Subscriptions’, and it’s meant for exactly these situations. It’s also very easy to set up! (more…)