>Hi,
>
>I have the following problem. How can I give a variable value for the order by clause of the select
>statement
> eg: Select * from aaa into cursor ab order by (mvar)
>
>so that I can change the value of mvar as required.
>
>2. Sometime back I saw in this forum to use REPORT FOR myreport NO CONSOLE to get the
>page no. But how can I store the page no. in a variable to be used in the actual printing of the
>report. I mean without releasing the last page no.
>
>thanks
>
>alex


1. SELECT blah FROM blahblah ORDER BY &Var.

2. Look at the _PAGENO system variable.