[resolvido] Repórter order by in group

[Nilton GO]

I need the "order by" to be in the group id field (sector_id) in the report.
I make the clients report (tbClient), related to two tables, where the sector table (tbSetor) is the group, and the table (tblocal) is the subgroup. I need to use the sector_id field as order by of the group. I made the query and when opening the correct relation appears, but when opening as a report the order is done with the field sector_description. This sector_description field is what you see in the report.

[Avelino Sampaio]

Hi Nilton

Open the report in Design view
Click the Design tab of the ribbon.
In the "Grouping and Totals" group, click the "Group and sort" button

[Nilton GO]

I was able to solve it, with a simple explanation, short and fast.
It was a week ago and I could not get help on how to solve it. I am very grateful.