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
- 7874 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhay puranik
Create a query,drag the Country column,Drag data item from
the tool,name this as Group,Now in the expression
corresponding to this data item,write if(geography contains
('','','') then 'Group1' elseif(Country contains('','',''))
then 'Group2'......And use this query for the query
property of value prompt and use Group as column diplayed
under value prompt.Now,in filter for the main page use if
(Group='Group1') then (Country in ('','','')) else
if.....save report and run.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the methods by which it non-durable model could be changed into the durable model?
Tell me about Dnamic and Static Dashboards?
------------ Diff b/w MemberCaption and MemberDescription?
WHAT ARE THE DISTNICT VARIABLES?
How do you call a store procedure within a transformation?
5. Which type of report you build more, list, crosstab or chart and why?
Define datastores in cognos?
What do you mean by drill through report?
What are the considerations regarding performance kept in mind while setting up cognos?
What is the function of cognos dispatcher?
What are the different types of important services used in cognos?
How do you Parametermap variables in Quiries?
Explain is there any comparison available for cognos reportnet vs crystal reports?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Can you define materialized view?
