If Then Else in Report Builder 2.0 Expressions

: Category: SQL Server Reporting Services; 06 May 2010; Hits: 42919

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:

copy raw

If (MyFieldName = 0) Then
     Return 1
Else
     Return MyFieldName

If (MyFieldName = 0) Then
Return 1
Else
Return MyFieldName

Can be expressed as:

copy raw

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

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

Category: SQL Server Reporting Services :: Article: 261

Add comment

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com