I agree, this functionality to sort by multiple columns simultaneously in the same report would be ideal. For example, I may want to sort my view by the assigned user first, then by close date. With the ability to only sort by one column, it makes these views less usable