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.

Developer Productivity Metrics: An Informational Guide for US Business Leaders

Introduction to Developer Productivity Metrics In today’s technology-driven economy, software development teams play a critical role in t...