<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<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#c5">Comment # 5</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:jt@dpets.uk" title="John Talbut <jt@dpets.uk>"> <span class="fn">John Talbut</span></a>
</span></b>
<pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=124408#c2">comment #2</a>)
<span class="quote">> 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)</span >
Yes, these are the results that I get.</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>