You can do it using DeskI. You have to create different tables (data blocks) one for each of your options. In the first block apply sort on store column, in the second apply the sort on manager column and …
Hide these blocks based on the UserResponse(). Check the following link:
How to show and hide reports based on user selection.
BO_Chief (BOB member since 2004-06-06)