Hi all i know this is very common question i am asking but i did n’t get the way to solve to show optional all in lov
say i have an objects having list of values like A and S in report flter in the list there should be BOTH to show all data for A and S how to do it universe please anybody tell me the proper way of implimentation
ssbo (BOB member since 2012-03-26)
Hope this link helps !!
Looks like you are looking to include ALL in the LOV
RUC 
(BOB member since 2010-05-03)
See there posts in the Designer FAQ:
How can I prompt for select one, many, or all values?
How can I see ‘ALL’ in my list of values?
MichaelWelter 
(BOB member since 2002-08-08)
hi i have tried following syntax as condition but uts not working
CHART_FORMAT.CHART_TYPE = @Prompt(’
Chart Type:’, ‘A’,‘Chart type\Chart Type’ , mono, free, not_persistent,{‘All’}) or ‘ALL’ = @Prompt(’
Chart Type:’, ‘A’,‘Chart type\Chart Type’ , mono, free, not_persistent,{‘All’})
as if i use as condition here i sould take values from list but i want show it ottional
and if i remove all from list it become mandatory filter and not showing ALL in list
my requirement is in lov of CHART_FORMAT.CHART_TYPE is A ,S
if i select A then A If Select S thenS it ok but If i selct ALL it should select Both A and S Can anybody please help on this
i am new on this logic
ssbo (BOB member since 2012-03-26)
Edit Chart type\Chart Type object and modify it’s SQL and add below code.
Union ALL
select 'All' from dual.Rakesh_K 
(BOB member since 2007-12-11)