Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN

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 / gajendra kumar

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

i have one file i saved in csv how can i take these file into framework manager

2072

Please explain the different stages in creating a report in cognos report net?

995

hi my name is siraj i want to know cognos queriy language

2261

Name the types of gateway?

997

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2004

What are the advantages of cognos?

969

What are all the advantages of Cognos?

1025

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

994

What is the difference between static and dynamic conditions?

1063

What is the complex report you faced in real time?

2164

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1051

What are cognos connection initial page components?

1117

i was asked what are the caluclations done by you in your report? plz give reply

2177

What are the types of security?

1012

What is set to be Cognos configuration?

1012