||Re: Sorting detail listing under a Group
Mervyn Bick <email@example.com>
||Wed, 10 Jul 2019 22:03:29 +0200
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
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'