title: How to Select NOT IN Value (Formula Crystal Reports)
body: <p>I have this query in SQL server:</p>
  
  <pre><code>select * from  ARInvoices ar 
  left join ARInvoiceDetails det on ar.InvoiceID = det.InvoiceID
  where ar.InvoiceID not in (select InvoiceID from CashReceiptInvoices ) 
  and det.SubmitTo = 1 and VoucherStatus = 0 and det.TransactionType = 1
  </code></pre>
  
  <p>I would like to have it thru a Formula in Crystal Reports XI but i'm having a hard time with the not in. I used &lt;> but the results are coming empty.</p>