February 12, 2015 at 12:01 am
Comments posted to this topic are about the item How to use the IsNothing Inspection Function in SSRS
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 12, 2015 at 6:35 am
Is there any difference between this and the SQL function ISNULL? For simplicity and to avoid 'mindclutter' why would we not call it the same? I'm just thinkin'...
Rick
One of the best days of my IT career was the day I told my boss if the problem was so simple he should go fix it himself.
February 12, 2015 at 8:01 am
skeleton567 (2/12/2015)
Is there any difference between this and the SQL function ISNULL? For simplicity and to avoid 'mindclutter' why would we not call it the same? I'm just thinkin'...
SSRS deals with NULL via the IsNothing this is VB-sentric as SSRS is VB-based rather than SQL based when it comes to the underlying code.
So, saying IIF(IsNothing(Fields.MyField.Value),"1","0") would be the same as:
-- SQL
IF (Fields.MyField.Value IS NULL)
SET @X = "1"
ELSE
SET @X = "2"
February 12, 2015 at 10:44 am
A very simple but effective way to add to the end user's experience when using the report. Nicely done.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply