average value does not display in openoffice.org base report

Asked by Joe

I have a database created in Openoffice.org Base version 3.2. I do NOT have Sun Report Builder extension installed. The database has records with fields: Date, Reading 1,...,Reading 4.I create a report displaying the database records. In the design mode of the report, I add a numeric field. I right-click on the field, select Form...Data tab type SQL command, with content SELECT Average("Reading 1") as "Avg1" from "Blood Sugars". When I open the report, the average does not display. The box surrounding the field displays. When I replace Average with Count, or Sum, or most other functions, the indicated result displays with no problem. Am I doing something wrong or is there a bug?
Thanks,
Joe

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Joe
Solved:
Last query:
Last reply:
Revision history for this message
Joe (jgsylvesterjr) said :
#1

I discovered a work-a-round: Replace the function Average with Sum/Count.