In Reports Use Lexical Parameter instead of Bind Parameter and write order by in After Param Form...
Here you find more details...
Hope this will solve your issue..
get the order by column from the user via user parameters.
In the data module editor edit the sql query and add the order by clause as follows:
select * from <table name> order by &user_parameter.
Hope this will help.