This discussion is archived
0 Replies Latest reply: Oct 24, 2012 5:25 AM by 970389 RSS

Multi value select LOV in report builder 10g parameter form.

970389 Newbie
Currently Being Moderated
Hi All,

I have a requirement to show a set of records by getting user input through the report parameter form.

employee Table.
emp_id emp_name
---------- ------------------
1 A
2 B
3 C
4 D
5 E

In the report i am getting emp_id input from the user through list of values (LOV query is "select emp_id from employee where emp_id =:emp_id").
This condition is working for me. now user want to select multiple emp_id from the LOV. so that the sql query will get the related records from the employee table.
so the LOV query will work like the following "select emp_id from employee where emp_id in (:emp_id)".

can enybody help me to acheive the above.

Edited by: user13359272 on Oct 24, 2012 5:25 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points