This blog is about my history as a software engineer utilizing technologies C#, Java, React, JavaScript, .NET Core, SQL Server , Oracle, GIT, GitHub, Jira, Azure, AWS and HTML5. “I have not failed. I've just found 10,000 ways that won't work.” Thomas A. Edison. Please click on all my ADVERTISING links to help support this blog. 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