Tuesday, November 27, 2007

SQL Reporting Services Expression

If you ever need to insert "data not available" or "n/a" use the following code.

=IIf(Fields!HoursAllocated.Value is nothing, "No Data Supplied", Fields!HoursAllocated.Value)

1 comment:

Anonymous said...

Thanks for posting this. I`ve been trying is null unsuccessfully and going mad.

AWS vs Azure vs Google Cloud Comparison

AWS vs Azure vs Google Cloud Comparison Introduction The cloud computing landscape in the United States has evolved into a critical c...