Select * from emp ;
in parameter form for i need to create a parameter so the user can select whatever the column order he required.
where is should write the order by clause
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.