Dick, You will need 2 vars for each of your columns, one for the page total and one for the report total. Here are the expressions
fSubFee_Page = sum of Subscription_fee fSubFee_Rep = Sum of Subscription_fee Under breakpoints for the report, you will want to reset the page vars. Locate the fSubFee_page var in the PF section at the bottem of the page. Locate the fSubFee_rep var in the RF section at the bottom of the reports. Repeat the above for you other 2 columns. Troy Sosamon >===== Original Message From [EMAIL PROTECTED] ===== >Am I missing something somewhere in R:Base 6.5++ > >I have a report with three columns, for each of which I want >to accumulate subtotals at the end of each page, and grand >totals at the end of the report. > >The columns, all currency, are Subscription Fee, Payment >Received, and Variance (this being the difference between >the previous two). > >Every time that I try to define a variable to sum up these >variable columns, R:Base tells me "No way." > >When I try the "Create Aggregate Functions", the dialog >only allows me to work with columns, not variables. > >I had a similar report in R:Base 6.5/6.5+ which let me do >just what I want to do here, but I'll be darned if I can >figure out how -- if it is possible at all -- to do it in 6.5++ > >Dick Croy > >-- >Richard S. Croy >[EMAIL PROTECTED] Troy Sosamon Denver Co [EMAIL PROTECTED]
