Email Summary Data to various Managers

[teresa.danna@gmail.com]

I'll walk you through an example since I'm having trouble explaining exactly what I need. This is a relational datasource.

Column 1
Employee
Column 2
Project charged
Column 3
Project Manager for Project Charged
Column 4
Project Manager Email
Column 5
Hours

I would like to email every Project manager that employee has hours assigned to through a burst, not just the hours they've charged specifically for that Project Manager. Does this make sense? How do I do this? Is it even possible? FYI - I know how to do bursts, so feel free to skip that final step.

[teresa.danna@gmail.com]

Some more info:

The email would look something like:

Project Manager 1 email:

Employee1 | Project1 | Hours
Employee1 | Project2 (not under Managers purvue) | Hours
etc....

[teresa.danna@gmail.com]

I finally figured this out. For posterity, I had to wrap my head around the fact that this would cause the report to have a "doubling" issue, something which is normally an issue. I started with the data below and then joined in a query with just Employee and Project Manager - not the project.

[bdbits]

Glad you got it working, even without our help.  8)