I am looking at customizing my data driven subscription query in SSRS so that depending on the results of the original query it will notify the correct department.
For example the query returns:
ID Dept Amount Name
1 Sales $70 Shelly
Then the email only goes to the sales department and no other department such as marketing or HR
I am looking at using a data driven query and notifying users by email