To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=111737
Issue #|111737
Summary|average value does not display in openoffice.org base
|report
Component|Database access
Version|OOO320m9
Platform|Opteron/x86_64
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|MySQL Connector/OOo
Assigned to|dbaneedsconfirm
Reported by|jgsylvester
------- Additional comments from jgsylves...@openoffice.org Thu May 20 21:31:26
+0000 2010 -------
I have a database created in Openoffice.org Base version 3.2. I do NOT have Sun
Report Builder extension installed. My PC is running Ubuntu 10.04. The database
has records with fields: ID, 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 in the header area. I right-click on the field, select Form...Data
tab type SQL command, with content SELECT Average("Reading 1") as "Avg1" from
"Blood Sugars". The numeric field has Control...Data Data Field name "Avg1".
When I open the report, the average value does not display. The box surrounding
the field displays. When I replace the function Average with functions Count, or
Sum, or most other functions, the indicated result displays with no problem.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
