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.