History Summary Classic Report, summing on a new sort... [ Edited ]

[mmorgan_dft]

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

Message Edited by mmorgan_dft on 06-04-2009 08:55 PM

Message Edited by mmorgan_dft on 06-04-2009 08:56 PM

Message Edited by mmorgan_dft on 06-04-2009 08:57 PM

[Roy_Laudenslager]

Don't waste your time. You can use the regular filtering to run the History
Summary Classic report for a single user. The main problem is that part of
the user determination is done on the contact table and part is done in the
history table. A single History Summary Classic report that gave separate
totals for each user would be great but I've not found any way to do it.

[mmorgan_dft]

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