How to create a report with Dynamic order by clause

[raskotha]

I have report and one of the report parameter will be having the column name.

I am trying to use this value just like any other substitute variable P_DATE).

Select
col1,
col2,
sum(col3),
sum(col4)
from tab1
where cond1 = <>
group by col1
order by _FILTER_VALUE

Where the value of_FILTER_VALUE is 'col1'

When i execute the report the data is not in sort ( in this case data not sorted by col1)

FYI- Break Order property -> none.
Is this wrong? What should be done to make it happen

 

[sem]

You should use lexical rather than bind parameter:

Select 
col1,
col2,
sum(col3),
sum(col4)
from tab1
where cond1 = <>
group by col1
order by &P_FILTER_VALUE

Note that P_FILTER_VALUE Initial value must be valid order by clause

Regards, Dima

http://seminihin.narod.ru