Subject Re: Sorting detail listing under a Group
From Mervyn Bick <invalid@invalid.invald>
Date Wed, 10 Jul 2019 22:03:29 +0200
Newsgroups dbase.getting-started

On 2019-07-10 8:35 PM, William McGuffey wrote:
> Just started using the Report feature in Dbase 12.  How do I sort a listing of data under a Group alphabetically?    Example:
>                  Group      =  Boys
>                  Detail list  =     John
>                                         Bill
>                                         Adam

Your rowset must always be ordered on the field used in a group's
groupBy property.  There is, however, nothing to stop you from adding
more fields to the order by clause to arrange the data within the group.

Assuming your fieldnames are gender for the group's groupBy property and
you have last_name and first_name for text objects on the detailband
then in your query

oRef.sql = 'select * from whatever order by gender,last_name,first_name'

This will give you the boy's names ordered by surname.  If you want the
names ordered by first_name then

oRef.sql = 'select * from whatever order by gender,first_name,last_name'