Check of DB.NULL is Formula Editor.

[imranIBM]

Hi,

I am unable to check DB.Null value from Formula Editor in Crystal reports .Net. If the column value is NULL then display "Some text" else "Column Value".

Database is SQLServer 2000.

Thanks
Imran

 

[TechGnome]

use IsNull() ....
If IsNull(reportfield) Then
'I'm NULL!'
Else
'I'm NOT null'

-tg

 

[imranIBM]

Thank you.

Thank you very much. It worked.

I was checking for "Is Nothing".