How to use the IsNothing Inspection Function in SSRS

  • Shawn Melton

    SSC-Insane

    Points: 24675

    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

  • skeleton567

    SSCertifiable

    Points: 5047

    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.

  • danielk1

    SSC-Addicted

    Points: 462

    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"

  • rick.medlin

    SSC Rookie

    Points: 32

    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