Hi I've created a report which generates from the SLJobRoutes IDO and based on the inputs users add to a filtering form. The report generates 1 page for every job listed (based on what the user inputs in the job number from and to filter). It also only generates it only for operation 10. So literally only 1 report is generated for every job number.
I now need to duplicate each label based on the JobQtyReleased number. Example: if job J10 has a released qty of 15, I want the exact same report to be generated 15 times.
This must apply no matter how many reports are generated - if I have jobs 10 to 20, I want each job report to be replicated however many times there are released qtys. Example: J10 has JobQtyReleased of 15, J11 has 3, J12 has 6 - there should be 15 replicas of the J10 report, 3 of J11 report, and so on.
Can anyone help me with this? I'm in the Cloud and tried writing a loop in the form script to do this, but haven't managed to make it work as this isn't something I'm terribly familiar with. Is there any more standard/simple way of achieving this?