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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124408
           Summary: Report builder does not work with aliases and grouping
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jt at dpets.uk

Description:
If I use aliases for calculated values in a query and use the aliases in a
report the fields are blank, but I can use grouping for the report.
If I don't use aliases for calculated values in a query and use the generated
names for the fields (e.g. CONCATENATED) in a report the fields shown
correctly, but I if use grouping for the report I get errors when I try to run
the report.

Steps to Reproduce:
1. Using the attached test database, try each of the four reports.  These give
the four different outputs, with and without aliases and with and without
grouping.


Actual Results:
See the reports produced.

Expected Results:
Reports with all fields correct and grouping.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190328/f741e92a/attachment.html>