I have created a report that gathers Order lineitems, which are products being ordered, and then a subsummary, grouping the linetems by a date for production. The line items show the item name, order ID and a # of parts that associated with each item. Ex.
1 lineitem contains 16 pcs of material x, and 24 pcs of material y, and 108 pcs of material z. In each subsummary then, I have a material sum field for each of the items to show a grand total of material x's, Y's, and Z's for each day.
For some reason, the report works perfectly for some orders, and then zero's everything out on others. What would cause the report to see some Lineitems and not others?