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.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.