<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Report builder does not work with aliases and grouping"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124408">bug 124408</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Report builder does not work with aliases and grouping"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124408#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Report builder does not work with aliases and grouping"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124408">bug 124408</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>Testing against LO6212 on macOS 10.14.3 :
In all of the reports that will open (the first 3), I repeatedly see what
appears to be HTML table instructions in the left hand column, which indeed
appears erroneous (and from what I can tell, not present in the query results).
Is this relevant, or was the report designed this way ?
The 1st report TestGroupAlias :
- shows truncated data in the second column
The 2nd report TestGroupNoAlias :
- appears to show the required information in the right hand column
The 3rd report TestNoGroupAlias :
- shows truncated data in the second column
The 4th report TestNoGroupNoAlias :
- generates the following error message :
org.libreoffice.report.ReportExecutionException: firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid command
*no column name specified for column number 6 in derived table
__LibreOffice_report_result
caused by
'isc_dsql_prepare'
org.libreoffice.report.ReportExecutionException: firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid command
*no column name specified for column number 6 in derived table
__LibreOffice_report_result
caused by
'isc_dsql_prepare'
at
org.libreoffice.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:350)
at
org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:217)
Caused by: org.jfree.report.ReportDataFactoryException: firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid command
*no column name specified for column number 6 in derived table
__LibreOffice_report_result
caused by
'isc_dsql_prepare'
at
org.libreoffice.report.pentaho.StarReportDataFactory.queryData(StarReportDataFactory.java:68)
at org.jfree.report.data.CachingReportDataFactory.queryData(Unknown
Source)
at org.jfree.report.data.ReportDataRow.createDataRow(Unknown Source)</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>