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
lexical reference report
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
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
Who is online
Users browsing this forum: No registered users and 1 guest