Community
Showing results for 
Search instead for 
Do you mean 
Reply

History Summary Classic Report, summing on a new sort...

Avid Listener
Posts: 43
Country: United States

History Summary Classic Report, summing on a new sort...

[ Edited ]

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
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: History Summary Classic Report, summing on a new sort...

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.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Avid Listener
Posts: 43
Country: United States

Re: History Summary Classic Report, summing on a new sort...

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