I can't see that what you need is more than this:
--Report 1
select Rank, Name, Board
from MyTable
sort by Rank, Name, Board
--Report 2
select Board, Name, Rank
from MyTable
sort by Board, Name, Rank
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.