We help IT Professionals succeed at work.
Get Started

Email based on ssrs data set email

johnnyg123
johnnyg123 asked
on
152 Views
Last Modified: 2017-04-20
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????
Comment
Watch Question
SQL Server Consultant
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE