Reports and select statament

[AlastairOz]

I have a single select statement to get data for my report.
I have SET ORDER TO name

I have 2 more sub groupings, and would like to have them
ordered correctly as well.
1st group = Name = OK
2nd group = Job number = not ordered
3rd group = Task number = not ordered

How do set order on the nested groups?
Would the ordering for the 2nd an 3rd group be in the select statement or in the report?


Regards

Alastair

 

[AlastairOz]

Woops, my mistake,
I forgot I could ORDER BY in the select statement on multiple
fields.

Problem Solved.

Alastair