Is it possible to read all fields from a table into an array or is there an alternative solution?
I have a report that is grouped on Photocopy Machine Model then grouped by Machine number and then grouped by technician.
The idea is to look at the machine's meter reading from each service call, subtract the previous meter reading from the current meter reading which tells us how many copies there were between service calls, this figure needs to be attributed to the technician.
I have been able to get this to work if the report is only grouped by machine type and machine number by setting up a running total with formulas, however once it is grouped by technician the "previous" formula I have set up is not correct.
The only way I can think to make this work is read the service call ID and the meter readings into arrays, look up and match the service call ID of the current record to retrieve the correct meter reading.
If this is possible how can I do it?
I have a report that is grouped on Photocopy Machine Model then grouped by Machine number and then grouped by technician.
The idea is to look at the machine's meter reading from each service call, subtract the previous meter reading from the current meter reading which tells us how many copies there were between service calls, this figure needs to be attributed to the technician.
I have been able to get this to work if the report is only grouped by machine type and machine number by setting up a running total with formulas, however once it is grouped by technician the "previous" formula I have set up is not correct.
The only way I can think to make this work is read the service call ID and the meter readings into arrays, look up and match the service call ID of the current record to retrieve the correct meter reading.
If this is possible how can I do it?