We create a "logical" sort order for the status field for reporting by creating a custom field. Hope this helps!
Create a custom, numeric field and assign a number to each status.
Planning Sort Order
IF(Status="IDA",40,IF(Status="REQ",30,IF(Status="BCR",25,IF(Status="APC",15,IF(Status="APR...