Home » Developer & Programmer » Reports & Discoverer » list of values
list of values [message #88183] Fri, 26 April 2002 11:31 Go to next message
Angie
Messages: 12
Registered: April 2002
Junior Member
Is there a way to create a LOV where the user can select one item from the list or all items. I have created the list of items with the "ALL" selection but I don't know how to change my code to accomodate the user's selection of "ALL".
Re: list of values [message #88187 is a reply to message #88183] Sun, 28 April 2002 20:49 Go to previous message
Suraj
Messages: 38
Registered: April 2002
Member
Hii Angie.

What u can do is , u can use the following query in the parameter query :-

select '%','All' from dual
union
select empno,ename from emp;
In the DataModel use the keyword ' like ' while using the above parameter.
Hope this solves ur problem
Bye..
SURAJ
Previous Topic: Rep:0118 Unable to create temporary file! ---URGENT
Next Topic: picture
Goto Forum:
  


Current Time: Sun Jan 16 21:24:31 CST 2022