I've gotten a request from a user to change the order that a report groups by depending on a part#. If the Part# field is <80000, then they want it to be grouped by Specie then Detail#, if it's >= 80000, they want to group by Detail# and then Specie. I was going to try using two sub-reports with a conditional display, but I'm struggling with the conditional display piece. Any help??

If the user is content to have both sections formatted the same, you can create a concatenated field that you use for sorting and grouping. Depending on the PartNum concatenated the fields a AB or BA.