This blog shares my journey as a software engineer, along with personal reviews and life experiences I’ve gained along the way. “I have not failed. I've just found 10,000 ways that won't work.” — Thomas Edison. If you enjoy my content, please support it by clicking on ads (free for you, big help for me!) or by buying me a coffee on Ko-fi. Thank you!
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.
1 comment:
Thanks for posting this. I`ve been trying is null unsuccessfully and going mad.
Post a Comment