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
- 8029 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
Explain what is the main advantage of impromptu over cognos reportnet?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is the difference between a cascading report and drill through the report?
What is Bitmap Index?
what are the names of the reports that you prepared?
What is the size of the cube?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the types of catalogs in cognos?
What is drill down and slicing and dicing whats the difference between them?
hi friends pls forward impropmtu interview question
what is hints in cognos and where we use it.
What are cognos connection initial page components?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
Can you explain dynamic query mode?
What are the different types of reports present in cognos?
