APEX

Hi All,

I have a 10 column report that must be displayed with a defualt sort order as 1 desc, 3 asc, 8 asc, 9 asc. I also need the ability for the user to sort the report on any of the 10 columns. How can I achieve this?


If I use ORDER BY in select query, I cannot allow the sort option (APEX does not allow me to).

If I give the sort option along with sort sequence, only the first time report is run, the default sort order I get. As soon as I click on any one column to be sorted in the front end, then next time I run the report it always sorts based on that column, instead of the default one.

Please let me know if I am doing anything wrong or how the above can be achieved? Any suggestions welcome..

Thanks,
Sumana