David -
To quote Razzak from "Understanding Dotted vs. Ampersand Variables":
04. A rule of thumb for when to "dot" a variable is to always "dot"
the variable when it is on the right side of the operator.
07. Dotted variables are used in Form and Report expressions as they
are in the SET VAR command. On the right side of the operator,
dot the variable.
Looks like a Report expression to me and looks like the variable is on the
right side.
Bernie
At 10:06 PM 11/20/2001 -0500, you wrote:
>Dennis
>
>This is worth a donation to Sami - didn't you read Razzak's email about
>variables? NO dot is needed.
>
>NOT: rvSumWhatever = SUM OF .vWhatever
>
>but instead: rvSumWhatever = SUM OF vWhatever
>
>David Blocker
>
>----- Original Message -----
>From: "Dennis McGrath" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, November 20, 2001 7:44 PM
>Subject: RE: Summing Variables
>
>
>> 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]
>>
>>
>>
>>
>
>
