Interested to Buy Any Domain ? << Click Here >> for more details...
suppose there are 15 countries like (US, UK,
ENGLAND,INDIA,JAPAN.......)i want a value prompt in the
report and this value prompt should contain groups like
group1(US,UK,ENG), group2(INDIA,US,UK), group3
(ENG,JAPAN,INDIA)and in the value prompt the values should
be group1,group2,group3 how can we do this?
- 4 Answers
- 7680 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhanu
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
u can add more static values if u want.
in report query put filter
write a if statement or case
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
case when ?country? =1
then query.country in (us,uk)
when ?country?=2
then query.country in(INDIA,srilanka)
end
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is hints in cognos and where we use it.
what is catalog and types of catalogs in cagnos and which is better?
------------------What is Inline Query?
is there any difference between operational database and data base?if yes what r they?
How can I schedule reports in cognos?
How to Reset Pagenumbers in one report.
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Can you define set to be cardinality?
what is model and say about process how to create model and how to test model?
What is called cognos reporting tool?
What are the advantages of using cognos sql?
What are the methods by which it non-durable model could be changed into the durable model?
Give me any example of semi and non additive measures?
What are query items?
