SSRS Expression for IF, THEN ELSE

reporting-services expression ssrs-expression shoretel
Arron Robles picture Arron Robles · Dec 4, 2013 · Viewed 137.5k times · Source

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

Answer

Steve Salowitz picture Steve Salowitz · Dec 4, 2013

You should be able to use

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

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

Related questions

Reporting Services Remove Time from DateTime in Expression

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Read More
Using 'like' in ssrs expressions

I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the expression: =IIf(Fields!Notes.Value like "%deadline%","Yellow","Transparent") in the BackgroundColor property. It's not highlighting the field (not changing …

Read More
Count expression SSRS Report

Trying to count all rows in a column where column=Yes I have two columns in my report Accepted and rejected. I'm trying to count the rows where accepted=Yes and do the say thing for rejected. I've tried these: =…

Read More