Hi Pete,
Thanks for the assistance.
I am trying to create a report we call Open Sales Order Requisitions. This report should only show information about Sales Orders if there are associated Requisitions made.
In the Main report I have 4 Groups. It uses 3 tables; Organizations, SalesOrders and SalesOrderLines
Group 1 = Sales Order Delivery Date
Group 2 = Customer Name
Group 3 = Sales Order ID
Group 4 = Sales Order Line ID
Group 1 and Group 4 are hard suppressed
In Group 3 I Show the Sales Order detail, like Sales Order ID, Delivery Date, Customer PO.
In Details A I show the Sales Order Lines detail like Qty, Part Number, Line ID.
In Details B I have a subreport that pulls Requisition information from a different table for each Sales Order Line. The Subreport links are the Sales Order Number and Sales Order Line ID. The subreport uses 2 tables RequistionLines, Parts
If there are no requisition Details for a Sales Order Line, then I suppress the subreport. I have that figured out...
Now what I need is...
If there are no Requisition details for a line, i want to suppress the line details also (Details A).
Then, if all the lines of a Sales Order have no Requisition Details, then I don't need to see the Sales Order information either, so I would want to suppress Group 3.
Following the pattern, then if All Sales order for a particular customer are suppressed, I would want to suppress Group 2 and similarly for group 1 if all Sales Order for a specific Delivery Date are suppressed.
Thanks again for any further suggestions...