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.

Best Coding Practices Every Developer Should Follow

Introduction In the dynamic landscape of software development, adhering to best coding practices is essential for producing reliable, mai...