I have to list 3 reports on a page, same data but sorted differently. I have to keep the results in the dataset so I want to sort them without having to export it to another control.
I have the following info:
Name, Value1, Value2, Value3
John, 5, 3, 2
Mike, 1, 5, 4
Peter, 3, 2, 6
Basically I want to reorder by Value1, then another time using Value2, and then a third time using Value3.
Right Now I just run 3 different SQL queries for each one just so I can re-order it.
...
Go to the complete details ...