asked on

Email based on ssrs data set email

Here is my situation

I have an report that includes support person email among other items. (There are 6 unique emails)

Here is some sample data

Recordid customerid orderdate orderamount supportpersonEmail
1 1234 03/31/2017 100 jdoe@email.com
2 5678 03/29/2017 150 jsmith@email.com
3 8234 03/31/2017 125 jdoe@email.com
4 4675 03/29/2017 75 jsmith@email.com

Trying to determine a way that each support person would get an email with an excel attachment with only the report records associated with his/her email address

using sample data john doe would receive

Recordid customerid orderdate orderamount supportpersonEmail
1 1234 03/31/2017 100 jdoe@email.com
3 8234 03/31/2017 125 jdoe@email.com

John smith would receive

Recordid customerid orderdate orderamount supportpersonEmail
2 5678 03/29/2017 150 jsmith@email.com
4 4675 03/29/2017 75 jsmith@email.com

I was thinking perhaps a data driven subscription??? If that is an option not sure exactly how

Thoughts????

ASKER CERTIFIED SOLUTION

Megan Brooks

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johnnyg123

ASKER

Did use data driven subscription in

Step 3 - Create a data-driven subscription

I executed a stored procedure that returned the list I was looking for