Rdlc expression iif use

rdlc

In an rdlc report I want to compare integers like

if(expression)
{
     // do something
}
else if(expression)
{
     // do something else
}

What is the syntax for this?

Best Solution

Rather than using nested IIF statements I prefer the Switch statement.

From the MSDN...

=Switch(
    Fields!PctComplete.Value >= 10, "Green", 
    Fields!PctComplete.Value >= 1, "Blue", 
    Fields!PctComplete.Value = 1, "Yellow", 
    Fields!PctComplete.Value <= 0, "Red"
    )

Hope it helps :)

Related Question