1. On the Design View of the report, right-click the appropriate Group Header section name (or the section where the formula exists) and select Change Group.
  2. Change the Order drop-down to Specified Order.
  3. Select the Specified Order tab.
  4. Type the name of the first group to be displayed and click New.
  5. Change the filter to Equal To and make the value the exact name that was typed into the formula. We recommend copying and pasting this name so that the wording and spelling will be exact.
  6. Click OK
  7. Repeat steps 1 to 6 for each name in the formula.
  8. When done, use the up and down arrows to arrange the groups in the appropriate order.
  9. Preview the report.