9 Replies Latest reply on Aug 24, 2012 12:48 PM by Krishna Vashistha

    How to implement Dynamic Sort to an SQL classic report?

    Krishna Vashistha

      I'm trying to implement dynamic sort to my working sql classic report, when user selects order by column from select item(action as submit page), the report should be refreshed and display with the selected column sort order.
      But not able to do so.

      Report Query:
      Select a, b, c from sample order by :P1_ORDER_BY

      P1_ORDER_BY - Select Item:
      STATIC2: Column 1;a, Column 2;b, Column 3;c

      Running page, report doesnt sorts in any of the column priority.

      Kindly guide.