如何让SSRS中的IIF与AND组合语句正常生效？

架构老林

2026-5-28

Troubleshooting Your SSRS IIF Statement with AND Condition

Hey there! Let's work through why your IIF statement isn't behaving as expected. I've got a few common fixes and checks to help you out:

Common Issues & Adjustments

Boolean Literal Case: SSRS uses VB.NET-style expressions, where boolean values are standard lowercase true/false (all caps TRUE can cause unexpected behavior in some environments). Here's the adjusted version with proper case:
```
=IIF(Fields!Requirement_Description.Value = "4. Transport Req. Mon PM" AND Fields!Transport_Requirement_Y_N.Value = true, "Yes", "No")
```
Hidden Whitespace in String Values: It's super common for field values to have invisible leading/trailing spaces that break exact string matches. Wrap your description field in a Trim() function to eliminate extra spaces:
```
=IIF(Trim(Fields!Requirement_Description.Value) = "4. Transport Req. Mon PM" AND Fields!Transport_Requirement_Y_N.Value = true, "Yes", "No")
```
Mismatched Data Types: Double-check the data type of Transport_Requirement_Y_N. If it's stored as a string (e.g., "True"/"False" or "Y"/"N") instead of a boolean, you'll need to compare against the string value:
For example, if the field uses "True" as a string:
```
=IIF(Fields!Requirement_Description.Value = "4. Transport Req. Mon PM" AND Fields!Transport_Requirement_Y_N.Value = "True", "Yes", "No")
```

Quick Debugging Trick

If you're still stuck, add temporary text boxes to your report to output the raw values of these fields. This lets you confirm exactly what's being evaluated: