Cascading Issue

[caravapally]

Hi Everyone,

I have two drop down value prompts (example: Country, state).

I have 20 countries,
for each country --> 10, 20,...states also there.

when I select a country (India) i am getting related states (AP,MH, MP, DL,KA,.....)
by using cascading prompt

if I select USA (getting USA related states)

But I have other than these sates (means more than 20 countries data).

countries are 20 but states are extra data (more than 20 couturiers).

My requirement is:
when I select ALL COUNTRIES (provided static choices for first prompt)
for first prompt then other extra states should be displayed in second prompt default (I used cascading prompt).

how can i resolve this issue.

Thanks

[Anand]

update the country column as
case
when(counrty is null or missing)
then('Others')
else(country)
end

and use the same column for reporting

[Gopinath]

Change the filter condition in your cascade query (The query which retrives State information in ur case) as below

[country] = ?country? OR ?country? = 'All Countries'  (Assuming u have 'All Countries' as the Static choice in your country prompt)