There is an error in the Report Builder in LO 22.214.171.124
The moment the User creates a specific report with Text as the file format, the report is correct, but the moment the User needs to create a report with Spreadsheet format, it 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, before a result-set is created.
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: LIKE ‘%’ || :DocumentNumber || ‘%’
This allows the User to enter any part of a DocumentNumber.
In the result-set for Text format, all the information is correct, including the DocumentNumber.
When changing to the Spreadsheet format, the result-set shows the DocumentNumbers as not making any sense.