<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Report Builder does not provide correct Text and/or Spreadsheet result-set"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135352">135352</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Report Builder does not provide correct Text and/or Spreadsheet result-set
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>basd@shaw.ca
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=163832" name="attach_163832" title="Example for the use of 10 digits DocumentNumber in a Report">attachment 163832</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=163832&action=edit" title="Example for the use of 10 digits DocumentNumber in a Report">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>