Currently, each of my reports is grouped by "Team Member" and it gives several summaries by each Team Member.

 

Now, though, I need a new report, exactly like the existing report, that provides those same summaries by "Team" (so it's one "roll-up" above the Team Member stage).

 

The whole reason I have subreports is because I had to use multiple datasources for the data - the advantage was that the "Team Member" is available in each data source.  However, the "Team" roll-up is only available in the datasource linked to the Main report.

 

So basically I want to have the Main report show the totals by Team now, and somehow look ONLY at the Main report to determine which member is on which team. 

 

Any ideas?  I tried playing with shared variables and such but have had no luck.  Right now when I switch out the Team Member group for the Team group on the Main report, it's just sorting the report by the Team Member numbers from the subreport instead of summing them as one "Team" sum.

 

Thanks, Mike