Sunday January 21st 2018




Selecting Null when there is empty string

crystalreportsMany times we have a limited access to the data and views are created by IT departments and we have to select only the null or empty fields in Crystal Reports. I frequently came across this kind of issue and I tackled this by using isnull({Field})=True or {Field}=”” in the record selection formula editor.

Kaleem Mian
Senior Consultant SAP Crystal Reports