Hello!
I have a report in which I want to program a certain behaviour.
I have a textfield "Liefermenge" in the detail section of the report which contains the Quantity of Product that has to be delivered to the customer. e.g. 100 Pieces
In the Group Footer I have a subreport which contains a textfield called "Lagermenge". This data displays how much of this product is available at a particular space in the warehouse.
There are several spaces in the warehouse which contain the product needed to fulfill the order.
The subreport looks something like this:
"Lagermenge" - "Space on which it is stored in the warehouse" - "Product Name"
Right now, every single space on which the needed product is stored is displayed in the subreport.
I want it to only display as many spaces as are needed to fulfill the order (+ 2 additional warehouse spaces as a "buffer")
E.g.:
Liefermenge = 100 Pieces of ProductA
Lagermenge 20 - Space1 - ProductA
Lagermenge 50 - Space2 - ProductA
Lagermenge 10 - Space3 - ProductA
Lagermenge 20 - Space4 - ProductA <- 100 Pieces fulfilled
Lagermenge 30 - Space5 - ProductA
Lagermenge 15 - Space6 - ProductA <- 2 additional warehouse spaces "Buffer"
How would I go about doing that?
I hope the explanation of the situation is good enough.
Thank you!