Ubuntu
openoffice.org package

Cannot add more than one unique SQL statement to report in Base

Asked by Joe

I have a database created in Openoffice.org Base 3.2. I have created a report. I do NOT have Sun Report Builder (SRB) extension installed. I add a numeric field and setup an SQL statement. I add a second numeric field. This second numeric field has the same Control properties as the first numeric field. If I change the SQL statement in either the first or second numeric field, it is changed in the other field. I cannot create two separate SQL statements/conditions.. This also is the same situation if a add a second formatted filed or test box. Is this a feature/limitation of Base or a possibly a bug? Is there any way to get around this without having to install SRB?

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 found a/the work-a-round for this problem. Just add the additional fields and label each field uniquely (e.g. Avg1, Avg2, etc). Expand the single SQL statement in one of the fields to include the additional statements. For my situation, the one SQl statement is SELECT Sum("Reading") AS "Avg1" FROM "Blood Sugars", Sum("Reading 2") AS "AVG2" FROM "Bloood Sugars", and so on.