Dear Richard, Summing variables in a report is a best tricky, at worst it is a nightmare.
Are Subscription Fee, Payment Received, and Variance all columns or is Variance a variable on the report? If it is, I lost some of my hair on that issue till I did as follows. SET VAR vDtlVariance = (SubFee - PayRcvd) SET VAR vRFSubFee = SUM OF SubFee SET VAR vRFPayRcvd = SUM OF PayRcvd SET VAR vRFVariance = (.vvRFSubFee - .vRFPayRcvd) Have all compute at the detail level (the default) and position the first on the detail line and the last three on the report footer level of the report. Let me know if this does not work. There is another technique of setting two var at the break footer level and having one recompute at the break footer and the other not, but on the data you have provided the method spelled out above would be simpler for you to adopt and would fill the specs I have. At 04:58 PM 20/11/2001 -0500, you wrote: >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] Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
