Report Builder 3.0.
If my Address field = Location field, I don't want it to print, but I want it to print when Location doesn't match Address. I've tried this, but Location prints in all cases.
Any help to correct this would be appreciated:
=IIF(Fields!Address.Value=Fields!Location_Name.Value,""Fields!Location_Name.Value)
Just as a test, I checked the length on both and both lengths record the same number when they match, so I don't think there are extra spaces in the database.
If my Address field = Location field, I don't want it to print, but I want it to print when Location doesn't match Address. I've tried this, but Location prints in all cases.
Any help to correct this would be appreciated:
=IIF(Fields!Address.Value=Fields!Location_Name.Value,""Fields!Location_Name.Value)
Just as a test, I checked the length on both and both lengths record the same number when they match, so I don't think there are extra spaces in the database.