multi-level sorting question
Does anyone know how to do a dynamic multi-level sorting in CR XI R1? Say I have 4 columns on my report A, B, C, D, and the report should be able to be sorted according to the prompted field a user to select. If A is selected, then it should be sorted on the order of A-BCD; if B selected, then the order should be B-ACD; if C selected, then C-ABD; if D selected, then D-ABC.
Or as an alternative, is it possible to allow users to define their own sorting orders? Say user can define the report to be sorte on B-D-A-C.