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
- 7875 Views
- I also Faced
- E-Mail Answers
Answer Posted / balanandam
Abhay ur concept is write, but there is other way to implement this ....
using static choice property in the properties pan u can put the values like Group1, Group2....
and modify the default sql as
if query.country in (?parameter?='Group1')then (Country in ('','','')) else
else if.....then...
else if....then...
else query.country='parameter';
i think this will clear more
save report and run.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to Reset Pagenumbers in one report.
Can you explain dynamic query mode?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
tell me two or three issues from client side and how to solve those issues?
What is difference between data mart and data warehouse?
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 are the types of security?
What is main difference mapplets and mapping?
What is the function of model design accelerator?
What are the types of studio present in Cognos?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Can you define cognos impromptu?
Define datastores in cognos?
What is an olap designer?
Can you define set to be cardinality?
