I work for a truck dealership, and we have a service department report that gives us some totals on the technicians efficiency on each job billed for a period of time. This report is as follows:
However, I want to add a Sum of the total hours the technician was available to work during the same period. So I think to myself, no big deal, lets just go to our database table and pull up the ActualHours worked during the week, do a summary, and add it to a Group Header. However, when I do that I get this:
The report repeats a bunch of the rows... Is this a database linking issue, or what is causing this?