BusinessObjects Board

Hai i want to select all values from aprompt instead

building reports webintelligence legacy
#1

Hai i want to select all values from a prompt instead of selecting a single value from the prompt

i hav the countires object which has some 20 country names so when i give this country name in a prompt then i can only select only one country what u want is i want to select all countries for this created a object called all and its comming in the objects lov but when i select that all in the prompt it 's saying that there is no data to fetch can any one solve this issue

SELECT DISTINCT COUNTRY_ID
FROM HR.COUNTRIES
UNION
SELECT ‘ALL’ COUNTRY_ID FROM DUAL;

is this correct or if any modifications then solve this

Thanks in Advance

swakuma (BOB member since 2007-06-27)

#2

Just adding ‘ALL’ to the LOV is not enough to run the report
Do a Search on BOB with keywords: ALL in LOV

Cheers

haider :es: (BOB member since 2005-07-18)

#3

Or have a look at Designer FAQ. First 2 inputs are about ALL in LOV.

Marek Chladny :slovakia: (BOB member since 2003-11-27)