One to Many Link Group Footers totals

[jleboeuf]

Hi !

I'M using CR 8.5 and i'm having a problem to summerize a userfield because of a one to many field link
Have 3 different Groups

Group3 by POnum
Group2 by Country
Group1 by Currency

POnum and userfield come from POheader table and totalpoline from POdetail table link by ponum

Ponum userfield totalPOLine
76520 500 100
76520 500 150
76520 500 115

Group3Footer 500 <--- 365

76521 200 100

Group3Footer 200 100

Group2Footer 700 465

Group1Footer etc...
this is what i want and can't figure out how

thanks


Jean-Paul Leboeuf

jp.leboeuf@ggi-international.com

 

[lbass]

Insert a running total that does a sum of the userfield, evaluate on change of group: PO, reset on change of Group#3. You will need separate running totals for each group footer, with the reset changed each time to correspond to the group level.

-LB