paul.j.kemna (8/4/2014)
I guess i will play it safe and change these to IS Nothing rather than = Nothing, even though it appears to work.I also occasionally use LEN(Fields!FieldName.Value) > 0) in expressions to check for truly blank (NULL) fields. Are there any pitfalls to this method?
PK
Keep in mind that LEN() ignores trailing spaces, and the length of NULL is NULL.
len(null) is null
len('') = 0
len(' ') = 0
len('x ') = 1
You may want to use one of the techniques listed here. Perhaps use ISNULL() or COALESCE() to convert NULL to empty string '' within SELECT statement.
http://stackoverflow.com/questions/835954/sql-2005-reporting-services-if-check-for-null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho