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 |
What is Index?
fiscal year means what???
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
What is meant by alternate drill down with ex?
what is the difference between enterprise data warehouse and data warehouse
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
----------------What is Scopr Relationship?
What do you mean by drill through report?
What is the use of report studio?
How to publish a package by running Java Script?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
What is Lookup ,bridgeing tables where they will use in the Dataware house