title: Crystal Report how to ignore certain rows when one of the criteria matches
body: <p>i've just started on Crystal Reports and just gotten the basics of it at the moment, however it seems that i got caught up in one part where i'm stuck at the moment.</p>
  
  <p>I've created a selection clause and managed to get as close as I could for this report.</p>
  
  <pre><code>{table.status} = 'O' and
  {table.date} = currentdate - 1
  </code></pre>
  
  <p>here's an example with the results that come up</p>
  
  <pre><code>`account | ir_num`   
  
  `100123  | null`
  
  `100123  | 1223`
  
  `100124  | null`
  
  `100125  | null`
  </code></pre>
  
  <p>this is due to the table having both null values and running number values on the ir_num column. what i'd like to display is that if there are two same account numbers and if one of them even displays the ir_num column with a value inside, i'll then take it and ignore the null ones. </p>
  
  <p>So basically the ideal one should look like this </p>
  
  <pre><code>`account | ir_num`   
  
  `100123  | 1223`
  
  `100124  | null`
  
  `100125  | null`  
  </code></pre>
  
  <p>Would highly appreciate if someone could guide me through on how to get this up and running. Thank you very much! </p>