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
- 5898 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is dtm?
What are various types of gateways in cognos?
What are the types of security?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is meant by alternate drill down with ex?
What is the difference between Standard and Metrics folder?
What are the steps to import the two data sources in framework manager?
how you migrate reports to cognos 8 from previous versions?
What are all the types of report?
is there any difference between operational database and data base?if yes what r they?
How can you link a query to a data container manually in Report Studio?
What is the importance of having monitor service in cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
Please explain the different stages in creating a report in cognos report net?
What is catalog and types of catalogs in cagonos and which is better?
