Check for NULL values
1 2 |
=IIf(Fields!YourColumn.Value, Fields!YourColumn.Value, "Unknown") =IIf(Fields!YourColumn.Value > 0, Fields!YourColumn.Value, "Unknown") |
Check string contains substring
1 2 |
=IIf(Fields!Notes.Value.IndexOf("sample") >= 0,"Black","White") =IIf(Fields!Notes.Value.ToLowerInvariant().Contains("sample"),"Black","White") |