Sorting for a report

[Emma]

I have a report which is sorted by Client ID. I added a query to it to pick
up housing status, I would like the entire report to be sorted by housing
status, I added housing status to a group level of it's own. But the database
is still sorting by client ID? Any suggestions?

 

[Emma]

I figured out I had to delete the Client ID level.

 

[KARL DEWEY]

You can have two levels or more of sorting, just make sure the hiearchy is
correct.