To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106526 Issue #|106526 Summary|Query parameter must be entered twice in reports Component|Database access Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|schaber
------- Additional comments from [email protected] Sun Nov 1 16:41:52 +0000 2009 ------- I have checked the forums about this problem, and it obviously happens to other users as well, but I could not find any bug report that covers the problem. I do not find any way to rework my query so that the report won't ask twice for the parameter :FROM_DATE. SELECT "ID", "ENTERDATE, "LEAVEDATE" FROM "MYTABLE" WHERE ( "LEAVEDATE" IS NULL OR "LEAVEDATE" >= :FROM_DATE ) AND ( "ENTERDATE" IS NULL OR ( "ENTERDATE" >= :FROM_DATE AND "ENTERDATE" <= :TO_DATE ) ) When executing the query it only asks once for :FROM_DATE, but when I use the query in a report, it asks twice for it. This is annoying for users of the report, besides it is error prone. --------------------------------------------------------------------- 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]
