Apache OpenOffice (AOO) Bugzilla – Issue 106526
Query parameter must be entered twice in reports
Last modified: 2012-07-01 16:46:46 UTC
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.
Hi, can you attach a simple bug doc to reproduce this issue. Thanks and bye Marc
Created attachment 65847 [details] Sample database and report
A sample database and report is attached. Just open report R1 and enter 01.01.01 as FROMDATE and 31.01.01 as TODATE. The report asks twice for FROMDATE, but the query Q1 asks only once.
confirming, assigning, targeting
Fixed in cws dba33d. For testing, the same happens when trying to D&D the query onto the table container.
Please verify. Thanks.
Any chance to get the fix with OO 3.2?
I'm sorry but the 3.2 line is closed as far it isn't a show stopper issue like a crash could be. Best regards, Ocke
verified in CWS dba33d find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33d
Created attachment 78526 [details] File to reproduce the bug I believe that the problem is happening again on 3.5.5 (RC2) on Linux Kubuntu 12.04 (64 bits). The query works fine, but when you try open the REPORT, it ask you twice and **CRASH**! Try open the file attached. When the report ask you about a CITY name, type "New York". Same problem on LibreOffice: https://bugs.freedesktop.org/show_bug.cgi?id=51619
(In reply to comment #10) > Created attachment 78526 [details] > File to reproduce the bug > > I believe that the problem is happening again on 3.5.5 (RC2) on Linux > Kubuntu 12.04 (64 bits). There is no OpenOffice 3.5.5 RC2 > The query works fine, but when you try open the REPORT, it ask you twice and > **CRASH**! > > Try open the file attached. When the report ask you about a CITY name, type > "New York". > > Same problem on LibreOffice: > https://bugs.freedesktop.org/show_bug.cgi?id=51619 It works fine with OpenOffice 3.4.0 Closing bug.