Dynamic Order By on Report Builder

select column_name from user_tab_columns where table_name = 'MYTABLE' 
and for p_direction a static LOV with ACS and DESC

In the after param form trigger do something like
:p_mysort := 'ORDER BY '||:p_col||' '||:p_direction

或是不用table控制
直接用if else控制:p_mysort的內容
The parameter p_mysort create manual in the Navigator and add him in the query like:
SELECT ....
....
&p_mysort