DADE SQL built in functions don't work

rbuser

Hi,
I am using Delphi 6 Pro, ReportBuilder 7.02 and Advantage 7 database
tables.
In the DADE tab, after I create a new table, in the Calcs section, if I
create a calculated field like SUM(myfield) it does not give me the sum of
the field, it gives me the last value of the field. None of the choices like
AVG, MIN, MAX .. etc work. They all give me just the last value of the
current record, not the calculated value.
Here is the SQl it produced:

SELECT BloodPress.filetype, BloodPress.Notes,
BloodPress."AutoInc" AS AutoInc_2,
BloodPress.Heart_Rate,
BloodPress.Diastolic, BloodPress.Systolic,
BloodPress.Person,
BloodPress."Time" AS Time_2,
BloodPress."Date" AS Date_2,
BloodPress.PersonKey,
SUM(BloodPress.Heart_Rate) AS SUM_BloodPress_Heart_Rate
FROM BloodPress BloodPress
GROUP BY BloodPress.filetype, BloodPress.Notes,
BloodPress."AutoInc",
BloodPress.Heart_Rate,
BloodPress.Diastolic,
BloodPress.Systolic, BloodPress.Person,
BloodPress."Time", BloodPress."Date",
BloodPress.PersonKey

The SUM(BloodPress.Heart_Rate) AS SUM_BloodPress_Heart_Rate does not work.

Does it work for anyone else with Advantage tables?

Thanks.
pl