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 )
you could just show the customer contact in the field and create a WHERE clause in your data set query to only select rows with “Site Contact” as the contact title.
If this is a BAQ Report then you could put that criteria on the BAQ.
Adding the WHERE clause in the data set query works well if there is a site contact entered. The problem is, if we don’t enter a site contact then the whole invoice is blank. I just want to Site contact field to be blank if there is nothing.
is the customer contact table linked via a Left Outer Join? If its an inner join then it will blank out the report if none is there. So it sounds like you need have the link to customer contact a left outer join.
Okay, your first formula you posted, why did that seem not to work? Was it always blank? maybe use single quotes instead of double around your strings.
another suggestion might be if you take the where clause out then just put the customer contact name in the textbox and put a suppression formula on the textbox that is looking at the Contact title, suppressing the box if it.