Click to See Complete Forum and Search --> : Summerizing data


whensley
April 5th, 2010, 07:56 AM
Hi everyone. I've run into a snag with a report I have created. This is a variation of a previous report that I built. the report itself is a bit complicated, but it works great. It calculates the Direct/Indirect labor hours for employees in three different factories and it parameter driven by date and factory. I had a little trouble with it but thanks to the great suggestions of some folks here I was able to get it the way I wanted it.

Now I have created a variation of the report for a select few people. It is the same report but in the footer it summarizes the data by Indirect labor type. For instance let's say there are three labor types (maintenance, cleanup, and meetings). I'm trying to get a list of all of the types and the total hours spent on those types. The report is very complicated so I would be more than willing to email the .rpt file if anyone would like to see it.

jsham
April 11th, 2010, 12:03 PM
The report should be grouped by Labor Types and you can create Running Totals to summarize by the Labor Types. You reset the totals on change of group. To get a total of all types and total hours spent on those types, you would select 'Never' for Reset. This will count for the total hours for all types.