troubleshooting Question

Email based on ssrs data set email

Avatar of johnnyg123
johnnyg123Flag for United States of America asked on
SSRS
2 Comments1 Solution153 ViewsLast Modified:
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
SQL Server Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros