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.

Antivirus vs Endpoint Protection: Understanding Key Differences for Business Security

Antivirus vs Endpoint Protection Introduction to Antivirus and Endpoint Protection In today’s digital landscape, cybersecurity is a ...