Re: Reports2.5...'Order by' as parameter???

GARY G 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

Hi,

just refer to the variable with & in the SQL expression, eg:

  select *
  from dual
  order by &p_order_by

Hope this helps.

Finn

-- 
--------------------------------------------------------------------------------
 Finn Ellebaek Nielsen                      Oracle Associated Senior Consultant
 E-mail:         ellebuk_at_vip.cybercity.dk   Ellebaek Consulting
 Mob. Phone:     +45 20 32 49 25            Niels Ebbesens Vej 9, 3. th.
 Mob. Phone SMS: 20324925_at_sms.tdm.dk        DK-1911  Frederiksberg C
 Private Phone:  +45 33 25 34 50            Denmark
--------------------------------------------------------------------------------
 "Life is a beach and then you dive"                      "Divers do it deeper"