Value is not null in SSRS

Question

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?

Answer 1

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.

Answer 2

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

Check this link SSRS IIF NULL OR EMPTY