Groups are not sorted

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
Bazsl1
Posts: 29
Joined: Mon Aug 03, 2015 8:07 pm

Groups are not sorted

Post by Bazsl1 »

I have created a report from a query and selected grouping by the Best_Time column. However, when I open the report the groups are not in alphabetical order. Instead, the order of the groups appears to be random. Note that the query on which the report is based does sort the rows by the grouping column. How can I get the group in order? Thanks.
OpenOffice 4.1.2 on Windows 10 Pro
Bazsl1
Posts: 29
Joined: Mon Aug 03, 2015 8:07 pm

Re: Groups are not sorted

Post by Bazsl1 »

The following from an old post is one solution. Is there any better solution?

It seems that queries are not properly used by the Report Builder, so you have to open the query as SQL, copy all and then paste it where I'll explain you:
1-Open the report to desing it
2-Go to the form browser
3- You can see a Form called 'ReportSource'
4-Go to the hidden control 'CommandType', click with the right button, and open the properties
5-Change the value in the second line for a '2' (the source change to a SQL sentence)
6-Open properties of the hidden control 'Command'
7-In the second line ('Value') paste the SQL you copy before.

It is not bad to have the same order in the SQL that you want to have in the report. This also is good for grouping your records.
OpenOffice 4.1.2 on Windows 10 Pro
Post Reply