Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IIF statement issue

Status
Not open for further replies.

JetRamsey

Technical User
Oct 22, 2010
49
US
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.
 
Cancel Request. One address was in Uppercase and the other in Lowercase. Adding Ucase to both solved the issue.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top