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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.