How to use the IsNothing Inspection Function in SSRS

  • 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

  • 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

    The only thing worse than being an influencer
    is believing one.

  • 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"

  • 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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply