AnsweredAssumed Answered

How to create a report to show totals for multiple fields within a record

Question asked by Tom_Droz on Nov 16, 2016
Latest reply on Nov 17, 2016 by erolst

Hi All




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?