Ordering the column first takes place from the Data Model Itself.
Please Check your column ordering in the report data model. If it is not ordered in a right way then Rearrange it.
Remove your order by in query...
If any issues... let me know
i want give order by column preference to my client whatever the column they required.if i remove order by how we can order based on the parameter the client selected.
Give initial value for your parameter p_col by opening property of p_col parameter.
Then change the orderby clause as
ORDER BY &P_COL
I think its helpful to you.