running totals by group

[atarrqis]

CR 11 and Oracle
I have Milestone, Part, Qty, Date Due and I group by Milestone and then Part.
In a subreport I have Part, Qty Received, Receipt Date and I link Part to Part and Date Due <=Receipt Date. I want to count Qty Received and if this is greater than Qty it needs to go into the next Milestone.
M1 abc qty = 16 2/28/2012
M2 abc qty = 12 3/30/2012
3 on 12/27/2011
15 on 1/12/2012
5 on 1/27/2012
10 on 2/24/2012

I need the report to show
M1 abc qty = 16 2/28/2012 3 12/27/2011
13 1/12/2012
M2 abc qty = 12 3/30/2012 2 on 1/12/2012
5 on 1/27/2012
5 on 2/24/2012
Is this possible using shared variables or ?

 

[Madawc]

Shared Variables are for information passed from a subreport to the main report. Not relevant here.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP