| Oracle report builder dynamic LOV [message #192526] |
Tue, 12 September 2006 14:07  |
jmhc
Messages: 4
Registered: September 2006
Location: Dominican Republic
|
Junior Member |
|
|
Greetings:
I'm trying to create a dynamic list of values, which depends on the values of another field, here is the detail of my situation:
In my paper parameter form I have two parameter fields, the first one displays two values (manager and supervisor) and it is used for selecting the hierarchy level of employees, the second one is for select the employee by its name.
What I want to obtain is that when someone selects in the first field the manager value only appears in the second field the name of managers and when someone selects in the first field the supervisor value only appears in the second field the names of the supervisors.
I tried to use a lexical reference which i declared in the after parameter form trigger and then use it in the parameter list of values. Unfortunately I get error ORA-00933: SQL command not properly ended.
Can somebody help me with this.
Thank you.
[Updated on: Tue, 12 September 2006 14:12] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
