This discussion is archived
9 Replies Latest reply: Aug 24, 2012 5:48 AM by Krishna Vashistha RSS

How to implement Dynamic Sort to an SQL classic report?

Krishna Vashistha Newbie
Currently Being Moderated
Hi,

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.

Regards,
Krishna

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points