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)
at

1 comment:

Anonymous said...

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

1:27 PM

Post a Comment

Subscribe to: Post Comments (Atom)

C# vs Java: Which Should You Choose?

Introduction When deciding between C# and Java for software development, business decision-makers in the US often face a complex choice. ...