<:f900,2Tms Rmn,0,0,0><+!><:f900,BHelveticaNeue MediumCond,0,0,0><-!><:f><+!><:f260,6Times New Roman,0,0,0>
@Normal@<:#308,14><+!><:f260,6Times New Roman,0,0,0>
<:#288,4920><+!><:f240,BHelveticaNeue MediumCond,0,0,0><-!><+!>Objective<-!><:f240,6Times New Roman,0,0,0>
@Normal@<:#852,4920><:f240,6Times New Roman,0,0,0>Use macros and a variable field to add a running total to a columnar report. This running total can be displayed in both Browse and Preview.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:#288,4920><+!><:f240,BHelveticaNeue MediumCond,0,0,0>Example<-!><:f240,6Times New Roman,0,0,0>
@Normal@<:#2556,4920><:f240,6Times New Roman,0,0,0>Define a variable field, <+">var<-">, a running sub-total numeric field
<+">runsub<-"> and three macros. Set <+">var<-"> to numeric by clicking the Options button in Field Definition. The first macro sets
<+">var<-"> to zero, goes to the first record and calls the second macro. The second macro sets
<+">runsub<-"> to the sum of <+">var<-"> and the value field and then calls the third macro. The third macro sets
<+">runsub<-"> to <+">var<-">, goes to the next record and calls the second macro.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:#288,4920><+!><:f240,BHelveticaNeue MediumCond,0,0,0>To create macros<-!><:f240,6Times New Roman,0,0,0>
@Normal@<:#852,4920><:f240,6Times New Roman,0,0,0>Under the Edit menu choose Define Macro, call the first macro mac1, the second macro mac2 and the third one mac3.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>In mac1
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>1) Set<+"> var<-"> to 0.
@Normal@<:R1,14,1,270,1,720,1,1440,1,2160,1,2880,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,1,9360,><:#568,4920><:f240,6Times New Roman,0,0,0>2) Under menu options, highlight and add 'First
Record'.
@Normal@<:R><:#284,4920><:f240,6Times New Roman,0,0,0>3) Click on the 'Add' button.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>In mac2
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>1) Set <+">runsub<-"> to <+">var<-"> + value field.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>2) Click on the 'Add' button.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>In mac3
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>1) Set <+">var<-"> to <+">runsub<-">.
@Normal@<:R1,14,1,270,1,720,1,1440,1,2160,1,2880,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,1,9360,><:#568,4920><:f240,6Times New Roman,0,0,0>2) Under menu options, highlight and add 'Next
Record'
@Normal@<:R><:#284,4920><:f240,6Times New Roman,0,0,0>3) Click on the 'Add' button.
@Normal@<:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:R1,14,1,270,1,720,1,1440,1,2160,1,2880,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,1,9360,><:#1420,4920><:f240,6Times New Roman,0,0,0>1) open mac1, under the 'Next' option at the bottom
of the macro sheet, check 'Run Macro' and choose mac2 from the drop down list. Then click
on 'Change' at the top of the macro sheet.
@Normal@<:R1,14,1,270,1,720,1,1440,1,2160,1,2880,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,1,9360,><:#568,4920><:f240,6Times New Roman,0,0,0>2) open mac2, go down to 'Next', run macro mac3
and click on 'Change'.
@Normal@<:R1,14,1,270,1,720,1,1440,1,2160,1,2880,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,1,9360,><:#568,4920><:f240,6Times New Roman,0,0,0>3) open mac3, go down to 'Next', run macro mac2
and click on 'Change'.
@Normal@<:R><:#284,4920><:f240,6Times New Roman,0,0,0>
@Normal@<:#1136,4920><:f240,6Times New Roman,0,0,0>Now add a <+">runsub<-"> field onto the report if you haven't done so and run macro mac1. Below is an example of a columnar report with a running sub-total.
@Normal@<:I0,0,0,360><:#284,4920><:f240,6Times New Roman,0,0,0>