Hi all, i 'm new to crystal report and here is a problem i faced. I was unable to use a parameter input(paraSort) for order by the different type to display. When i used normal 'order by user_gp' statement it work but when i use the statement like below it give a ORA-24374 error. Anyone know how to solve it or any other ways for user to select diff parameter for sorting? thks alot.

 

select * from profile where (sysdate - date_access)/30<6 and (del is null or del<>'Y') and user_gp ={?paraUser} order by {?paraSort}