If Then Else in Report Builder 2.0 Expressions

Category: SQL Server Reporting Services
Hits: 46823
Rating:
( 398 Ratings )

Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly.  Anyway here's just a quick note on how to do if else statements in Report Builder 2.0

I'm looking at the following if statement:

copyraw 
If (MyFieldName = 0) Then
     Return 1
Else
     Return MyFieldName
  1.  If (MyFieldName = 0) Then 
  2.       Return 1 
  3.  Else 
  4.       Return MyFieldName 

Can be expressed as:

copyraw 
IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
  1.  IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value) 

Category: SQL Server Reporting Services :: Article: 583