Re: Reports2.5...'Order by' as parameter???
From: Simon Chan <iphk_at_vol.net>
Date: 1997/01/06
Message-ID: <32d062c9.5646303_at_news.vol.net>#1/1
Date: 1997/01/06
Message-ID: <32d062c9.5646303_at_news.vol.net>#1/1
On 4 Jan 1997 21:44:30 GMT, "GARY G" <tolimits_at_plantaganet.com> wrote:
>Hello, I attempted to make the Order by clause a bind variable, but didn't
>succeed.
>Does anyone know as on how to order items in reports based on user input?
>Ultimately I'd like to run a report from Form, and pass the 'order by'
>criteria to
>the report from that Form. Any suggestions on how to accomplish that task
>would be greatly appreciated.
>Thanks in advance,
>Gary
Just use a place holder (or a parameter variable) to hold the order by clause. Then reference the variable as :variable_name in your query statement of the query group in place of the order by clause.
SC Received on Mon Jan 06 1997 - 00:00:00 CET