To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101168 Issue #|101168 Summary|Report Tool lacks support for custom SQL queries, i.e. | with UNIONs Component|Database access Version|OOo 3.0.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|danielkulesz
------- Additional comments from danielkul...@openoffice.org Fri Apr 17 16:17:30 +0000 2009 ------- Having a more complex query makes using the OpenOffice Reporting tool pretty useless. The Query-Tool does not support SQL Statements with Unions unless you explicitely turn on "run SQL query directly" - which is a usability issue, OOo should detect the UNION keyword and propose this automatically. Even very simple Queries like the following are not supported: SELECT Bezeichnung from Veranstaltung UNION Select Teil from Veranstaltung Now, having turned on this option the Query works and is usable just like any other query, except it cannot be edited in design mode etc. But when I want to use this Query in the Report Tool, a very misleading error pops up as shown in the attached Screenshot. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
