i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt

i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's prompt control list, i want
WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country
names.
When i click on WESTERN_COUNTRIES, it should retrieve USA,
UK records and when i click on ASIAN_COUNTRIES, it should
retrieve INDIA, CHINA records.
How is it possible?

Question Posted / kranthi

4 Answers
8500 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / itesh

simple man ,
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)

in report query put filter

write a if statement
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)

cheers

Is This Answer Correct ?

9 Yes

3 No

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / gajendra kumar

Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN_COUNTRIES. In report query add the filter (?parameter? = 'WESTERN_COUNTRIES' and [Dataitem] in ('USA', 'UK'))
or
(?parameter? = 'ASIAN_COUNTRIES' and [Dataitem] in ('INDIA', 'CHINA'))

Is This Answer Correct ?

2 Yes

0 No

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / beckham

Use a customized data item in a query.this query is the
source query for the region prompt.Make sure the customized
data item is used in main query and filterd accordingly.

Is This Answer Correct ?

4 Yes

5 No

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / vishnu

Use Cascading Prompt

Is This Answer Correct ?

2 Yes

9 No

Post New Answer