For more report flexibility, there is a suggestion to create a new sorting option with a hybrid of "flat layout" and "hierarchy layout":
Sort just like the sequence in flat layout, but with the parent elements being expandable/collapsable just like in hierarchy layout.