Daniele There are maybe two workarounds
1. V_Total = sum(columname) in <tablename> where ..... (not fast but it works) 2. V_total = (v_total + <columnname>) (or put the columnvalue into a variable) In the second one you probably have initialize the variable V_total before the report is started. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Daniele Barbieri Sent: zondag 20 mei 2012 16:43 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SUM OF IN REPORT VARIABLES Thanks John all ok in 9.5 but in 7.6 it don't work. I know that 7.6 is obsolete then I must convert my procedure in 9.5 as soon as possible. Best regards Daniele ----- Original Message ----- From: "John Minyo II" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, May 18, 2012 10:19 PM Subject: [RBASE-L] - Re: SUM OF IN REPORT VARIABLES > At 04:01 PM 5/18/2012, Daniele Barbieri wrote: >>Hello >>I need some help. >>I need to define a variable in a report that is the sum of a column in a >>table without using DBCALC. >>I tried to use the expression SUM OF (colname) but the "report designer" >>reject it. >>I need the variable, the sum of a column, for use in another expression in >>the report. >>How do I do. >> >>Thanks >> >>Daniele Barbieri >>B.M.B. Informatica > > > Daniele, > > Please remove the parenthesis from the "SUM OF (colname)" expression. > > The expression should read: SUM OF colname > > Best regards, > > John Minyo II > Customer Service > R:BASE Technologies, Inc. > P: 1+724.733.0053 > http://www.rbase.com > http://www.facebook.com/rbase > >
