Ask Your Question
0

Report Builder does not provide correct csv result-set

asked 2020-07-31 06:48:33 +0200

Dreamquartz gravatar image

updated 2020-07-31 06:51:03 +0200

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: 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. Please advise,

DreamC:\fakepath\Report Error.odb

edit retag flag offensive close merge delete

Comments

Hello:

Please note when cross-posting:

https://forum.openoffice.org/en/forum...

Ratslinger gravatar imageRatslinger ( 2020-07-31 21:59:38 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-07-31 18:35:11 +0200

Ratslinger gravatar image

Hello,

Testing with your sample show problems with both Text Document and Spreadsheet. The problem occurs regardless of entering a partial or entire DocumentNumber. If the query is changed to eliminate LIKE and simply stated as =, there is no problem (entire number is required).

This is a error and should be reported here -> Bugzilla.

The second required entry when output is to a spreadsheet is also an error and should also be reported.

edit flag offensive delete link more

Comments

Not sure what the right place was, so I asked in on both forums. I use OpenOffice Forum the most, but this is a typical LO issue.

I need to give the User the opportunity for entering partial numbers. The strange thing is with a 6 digit number there was never a problem. We had to upgrade the DocumentNumber to 10 digits, because of new requirements. That is where it starts to go wrong.

Dream

Dreamquartz gravatar imageDreamquartz ( 2020-08-01 00:29:20 +0200 )edit

@Dreamquartz,

It is not a matter of where ('right place') you post, it is that if posted in multiple places and no notation. Please note that and give a link to the other location. This helps eliminate duplicated effort.

Have just tested your sample with a six digit Document number - still a problem. Changed from Integer to decimal - still a problem.

Don't see any work around. If you have a working version (using LO v6.4.5.2) with six digits, please post.

Ratslinger gravatar imageRatslinger ( 2020-08-01 01:04:17 +0200 )edit

Error reported as tdf#135352 by @Dreamquartz

Turns out erratic results were caused by parameter name being the same as a field name. There is no problem with this running as a query but is a problem when input to a report. The double entry required still seems to be an open problem.

Ratslinger gravatar imageRatslinger ( 2020-08-01 21:53:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-31 06:48:33 +0200

Seen: 47 times

Last updated: Jul 31