Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subreport Grouping Post Reply Post New Topic
Author Message
mrc161
Newbie
Newbie


Joined: 27 Dec 2007
Location: United States
Online Status: Offline
Posts: 19
Quote mrc161 Replybullet Topic: Subreport Grouping
    Posted: 19 Dec 2008 at 7:42am

Hello.  I have a question regarding a report I have that has several subreports embedded in it.

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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.