Coordinating the sort order in a report with the underlying query

[Paul]

I've noticed that you can sort records on any field in a report by adding
that field to the Sorting and Grouping dialog box in Report Design View.
Does this override the sort order designated in an underlying query?

I'd like to follow best practices for designing a report, and so I'm
wondering if it's better to use the query to sort records, and just use the
Sorting and Grouping dialog to establish grouping levels.

I'd appreciate any suggestions in this regard.

Thanks in advance,

Paul

 

[Allen Browne]

Yes: the Sortin'n'Grouping in the report defines its sort order. You may as
well just omit any sorting in its source query.

It is possible to programmatically set the ControlSource of the GroupLevel
when you open the report. This article explains how:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

 

[Paul]

What a great way to give my users control over the sorting of a report.

Thanks (again), Allen.

Paul