Re: Restricted LOV in reports 2.5

From: Gaetan Poitras <gpoitras_at_colt.vpi.hydro.qc.ca>
Date: Wed, 12 Jan 2000 18:33:40 GMT
Message-ID: <387CC8C4.C830A11_at_colt.vpi.hydro.qc.ca>

You just cannot refer to the previous parameter because all Select statement in report
are analyse just before the parameter screen is show.. ...!!

That's why you cannot do that..
 

Mitja wrote:

Oracle Reports 2.5

I have two user parameters with LOV defined with select statement
and I wish to restrict LOV2 with item, that user has selected in LOV1

-----------
LOV 1        parameter: p_a      select statement: (select t1.a from t1)
-----------

-----------
LOV 2        parameter: p_b      select statement: (select t2.c from t2
where t2.x=:p_a)
-----------

I  see this error:  REP-0781: Bind variables are not allowed in the
Select statement.

Please help, how can I do this in reports.

Thanks a lot!

-- 
- Gaetan Poitras --  Tel.: 858-8500 p. 7880 -
- E-Mail:  gpoitras_at_colt.vpi.hydro.qc.ca -

  Received on Wed Jan 12 2000 - 19:33:40 CET