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
- If (MyFieldName = 0) Then
- Return 1
- Else
- Return MyFieldName
Can be expressed as:
copyraw
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