i am having prompt on supplier name and i am giving inlist so user will select multiple values but if user want to select all suppliers then he has to selectct allnames one by one so can i add “ALL” in list so that if he select “ALL” then report will show all supplier’s data
please let me know
Thanks
Nilesh
nileshpatilBO (BOB member since 2005-12-16)
Do a search on BOB for “ALL LOV”. I think you’ll find help.
In short, you need to customize the LOV so that it includes a UNION query.
Steve Krandel 
(BOB member since 2002-06-25)
Hi Nilesh,
You can use @Prompt(’’,’’,’’,)OR ‘All’ IN @Prompt( ) So if user select some values then it will filter on that values only on typing All it will take all values in this this we don’t need to change LOV, but ti is applicable for text column only 
Prajas 
(BOB member since 2005-09-12)
I would love to know if you get this working. I still can’t get the 2nd half of the OR to parse…
datagal (BOB member since 2005-12-21)
https://bobj-board.org/t/15227/9
the above link should help you.
BO_Chief (BOB member since 2004-06-06)