[Solved] Sorting in Query Not sorted in report

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

[Solved] Sorting in Query Not sorted in report

Post by capemayal1 »

OO 3.4.1
Ubuntu 12.04LTS 64-bit

I have designed a query, both in the design mode and in SQL mode.

I have sorted on a text field.

The query works as expected - sorted on the text field.

When I create a report from the query, the reported is sorted by ID not by the text field.

I have tried not sorting in the query, but sorting in the report. No change.

I have tried sorting in the report only. No change.

It doesn't seem that hard to do, but I just can't figure it out.

Any help would be appreciated.

Al
Last edited by capemayal1 on Sat Jan 26, 2013 5:56 pm, edited 1 time in total.
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: Sorting in Query Not sorted in report

Post by eremmel »

Post a non-confidential version of your Base document so other might examine what is going on.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

Re: Sorting in Query Not sorted in report

Post by capemayal1 »

I was able to solve my problem by upgrading to LO 3.6.4

Thanks for your help.
Al
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Sorting in Query Not sorted in report

Post by Villeroy »

capemayal1 wrote:I was able to solve my problem by upgrading to LO 3.6.4

Thanks for your help.
Al
But we can not reproduce your problem so it can not be fixed in AOO.
 Edit: OK, now I see what you mean. You get the same type of report as in LO if you install the report builder extension which is pre-installed in the LO package. 
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply