question

HarperCheney-6396 avatar image
0 Votes"
HarperCheney-6396 asked HebaKamal-1648 answered

Value is not null in SSRS

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @HarperCheney-6396 ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HebaKamal-1648 avatar image
0 Votes"
HebaKamal-1648 answered

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

Check this link SSRS IIF NULL OR EMPTY


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.