Page 1 of 1

How to chech Decimal is null?

Posted: Mon Sep 09, 2013 4:41 am
by roomy
I want to check decimal is null in text editor window.

Re: How to chech Decimal is null?

Posted: Mon Sep 09, 2013 5:25 am
by HighAley
Hello.

Could you describe your issue more detailed with any sample?

Thank you.

Re: How to chech Decimal is null?

Posted: Mon Sep 09, 2013 9:00 am
by roomy
Yes , I have a column in datasource type Decimal(nullable) and try to check null with IIF like;

IIF(datasource.column1 == null, "N/A",datasource.column1);

Re: How to chech Decimal is null?

Posted: Mon Sep 09, 2013 9:07 am
by Alex K.
Hello,

Please try to use the following expression:

Code: Select all

IIF(datasource["column1"] == DBNull.Value, "N/A",datasource.column1);
Thank you.

Re: How to chech Decimal is null?

Posted: Thu Sep 12, 2013 4:55 am
by roomy
"DBNull.Value" Generate error in text editor.

Re: How to chech Decimal is null?

Posted: Thu Sep 12, 2013 6:06 am
by Alex K.
Hello,

Please send us a sample report which reproduce the issue for analysis.

Thank you.