I never use the create aggregate function interface. Instead, I create my sum variable as follows
rvSumWhatever = SUM OF .vWhatever Never a problem. It would be a major step backwards for R:Base reports if SUM OF on variables ceased to work entirely. There are nifty tricks you can play with variables that just don't cut it any other way. -- Dennis McGrath mailto:[EMAIL PROTECTED] -- Productivity Tools for R:Base Programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with: SQL Resources Group Steve Hartmann Oak Park, IL mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard S. Croy Sent: Tuesday, November 20, 2001 3:58 PM To: R:Base List Subject: Summing Variables 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]
