how can you create a report like if country=india then true
if contry=spain then false?
Answers were Sorted based on User's Feedback
Answer / arkchowdary
Actually your question is not clear.
2 ways we can do which you asked why bcz --------- If u
want to do on same Column then u can use Conditional
formatting
Another One------------ If you want to do display result on
new column take new Query Calculation.
-------------- With the help of New query calculation we
can do this Report.
Ex------------ In Query Defnition you need to give
condition like this-------------- If Country='INDIA'
then 'TRUE
else If country='SPAIN' then "FALSE'
Another One is --------------- Through Conditional
Formatting we will do this Report.
Ex---------------- Use Boolean Variable we will do
If Condition is True then select Yes.
If condiotion is False then select No.
I Hope Clear.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / thanjairajan@gmail.com
1.Go to Report Studio
2.Select list container
3.Drag query item to the list container. i.e for example we take country,staff name,revenue query item from source tab
4.Drag query calculation from tool box tab to right side of the container.
5.In the box give new query item name. in this example Result is new query item name.
5.Expression definition window will show. in that we type like this.
case
when [country]='India'
then 'True'
when [country]='Spain'
then 'False'
end
6.Then run the report. u will see new column is result. in that true value will display equivalent of India country and false value will display equivalent of Spain country.
Is This Answer Correct ? | 1 Yes | 0 No |
---------------How to identify First Record and Last Record?
what is symmetric key?where do u use this?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
How to create a Ratio in Cognos Report studio Reports?
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
What is Portal Tab?
Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?
if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............
How do we create Links & Segments in Cognos Framework Manager?
Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code
If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com