To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73527
Issue #|73527
Summary|Report does not get filled with data from complex quer
|y
Component|Database access
Version|OOo 2.2
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|jocaha
------- Additional comments from [EMAIL PROTECTED] Tue Jan 16 07:45:33 -0800
2007 -------
i have a hsql database as an open document database file (.odb). I open it with
Star Office 8 Update 5. I have created some reports.
I have a query which uses non-trivial sql (read further informaion on this
below) so i can not be displayed in the wizard, although it works fine in
direct-sql-mode and gets filled with data.
On creating a report using this query, the fields names get displayed in the
report wizard.
On displaying the report (via double-clicking on its name) the document does not
get filled with the query's data, and the example text ("Ut wisi enim ad minim
veniam, quis nostrud exerci tation") stays visible.
Further information about my sql:
I have a database of members and friends of an association. One of the fields is
a boolean value "Member" which is true if the guy is a member of the
association. In a report, i do not want to write the true/false value but i want
to write "M" if the guy is a member and nothing if not. So my sql looks like
this:
SELECT "name", (CASE WHEN ("member" = 'TRUE') THEN 'M' END) AS "member2" FROM
"Data"
That is what does not work as described above.
Note that this is a Star Office 8 bug. Maybe it appears with OOo too. I have not
found the right place to report a bug on Sun's website. There is a general
discussion forum, but threads on the first page are almoust one month old. If
anyone knows a better place than here for reporting a Star Office bug, please
let me know.
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
