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.
Some more info:
The email would look something like:
Project Manager 1 email:
Employee1 | Project1 | Hours
Employee1 | Project2 (not under Managers purvue) | Hours
etc....
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.
Glad you got it working, even without our help. 8)