Wednesday August 16th 2017

Categories

Insider

Archives

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