How to chech Decimal is null?

[roomy]

I want to check decimal is null in text editor window.

[HighAley]

Hello.

Could you describe your issue more detailed with any sample?

Thank you.

[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);

[Alex K.]

Hello,

Please try to use the following expression:

Code: Select all

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

Thank you.

[roomy]

"DBNull.Value" Generate error in text editor.

[Alex K.]

Hello,

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

Thank you.