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
update the country column as
case
when(counrty is null or missing)
then('Others')
else(country)
end
and use the same column for reporting
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)