Custom Sort in Crystal Reports

To clarify the other answer - you need to change the sort order from ascending (or descending) to specified order. To do this:

1. Right-click in the grey area to the left of the page layout for the relevant group header (or footer) and select Change Group... .
2. In the Common tab of the Change Group Options dialog, change the selected sort order from "in ascending order" to "in specified order". A new tab headed "Specified Order" will open in the dialog.
3. In the Specified Order tab, select each of the required categories from the Named Group dropdown and add them to the list of specified groups in the desired order. (You can adjust this order with the arrows immediately to the right of the list.)
4. When the list of categories is in the desired order, click OK at the bottom of the Change Group Options dialog and preview the output. This should now appear in the desired order.

Suppressing report sections will have no bearing on how the records are sorted. A report will always have its records sorted from the outer-most group field to the inner-most group field. In your report, the records will first be sorted by "Project", then by "RFI", and finally by "Status" regardless of what you are or are not suppressing.

If you want to choose which field to sort the report by via a parameter, then you should create a formula field and sort by that instead. So something like: if {?Sort}="RFI" then {table.RFI} else {table.Status} but you'll need to get rid of your RFI and Status groups first.