Discussion Locked

Parameters in Reports - Developer2000

0 helpful

2 replies

by shariqsaad Nov 22, 2001 last reply Dec 4, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

hay man, y dont u use a Drop down list instead of LOV??? u can use Add_element at run-time , wo u can load it with a cursor or something.

Hey man can u let me know how to do this thing that u have suggested.

This discussion is closed to new replies.