Setting Sort Order By Coding

[Steve Arndt]

I have a report that has a default Sort and Grouping (field names and
Asc/Dsc).

I also want to be able to set the Sort Order on the fly from within a form
via a command button.using OrderBy and OrderByOn.

1. Can this be done? And without permanently changing the default sort
order designed into the report Sort and Grouping?
2. If so, can I set this criteria after using an .OpenReports with an
acviewPreview, or do ave to do this some other way (such as in
acviewDesign)?
3. If acviewDesign, can I do this without displaying the report in the
background in design mode, and can I shut it automatically down without
saving the Sort and Group changes.
3. If I want to use filtering info, can I use a SelectionCriteria in the
..OpenReports statement (after acViewPreview) or do I need to use FilterByOn
and FilterOn.

Any code examples where this is done would be appreciated.

Thanks

Steve

 

[Duane Hookom]

Allen Browne has some code for this at http://allenbrowne.com/ser-33.html.