Dynamics CRM 2011 – iif isNothing

Imagine this scenario if you will: You are developing a Dynamics CRM 2011 report using Business Intelligence Development Studio, based on the Account entity. You have modified the account entity to have a secondary contact lookup.

In your report, you don’t want to hide the columns if no data appears to keep formatting; but you don’t want to leave any text visible if there’s no data

(not showing:  “Name :” + new_secondarycontactid.Value)

Here’s how:

=iif(isNothing(Fields!new_secondarycontactid.Value), “Field contains no data”, “Name:  ” + Fields!new_fullname.Value)

Cheers,

Jason.

About the author