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
Define query studio?
What is Bitmap Index?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What is meant by alternate drill down with ex?
Can we test the report other than manual testing?
Give me any example of semi and non additive measures?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is the difference between ‘macro’ and ‘prompt?
Which lifecycle we will use for reporting?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What are the batches and it’s details?
What are all the types of report?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
------------------What is Inline Query?
What is defined as Cognos Impromptu?