[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

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #2 from Alex Thurgood <iplaw67 at tuta.io> ---
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)

-- 
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/0522e1c7/attachment.html>