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
- 6790 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
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What is defined as catalog and types of catalogs in Cognos?
What is cognos powerhouse?
How can you link a query to a data container manually in Report Studio?
What is the complex report you faced in real time?
What are all the types of indexes in Cognos?
can you tell me what are the dimension tables are used in project
What are cognos connection initial page components?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
---------------Tell me about DWH Concepts?
What are the different uses of a repository manager?
What is a Transformer?
What are the types of security?
What is the model filter?
