order by not working correctly

[jebushatescats]

Hello all I have a report who's data is based on a query. The query contains the following order by clause
ORDER BY Dept,
SupervisorName,
EmpName

When I execute the query the records appear in the order that I want.
My problem is that the report does not display the records in the same order. I have listed the above fields in the sort and group window in the same order that they appear in the ORDER BY statement in the query. I also require that the report break to a new page on EmpName so I have set the EmpName group header to force new pafe before section.
So the reports orders by Dept correctly bu the Supervisor and EmName are not in the correct order.

Have I missed something?

 

[jebushatescats]

Boy am I dim witted this morning, after posting I went back and took a look at what I did and realized I did not have the fields in the sort and group the same as the fields in the ORDER BY clause of my SQL, problem solved!!

 

[lespaul]

As you found the Sorting and Grouping in a report is not driven by the sort order of the query, it's a separate module within the report that controls that. Glad you figured it out though!

Leslie