https://bugs.freedesktop.org/show_bug.cgi?id=72163
Priority: medium
Bug ID: 72163
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Report with Date Parameters Fails
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: bmikow...@centurytel.net
Hardware: x86-64 (AMD64)
Status: NEW
Version: 4.1.3.2 release
Component: Database
Product: LibreOffice
I have a report with an embedded SQL statement that prompts for parameters. For
example "PaymentDate BETWEEN :EnterStartDate END :EnterEndDate". When I run it
in LibreOffice 3.6, it functions correctly. When running the DB in LO 4.1.3.2,
it gives the following error: 'The Document "Report_W_Payments" could not be
opened. Failed to process the report.' I tried editing the report in the
report builder, and I get a little more detail there when executing it. It
produces a few more error lines:
SQL Status: S1000
An error occurred while creating the report.
An exception of type com.sun.star.lang.WrappedTargetException was caught.
Failed to process the report.
Failed to process the report.
I then went into the SQL builder, and ran the same code interactively,
supplying the same parameters, and it returns Zero rows, but does execute. If
I change the criteria to for payment date to ">= :EnterStartDate" and an
additional line of "<=:EnterEndDate" and run it interactively, I get the 62
rows that I would expect.
So, it appears as if there may be a few things going on here: 1. Issues with
parameter passing to the SQL engine, and 2. That the newer version of HSQL is
improperly handling the between statement for date fields.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
