I'd like to create a report that includes a record if ANY value for a particular column is present, but excludes if there is no value.

For example, for gender of Male or Female, I'd like to filter if someone entered either value. Entries without a value would be excluded.

I did find this question/answer which suggests using multiple choice selection as a workaround.

This answer is not sufficient, since the columns that I want to choose do not have the option to multi select values.

Any suggestions would be appreciated.


1 Answer 1


I would use the Search Builder (Search menu » Search Builder) to select your field with an operator of "Not Empty" (see screenshot below). It's not clear when you say "Report" if a search is sufficient - if it is, you're done.

If you DO need a report, add these users to a group (possibly a smart group, depending on whether you need this on an ongoing basis). Then generate your report, filtering by members of the group.

enter image description here

  • Yes, thank you. I figured that it would be easiest for me to just build a search instead of going through reports. Good to know about the step of making a group and then filtering from there. Jan 8, 2017 at 20:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.