I’m trying to show only the ‘Site Contact’ information in the SSRS report but I’m not sure how to get it to work. We have several contacts for one customer and all I want to show in the report is the Site Contact Name and number.
This is what I have, but it doesn’t seem to be work.
=iif(Fields!CustCnt_ContactTitle.Value=“Site Contact”,"Site Contact: " & Fields!CustCnt_Name.Value , Nothing )
I’m not sure what I’m doing wrong.