[Libreoffice-bugs] [Bug 135352] New: Report Builder does not provide correct Text and/or Spreadsheet result-set

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: basd at shaw.ca

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200731/8d30b5b0/attachment.htm>