BusinessObjects Board

providing ALL option in Prompt

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 :india: (BOB member since 2007-12-11)

Check this Designer FAQ.


Jansi :india: (BOB member since 2008-05-12)

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 :india: (BOB member since 2007-12-11)

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 :es: (BOB member since 2005-07-18)

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 :india: (BOB member since 2007-12-11)

Hyder(haider) gave a solution here. Check it out.


Jansi :india: (BOB member since 2008-05-12)

Thanks its working now.


Rakesh_K :india: (BOB member since 2007-12-11)