If Then Else in Report Builder 2.0 Expressions

: Joel Lipman; SQL Server Reporting Services; 06 May 2010; Hits: 39810

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

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

SSRS: Performance Improvements: SELECT TOP (10150) Joel Lipman (SQL Server Reporting Services)
What? This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment....
Report Builder 2.0 - Hide Series1 (10045) Joel Lipman (SQL Server Reporting Services)
Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a...
Alternate row background colour in Reporting Services (13752) Joel Lipman (SQL Server Reporting Services)
This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it...
SSRS Templates in BIDS 2008 (8709) Joel Lipman (SQL Server Reporting Services)
Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with...
SSRS Expand specific drilldown by default (11019) Joel Lipman (SQL Server Reporting Services)
I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied &...
How to Display Report Execution Time in SSRS (milliseconds) (37234) Joel Lipman (SQL Server Reporting Services)
How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there...
SSRS Border Problem (8882) Joel Lipman (SQL Server Reporting Services)
What? A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time....