Answers.Body: <p>I would use the Search Builder (<strong>Search menu » Search Builder</strong>) 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.</p>
  
  <p>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.</p>
  
  <p><a href="https://i.sstatic.net/XPI55.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XPI55.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-08T20:54:04.293Z
Answers.Text: 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.
Answers.UserDisplayName: Jackrabbitrocks
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-07T22:58:44.743Z
Answers.LastActivityDate: 2017-01-07T22:58:44.743Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>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.</p>
  
  <p>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.</p>
  
  <p>I did find <a href="https://civicrm.stackexchange.com/questions/10224/how-do-i-exclude-blank-or-null-in-a-report">this question/answer</a> which suggests using multiple choice selection as a workaround.</p>
  
  <p>This answer is not sufficient, since the columns that I want to choose do not have the option to multi select values.</p>
  
  <p>Any suggestions would be appreciated.</p>
  
Tags: <search><reports>
Title: Excluding blank or null values from report
ThreadText: # Excluding blank or null values from report
  
  (Asked by: username_0 on 2017-01-07)
  
  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](https://civicrm.stackexchange.com/questions/10224/how-do-i-exclude-blank-or-null-in-a-report) 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.
  
  **Tags:** search, reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-01-07. Score: 2
  
  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](https://i.sstatic.net/XPI55.png)](https://i.sstatic.net/XPI55.png)
  
  > **Comments:**
  > **username_0**: 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.  
  
  ---
  
  