Sorting

[Guest]

I would like to change the sort field for my reports based on criteria
selected on my Report Selection form. For example, i have a report that needs
to be sorted by Customer and by Order Date, but it will vary, depending on
the option selected. How do I change the sort options in a report via code?

Options: Customer and OrderDate

Thanks.

 

[Guest]

Establish 2 sorting and grouping levels in your report. Then use the coding
example found at this link to set them as you need based on your form input.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproGroupLevel.asp

Hope this helps....