I have been given a report that is currently group by these fields:
They now what me to add not only the location and department but to have the ability at runtime to be able to select whether to print in location/department/employee/project/cost category order or department/location//employee/project/cost order. The SQL query has been modified to handle this, however the report was originally written using groups for the
EmployeeID,Project,CostCategory values. Should I scrap those groups and start over? How do I insert the location/department groups at the beginning? Do I create a parent group? How do I get the report to sort in two different orders?