[Libreoffice-bugs] [Bug 124408] Report builder does not work with aliases and grouping

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124408

--- Comment #5 from John Talbut <jt at dpets.uk> ---
(In reply to Alex Thurgood from comment #2)
> 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)

Yes, these are the results that I get.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190329/145077be/attachment.html>