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

Getting your data onto paper - or the web - Discussing the reports features of Base

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

Postby dreamquartz » Fri Jul 31, 2020 6:36 am

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   Expand viewCollapse view
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
Attachments
Report Error.odb
(18.27 KiB) Downloaded 17 times
Last edited by dreamquartz on Sat Aug 01, 2020 12:26 am, edited 1 time in total.
LO 6.x, HSQLDB 2.5.0 & Ubuntu 20.04 LTS.
dreamquartz
 
Posts: 772
Joined: Mon May 30, 2011 4:02 am

Re: Report Builder does not provide correct csv result-set

Postby Ratslinger » Fri Jul 31, 2020 9:58 pm

This is cross posted and answered here:

https://ask.libreoffice.org/en/question ... esult-set/
LibreOffice 6.1.3
OpenOffice 4.0.1
Ubuntu Mate 18.04
Mint 18.3
Ratslinger
 
Posts: 23
Joined: Sun Mar 01, 2015 3:34 am

Re: Report Builder does not provide correct csv result-set

Postby dreamquartz » Sat Aug 01, 2020 12:25 am

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.
LO 6.x, HSQLDB 2.5.0 & Ubuntu 20.04 LTS.
dreamquartz
 
Posts: 772
Joined: Mon May 30, 2011 4:02 am


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest