Dynamics CRM 2011 – iif isNothing

2017-12-04T14:54:58+00:00 September 7th, 2012|CRM|0 Comments

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.

Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.