If Then Else in Report Builder 2.0 Expressions

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

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: The information on this website is provided without warranty and any content is merely the opinion of the author. Please try to test in development environments prior to adapting them to your production environments. The articles are written in good faith and, at the time of print, are working examples used 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

Before and After, Highs and Lows (5794) Joel Lipman (SQL Server Reporting Services)
So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP &...
SSRS Querying on either of 2 Parameters (13445) Joel Lipman (SQL Server Reporting Services)
The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008...
Change Regional Settings for your Report (18869) Joel Lipman (SQL Server Reporting Services)
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008...
Border settings not saving in SSRS (18033) Joel Lipman (SQL Server Reporting Services)
This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My...
SSRS: Performance Improvements: SELECT TOP (7647) 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....
Returning Oracle Stored Procedure Resultset in SSRS (30383) Joel Lipman (SQL Server Reporting Services)
What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a...
SSRS Subscriptions cannot be created (7278) Joel Lipman (SQL Server Reporting Services)
Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article...

Joes Revolver Map

Accreditation

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:

Bitcoin:

3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb

If Then Else in Report Builder 2.0 Expressions

Credit where Credit is Due:

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Donate & Support