Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 10034 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
What are the components of report net?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is meant by Reportstudio shortcut?
What is the difference between ‘macro’ and ‘prompt?
Can you define cognos impromptu?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What are all the types of hierarchies?
What is a Cube?
Can you define drill down and drill up?
-----------Diff b/w OLAP and RDBMS?
Can you define slice?
What are the types of studio present in Cognos?
What is Online View?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
