Have you tried to UNION the results together? This will cause a sort
Also, I find that some of my reports are best ordered by invisable columns that the users cannot see. They get the results in an order they like but dont have to see those columns.
Hope that this helps.
Eric