Report/Query result re-ordering should support secondary sort field.
|Reported by:||Owned by:|
You get a little of this when you select grouping and ordering. It's grouped by the primary ordering, then sorted within the group for the secondary ordering. However, with lots of tickets, it's nice to have two sort levels within a grouping.
My favorite implementation makes the current primary sort field into the secondary sort field when another column is clicked. Here's an example:
The subsequent row is the result of the click action on a given row.
You get the idea.