If i understand you correctly as long as your rows do not overlap to fall into both groups you can avoid a sub report.
Create a formula to to determine which rows fall into which categories and then group on the formula.
if condition1 then "Product Orders" else
if condition2 then "Manufacturing Instructions"
else "Missed Records"
The last item is just a safe guard to make sure all your records fell into 1 or 2.
If any row overlaps into both categories then you will need a sub report.