I have a record that has a technician with total hours billed. I can generate a report easily that will show how many hours each technician worked on a found set of records.
However there is a 2nd option within the record. If there were multiple technicians that had hours on that record, the file is setup so that there can be up to 3 technicians with hours for each.
My question is how do I do a report showing the total for each technician?
I think I need to run an if statement, so that if there is detail breakout, I need to show that data, if not, show the selected technican. But if there is multiple technicians how do I show totals for each in a found set?
One thought was to do looping and create a virtual list, but then I am not sure how many empty records I would need in my VL table. Probably in the thousands potentially.
Any other thoughts on how to make this work?