Show nulls only in report 1

[ermutigen]

I have a report that shows username, department number, and IDnumber. I would like to show only users that have no value or null in the IDnumber field. How can I do this?

Thanks
e

 

[Turkbear]

Hi,
One way is to create a record selection formula of:

IsNull({IDnumber}) or Trim({IDnumber}) = ""





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ermutigen]

Thanks Turkbear. That worked.