I have a crystal report that has a mock crosstab with 48 spaces.
Techs use this as a plate map for testing samples. Each batch can have up to 47 samples (first cell is always a control).
I need to be able to put the sample ID in the correct space but have not been able to do that so far because the batch does not always start on cell #2. If the plate has cells that are not suitable for testing, they can start a batch on the next available cell, like cell number 22, for instance.
How can I possibly place the correct ID's in the correct cells whey they're starting at random numbers? I created a table with 48 numbers as "cell addresses" and have a parameter called "First Cell" for the tech to enter the first cell they are using but I can't seem to get any further - how do I link the two??
Any attempt I've made to use *next* function works great on first and second values, but doesn't go anymore. The ID's are alphanumeric so i can't really use +1. I've also tried creating arrays and then calling each element out one by one but that's not working well either.
This mock table is in the report footer.
Any help is much appreciated!