>>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.

Hi,

Thanks for the reply. But it didn't work for me. I have defined a property myVar. Then I used
SELECt blah blah ORDER BY &thisform.myvar. It didn.t work.

_pageno system variable gets released immediately after the REPORT command is commpleted. How can I
save it for the next actual print

TIA.

alex