lexical reference report

[patelwork]

hello,

i have developed a report and want to give the sorting option to user
i wrote the following sql

select * from mytable
order by '&sort'

where the sort selected from the list thru parameter form
but there is no effect on the sorting...

please give me some idea . how can i do it !!
on single column or multiple columns

thank you

[patelwork]

yes!!! i have found some good example in the same site, tutorial section.

step one is write the query ..
select * from emp where abc=1 &sortby

set the parameter form for &sortby

write the trigger in ... after parameter form

thats gr8

thanks the forum admin

[quote]hello,

i have developed a report and want to give the sorting option to user
i wrote the following sql

select * from mytable
order by '&sort'

where the sort selected from the list thru parameter form
but there is no effect on the sorting...

please give me some idea . how can i do it !!
on single column or multiple columns

thank you


<i><div align="right">Originally posted by patelwork