SSRS Expression for IF, THEN ELSE

Question

I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression.

=if(Fields!ExitReason.Value 7,
then if (Fields!ExitReason.Value 1,
else if (Fields!ExitReason.Value 0,)))

Definition results should be:

=if(Fields!ExitReason.Value) = 7 then 1 else 0

I am try to get the field to give me 7, 1 else 0. Any assistance would be great.

Thanks, Arron

Solution

You should be able to use

IIF(Fields!ExitReason.Value = 7, 1, 0)

http://msdn.microsoft.com/en-us/library/ms157328.aspx

Comments

[LCJ]

Take a look at stackoverflow.com/questions/3551966/…

[Arron Robles]

Thank you Steve. This was very helpful and resolved my issue.

[asela daskon]

I have a field called ta_amount. if the value inside this filed is >100 then it's should be divided by 100 otherwise display "no pound". but my expression gives me a error. =IIf((Fields!ta_amount.Value > 100), ([(Fields!ta_amount.Value)/100]), "No Pound")

[PedroC88]

I know this is old but the answer to @aselanuwan comment is found in this other SO question stackoverflow.com/questions/37283287/…. In summary, IIF doesn't short-circuit, meaning it always evaluates both sides, regardless of the result.