Hi everyone,
I can't figure out how to get my report to display the right information.
My report is driven by a query. It usually works, but when I have the same raw material from the same lot being used in the same recipe, it only displays one result. This would happen when, during a production, we have 2 steps.
In the example below, it should show me that in production 041167, I used 5.5 units and 80 units of CSOR. It's only showing me the top result which is 5.5 units.
Here's the query results:
Here's the report layout:
and this is how my report prints: