Skip to Content
0
Former Member
Feb 11, 2015 at 09:56 PM

How to supress group based on details

12 Views

Ok, first off, I'm very new to crystal reports and have no experience with it.
That being said, I have created a report that pulls all of our open orders and then tells item, qty on hand ,and qty on the order. I grouped these by order number and the items for the order are in my details.

What I wanted to do was to only show orders that did not have enough qty on hand to ship for the order. My initial thought was if qty_on_hand < Qty_on_order , then surpress the header. I am unfamiliar with how to say what I want and since each order can have many different items, I'm not sure how to actually achieve this.

I added if {qty_on_ord} > {qty_on_hand} then {Ord_#}, but this did not work. I really wish I was better versed in crystal since we seem to be using it more and more.

It sounds easy enough and I have browsed this community enough to know I'm in over my head, but I'm at a loss as to how to achieve my final goal for this report.

Any help is greatly appreciated!