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
How to publish a package by running Java Script?
what is the role of cognos comsultant?what actually it means?pls reply
What are cognos connection initial page components?
is cognos 7 is better than cognos 8
How is cognos model organization works?
Cleared COG-112 with 100% score today. What next certification should i go for?
What are the message flows?
Name the types of gateway?
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
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
How can I schedule reports in cognos?
What are shortcuts? Where it can be used? What are the advantages?
what is the difference between native sql and cognos sql?
Mention the difference between ‘macros’ and ‘prompt’?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?