Interested to Buy Any Domain ? << Click Here >> for more details...
how can you create a report like if country=india then true
if contry=spain then false?
- 2 Answers
- 6156 Views
- Syntel, I also Faced
- E-Mail Answers
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 |
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
Define cognos report net?
What are the two types of framework manager?
what is hints in cognos and where we use it.
How to create a cube in Transformer? What is the process? Please mention process thank u
whats the difference between previous version of cognos and cognos 8 BI?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Define the cognos reporting tool?
explain how to create powerplay reports?
When we use consume in cognos?
Teradata 
