Sorting a report via code with already establised groupings

[whitesmoke]

Hi. thanks in advance to all that can help

i need to sort a report via parameters set by a user in a form.

i have a report with factory and customer groupings, but the parameters allow the user to set a sort of orderamount desc.

i've tried reassigning grouplevels, turn on order by on, and tried creating control source criteria, but no luck. the report maintains its grouping sort, but what i need it to do is set the sort to order amount, but maintain it's groupings. the parameter is being taken through code dynamically which is the hard part, i can't just edit the report to do what i want


thanks again to any suggestions.

 

[llkhoutx]

The Grouping/Sorting is going to control over the RecordSource.

The Help menu as good info on modifying them Grouping/Sorting.

It might be easiest to remove the Grouping/Sorting from the report and control output using the RecordSource. However, Grouping/Sorting are useful when sub-total are involved; without which you might have to have multiple subreports. I've done it both ways.

 

[whitesmoke]

Thanks for the info, i do need the groupings for totals and best visibility.

I think i'm going to end up creating separate reports with specifics on the sorting.

thanks again.