Allow End User to Select Sort Groups?

[Surdeymon]

Hi -

I am curious if this is worth my effort. I am in the process of putting together a form that has a lot of end user options to filter data on reports based upon the values they select on a few list and check boxes and a combo box or two.

In lieu of creating 15-20 different predefined reports that contain predefined sort groups - I was wondering if there is an easy way to allow the end user to choose up to 3 different sort groups and have the reports automatically change the grouping levels based upon the end users selections on this form?

Make sense? Thanks for any feedback in advance...Rob

 

[WayneRyan]

Surdeymon ,

Use the Search Facility here and look for "QueryDefs". There are examples
of how to dynamically build a query. You only need to worry about the
Order By clause.

Wayne

 

[Surdeymon]

Thanks Wayne

In lieu of a report - I will create a control that based upon user selections will create a QueryDef that defines that control and use the ORDER BY as the sort drive.

Thanks for the feedback.

Surdeymon