Value is not null in SSRS

HarperCheney 41 Reputation points
2020-09-08T04:14:35.227+00:00

Hi Everyone,

I tried to check whether the value of the text box is not null by using an expression. I used this expression: iif (Fields! days_overdue.value <> "", 1, 0), but it didn't work.

Does anyone have any information about this?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,107 questions
No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2020-09-08T05:32:19.393+00:00

    Hi @HarperCheney ,
    As your description,you want to check the the text box weather it is not null by using an expression. Maybe you could try the following:

    =IIF(IsNothing(Fields!days_overdue.Value), 1,0)  
    

    Hope this helps!
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

1 additional answer

Sort by: Most helpful
  1. Heba Kamal 1 Reputation point Microsoft MVP
    2021-10-08T09:49:08.29+00:00

    Checking null value is not the same as checking the empty value

    Check this link SSRS IIF NULL OR EMPTY

    No comments