https://bugs.documentfoundation.org/show_bug.cgi?id=135352
Bug ID: 135352
Summary: Report Builder does not provide correct Text and/or
Spreadsheet result-set
Product: LibreOffice
Version: 6.4.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 163832
--> https://bugs.documentfoundation.org/attachment.cgi?id=163832&action=edit
Example for the use of 10 digits DocumentNumber in a Report
There is an error in the Report Builder in LO 6.4.5.2
The moment the User creates a specific report the result-set is incorrect.
Reports are created as follows:
1. The User creates a Query with the required result-set.
2. The User then uses the Wizard to create a report in the Spreadsheet format
to save it as an csv-file.
When creating a report in Text format, the User has enter the parameter once.
The moment the User creates a report in Spreadsheet format, the User needs to
the parameter twice.
The parameter for the report is the DocumentNumber. The number consists of 10
digits.
The input format:
Code: LIKE ‘%’ || :DocumentNumber || ‘%’
This allows the User to enter any part of a DocumentNumber.
Using ĹIKE' is a design requirement and cannot be changed.
In the result-set shows the DocumentNumbers as not making any sense.
Attached you will find an example of the information the User uses and a
report.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs