Parameter LOV in Reports 6.0

[RafaelCintron]

can a parameter LOV reference a previous parameter? If not how can i do something like this?

select desc
from table
where cod = :x

where x is a previous parameter.

 

[comps]

hi

what do u mean by previous parameter????

 

[RafaelCintron]

Imagine this situation:
You have a parameter form which asks you for an employee code, then it asks you for a date. The date depends on the code previously entered. The list of values for the date field should be something like this :

select mydate
from mytable
where code = :empCode

How can I accomplish this?

 

[sem]

You may develop a simple form in Forms and call your report from it. Parameter LOV does not accept bind variables