system
March 12, 2009, 9:07am
#1
I have one object Country, in reports there is a multi selection prompt for Country. User can select more then one country. I want to provide a value in LOV’s called ‘ALL’. so that whenever he want to select all countrynames he just need to select only ALL option. Is this possible, pls provide inputs.
Regards,
Rakesh K
Rakesh_K (BOB member since 2007-12-11)
system
March 12, 2009, 9:20am
#2
Check this Designer FAQ .
Jansi (BOB member since 2008-05-12)
system
March 19, 2009, 10:27am
#3
I went through FAQ and followed the steps.
below is my query for country
SELECT DISTINCT
RK_COUNTRY.COUNTRY
FROM
RK_COUNTRY
UNION
SELECT
‘ALL’
FROM
DUAL
i added select ‘ALL’ from dual.
now ALL option is showing in prompt but when I am selecting this option, report doesn’t show any data. It says no data to fetch.
Can you please provide some more inputs.
Rakesh_K (BOB member since 2007-12-11)
system
March 19, 2009, 10:37am
#4
Just adding All keyword to the LOV is not enough
You will have to create a predefined condition, do a search with keywords ‘All in LOV’ for the syntax
.
haider (BOB member since 2005-07-18)
system
March 19, 2009, 10:44am
#5
I tried to search on the basis on ‘ALL in LOV’, but couldn’t find a post.
can you please share the search syntax to achieve the ALL option in LOV.
Rakesh_K (BOB member since 2007-12-11)
system
March 19, 2009, 10:47am
#6
Hyder(haider) gave a solution here . Check it out.
Jansi (BOB member since 2008-05-12)
system
March 19, 2009, 11:19am
#7
Thanks its working now.
Rakesh_K (BOB member since 2007-12-11)