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.