title: Filtering groups in crystal reports
body: <p>Ok, simple question to anyone who has experience with crystal (which I do not) ,
  but I have a report that is pulling in open orders, items ordered, qty ordered, and qty on hand. I am grouping by order # and would like to filter out all the orders that have any items with insufficient qty on hand for any item on the order to ship. I tried a simple formula of {qty_on_ord} &lt; {qty_on_hand} then {Ord_no}, and inserted this into the group header, but it didn't work. My end result basically wanted is: if an item has insufficient qty, then don't display the order at all, and could also go vice-versa and show the orders that are short, with a simple change of &lt;>. Im sure this is simple, but I have no experience in crystal reports and have spent more time than I wanted searching the web.</p>
  
  <p>Any help is greatly appreciated.</p>