Re: Oracle Reports: Sort Order and suppressing duplicate values

User ORA-LEARNER wrote:

> Hi
> In Query Section, I have a query that displays the values selected by
> the user on Parameter form.
>
> select decode(PARAM_NAME, 'Z',1,'X',2,'R',3,'D',1,'M',4,'T',5,6)
> Sort_order, param_name,value from tableA
> order by 1

Instead of decoding parameter to numbers, you should decode it as column names.

select
  decode(param_name, 'Z', <sort_column1>, 'X',.....,<sort_column_default>   order by 1;

Your example just sorts nothing.

-- 
Noel