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?
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
Name the types of gateway?
What is model?
what do u mean by bridge group? where we r using this one?
What are the types of studio?
What do you understand by the cognos?
What is Metrics designer?
-----------------What is Determination Model?
What do you understand by the term 'model durability'?
what is requery in cognos?
which type of project we r going to snowflake schema
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What are the types of hierarchies?
tell me two or three issues from client side and how to solve those issues?
What are all the types of hierarchies?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.