<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c6">Comment # 6</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 <a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> Robert Großkopf</a> <pre>For reports some hints: Report-Builder will analyize the code of the query. This won't work when the code should be executed in direct SQL. And if you switch the analyzing to no, grouping won't work. Best solution for all reports: Don't user queries. Use views instead. The reports of the test-database will all work with views. But then another "error" appears. Don't worry about the error-dialogue. The view will be created and could be seen after the tables will be actualized by "View" > "actualize Tables" (or something like this - haven't opened LO in English mode.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>