how can you create a report like if country=india then true if contry=spain the

how can you create a report like if country=india then true
if contry=spain then false?

Question Posted / sekhar

2 Answers
5897 Views
Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can you create a report like if country=india then true if contry=spain then false?..

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

how can you create a report like if country=india then true if contry=spain then false?..

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

Post New Answer