I'm making a crystal report using Crystal Reports for VS2012 to show the amount of cord ordered to be cut during a date range. I've got everything working except one part and I'm not even sure this is possible.
How the report is set up right now is like this:
- Group 1(Date) (ex. 03/13/13)
- Group 2 (Who Ordered) (ex. Dan)
- ...Details (Including cord length)
- Length Total (ex. Dan's Total for 3/13/13)
- ...Details (Including cord length)
- Group 2 (ex. Tom)
- ...Details
- Length Total (ex. Tom's Total for 3/13/13)
- ...Details
- Group 2 (Who Ordered) (ex. Dan)
- Group 1 (ex. 3/14/13)
- Group 2 (ex. Dan)
- ...Details
- Length Total (ex. Dan's Total for 3/14/13)
- ...Details
- Group 2 (ex. Bob)
- ...Details
- Length Total (ex. Bob's Total for 3/14/13)
- ...Details
- Group 2 (ex. Dan)
What I'm wanting to do is at the end be able to have a sum for each of our 3 main people and another sum for any other names in the report footer, so it looks like this:
Total:
Dan: ### (Total of all of Dan's Cord Length totals)
Tom: ### (Total of all of Tom's Cord Length totals)
Bob: ### (Total of all of Bob's Cord Length totals)
Other: ### (Total of all cord cut for people other than Dan, Tom, Bob)
Is there a way to do this, or am I just asking for to much?