Using IsNull() in Reporting Services?

I can't seem to get the IsNull function to work from within Reporting Services.  Essentially I need to check a series of rows to see If a particular unique identifier is null and if it is, return a statement like 'this value is null'.

It returns that isnull is not declared.

Ideas?

500 points for a quick response!
aaron240Asked:
Who is Participating?
 
ABaruhConnect With a Mentor Commented:
Use:

IIF(IsNothing(Fields!MyField.Value),"Condition if true", "Condition if false")


The key is IsNothing
0
 
amit1978Commented:
You can use isnull in MS-SQL Server

select isnull(<FieldName>, 'this value is null') Table_Name

0
 
ABaruhCommented:
Were you able to test the IsNothing code yet?  
0
 
aaron240Author Commented:
Posted it on Friday, sorry didn't have a chance to test it over the weekend.  ABaruh your solution was perfect, thanks.
0
All Courses

From novice to tech pro — start learning today.