Link to home
Start Free TrialLog in
Avatar of sky_lt
sky_lt

asked on

Dynamic parameter value list in oracle reports

Hi,

I have two parameters in reports: "date" and "worker number".
At runtime, when i select date on parameter form i need
that the parameter's "worker number" list would be dynamic according to
the selected date(i should see anly those workers,
who worked on that date). Is it possible in reports?

It is smt like this:

SELECT worker_number
from WORKERS
WHERE :P_DATE between date1 and date2

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial