[reporting-services] SSRS Expression for IF, THEN ELSE

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

This question is related to reporting-services expression ssrs-expression shoretel

The answer is

You should be able to use

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

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

Source: Stackoverflow.com

Examples related to reporting-services

• How to use multiple conditions (With AND) in IIF expressions in ssrs • Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0 • Line break in SSRS expression • SSRS expression to format two decimal places does not show zeros • SSRS Expression for IF, THEN ELSE • SSRS Conditional Formatting Switch or IIF • SQL variable to hold list of integers • Could not load file or assembly 'Microsoft.ReportViewer.WebForms' • How do I format date and time on ssrs report? • How do I display todays date on SSRS report?

Examples related to expression

• How do I remove all non-ASCII characters with regex and Notepad++? • SSRS Expression for IF, THEN ELSE • Regex to get the words after matching string • Regular expression to match a word or its prefix • SSIS expression: convert date to string • Are complex expressions possible in ng-hide / ng-show? • Change some value inside the List<T> • XPath - Difference between node() and text() • javascript - match string against the array of regular expressions • Spring cron expression for every after 30 minutes

Examples related to ssrs-expression

• SSRS Expression for IF, THEN ELSE • SSRS Field Expression to change the background color of the Cell • Reporting Services Remove Time from DateTime in Expression

Examples related to shoretel

• SSRS Expression for IF, THEN ELSE