Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 17 Jan 2022 at 12:33pm
I am double checking that I understand the question and the examples. 1) you have a total 10 items that can be distributed among the 3 batches, and there is some logic that distributes the 10 items to the batches.
The examples listed show the requested amounts per batch and the report is returning which batch(es) should get which amount(s).
Hopefully, I got that correct.
I want to say that Crystal can do it, and I have a path to follow. I not sure how well I can explain it.
Here is the outline, and you will have to fill in a bit.
You will have a formula that calculates the number of items to assign to a batch (following the logic above). It will have to compare it's logic to how many items you actually have on hand, decreasing this amount as it assigns an amount to a batch. When there are no more items, I would have the formula assign 0. Hopefully, this makes it easier to code as it consistent.
Then in the display section, I would put in a suppression formula that looks something like: AssignedUnits = 0
The AssignedUnits would be a variable (either global or shared depending on if subreports are involved) and is the set in the formula.
This is all thinking off the top of my head as there is not much to go on in the post.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum