Order By in Query needs to reference parameter form item

[MrPhreaker]

Hi All

I have a report which runs

select x,y,z from b
order by aram

aram is a user parameter that is determined from the parameter form.

However, when i run the report, the order by clause is ignored. Can anyone help ?

 

[sem]

You should use lexical parameter insted of bind variable: select x,y,z from border by &param

Don'tforget to provide valid default value for param.


Regards, Dima

 

[MrPhreaker]

nevermind, got it working by using a decode in the order by part of the clause.....