I have a report that contains information on employees with grouping and sorting.
It is currently set up like this:

Group on Employee with A on top     Group on TempStartDate with A on top         Group on StartDate with A on top

The data needs to be grouped like that for the report to show correctly.  Only problem is that the report will always show alphabetically by employee.
What I need to know is if there is any way to insert a sort before the first group via VBA...something to the effect of this:

Sort by TempStartDate with A on top     Group on Employee with A on top          ....

That way it will order the report by TempStartDate instead of Employee.  

So is there any way to programmaticly add/remove/move those kinds of Groups/Sorts?  Or do I have to have multiple copies of the report based on how I want it sorted?

Thanks for any help you can give!