06-04-2009 07:19 PM - edited 06-04-2009 08:57 PM
I would like to be able to add an additional sort to the History
Summary Classic Report. I would like to first sort by Record Manager
then by Contact. The default sort for the History Summary Classic
report is by Contact.
I can not determine how to add or adjust the code on the Details section to
sum the total in the Section One Footer is set to Record Manager.
Section Two Footer is now sorts by Contacts.
I've tried adding in a field totalColB1 which will sum if I make the following change to the Detail Edit
Section Script as indicated below but it continues to offer a rolling sum
rather than refreshing per Record Manager. I want a total specific to each
individual record manager. Any thoughts are greatly
appreciated.
'Update report totals using subreport totals
'I created a field in Section One Footer which is the
'Record Manager sort footer entitled totalColB1
totalColB1 = totalColB1 + ColB
totalColA = totalColA + ColA
totalColB = totalColB + ColB
totalColC = totalColC + ColC
totalColD = totalColD + ColD
'Reset subreport totals
ColA = 0
ColB = 0
ColC = 0
ColD = 0
Thanks,
Michael Morgan
06-04-2009 10:34 PM
06-08-2009 03:36 PM
Thanks, Roy,
That works until there are more than a few sales folks. Jason, at Stonefield Query, built one for me in just a few minutes.
Thanks,
Michael