Groups are not sorted

Getting your data onto paper - or the web - Discussing the reports features of Base

Groups are not sorted

Postby Bazsl1 » Thu Mar 17, 2016 12:32 am

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

Postby Bazsl1 » Thu Mar 17, 2016 4:36 am

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
Bazsl1
 
Posts: 29
Joined: Mon Aug 03, 2015 8:07 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests