Post reply

Query regarding how to use ISNULL in ssrs

  • February 10, 2019 at 4:30 am

    #416682

    I want to display results based on case statement or ISNULL or coalesce

    my query looks something like this

    CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName 

    END AS FullName

    This can be done using ISNULL also  ISNULL(FirstName + ' ' + LastName,FirstName + ' ' + MiddleName + ' ' + LastName)

    We can achive this using coalesce

    how can achieve this in SSRS using expression. PLease guide me

  • February 10, 2019 at 5:12 pm

    #2021610

    Smash125 - Sunday, February 10, 2019 4:30 AM

    I want to display results based on case statement or ISNULL or coalesce

    my query looks something like this

    CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName 

    END AS FullName

    This can be done using ISNULL also  ISNULL(FirstName + ' ' + LastName,FirstName + ' ' + MiddleName + ' ' + LastName)

    We can achive this using coalesce

    how can achieve this in SSRS using expression. PLease guide me

    You can check for null with IsNothing so an expression along the lines of this would display the full name:
    =IIF(IsNothing(Fields!MiddleName.Value), Fields!FirstName.Value + " " + Fields!LastName.Value,
    Fields!FirstName.Value + " " + Fields!MiddleName.Value + " " + Fields!LastName.Value)

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

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