I have an issue with a report that I am working on. I need to get some parameters information that are present inside a subbatch called Spraying, the issue is that this SubBatch can be repeated any number of times depending on the recipe. For example I will get Spraying 1, Spraying 2, Spraying 3....but the number can be more or less...is not a fixed quantity of subbatches...the thing is that I need to create a table for each Spraying that I get and present in that table some parameters (oh and depending on the data, the parameters in the table can be different)
Right now I have created a subbatch called Spraying* that is getting all the information that has the word Spraying on it, no matter which number follows (1,2,3,4,5...) but I need to separate it by Spraying 1(data), Spraying 2 (data)...and I don't see how to do this in any way other than to create a SubBatch for each "possible" entry…. and use the Spanning option.
But again, I can have multiple entries...so I need to know if there is any possibility to create a group of subbatches separately with each number...automatically, not just guessing.
Additionally there is the tables issue: The issue is that each Spraying Subbatch can have a possible outcome depending on the data results... let's call it Spraying Inlet 1 (table 1), Spraying Inlet 2 (table 2), Spraying Out 1(table 3), Spraying Out 2(table 4)...so for each Spraying Subbatch I will have a total of 4 different tables that I can get. Believe me I do not want to create 4 random conditioned tables for each random Subtach entry...
The logic is something near this:
As you can see I am in deep trouble....I hope it is understandable.