I declare two variables in Parameter Form of Reports using Developer 2000, namely:
PF_1 and PF_2
i am using “emp” table of scott/tiger user.
in PF_1 I made a LOV on deptno and
in PF_2 I want to make a LOV that selects only those records from the emp table where deptno = :PF_1
Give me a solution. I already know that Bind variable cannot be included in where clause of lov’s at runtime.
shariqsaad@yahoo.com