[Closed] Report Bldr does not provide correct csv result-set

[dreamquartz]

Hi All,

There is an error in the Report Builder in LO 6.4.5.2
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:

Code: Select all

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.

Attached you will find an example of the information the User uses and a report.

Please advise,

Dream

[Ratslinger]

This is cross posted and answered here:

https://ask.libreoffice.org/en/question ... esult-set/

[dreamquartz]

Not sure where to place the question, so did it on both forums.

I will continue at the LO forum for an answer.

I consider this topic closed.

Dream.