Reports - grouping & subtotals

  • Thread starter Thread starter Ed DeMeo
  • Start date Start date
E

Ed DeMeo

I would like to be able to place the following type of
information in a report grouped by date and orderd by
shift with a subtotal following each group. And have a
summary total at the bottom of the report.

example:

date equip_name shift down_time scheduled_hrs

08/01 "A" 1 0 8
08/01 "A" 2 2 8
08/01 "B" 1 1 8
08/01 "C" 1 3 8

Sub Total Sub Total
6 24

date equip_name shift down_time scheduled_hrs

08/02 "A" 1 0 8
08/02 "A" 2 2 8
08/02 "B" 1 3 8
08/02 "C" 1 3 8

Sub Total Sub Total
8 24

Summary Total Summary Total
14 48


Thanks for your help.
Ed
 
-----Original Message-----
I would like to be able to place the following type of
information in a report grouped by date and orderd by
shift with a subtotal following each group. And have a
summary total at the bottom of the report.

example:

date equip_name shift down_time scheduled_hrs

08/01 "A" 1 0 8
08/01 "A" 2 2 8
08/01 "B" 1 1 8
08/01 "C" 1 3 8

Sub Total Sub Total
6 24

date equip_name shift down_time scheduled_hrs

08/02 "A" 1 0 8
08/02 "A" 2 2 8
08/02 "B" 1 3 8
08/02 "C" 1 3 8

Sub Total Sub Total
8 24

Summary Total Summary Total
14 48


Thanks for your help.
Ed


.
in report design use view - sorting and groupings
Click to expand...
 
Ed said:
I would like to be able to place the following type of
information in a report grouped by date and orderd by
shift with a subtotal following each group. And have a
summary total at the bottom of the report.

example:

date equip_name shift down_time scheduled_hrs

08/01 "A" 1 0 8
08/01 "A" 2 2 8
08/01 "B" 1 1 8
08/01 "C" 1 3 8

Sub Total Sub Total
6 24

date equip_name shift down_time scheduled_hrs

08/02 "A" 1 0 8
08/02 "A" 2 2 8
08/02 "B" 1 3 8
08/02 "C" 1 3 8

Sub Total Sub Total
8 24

Summary Total Summary Total
14 48
Click to expand...

Use the Sorting and Grouping feature (View menu) to first
specify a group on the date field with footer. Second, add
the shift field without header or footer. This should
present the data in the report in the order you want.

To get the date subtotals add text boxes with expressions
like:
=Sum([down_time])
=Sum([scheduled_hrs])

Then use two more text boxes in the report footer using the
same expressions.

BTW, because you have multiple machines the total scheduled
hours per data can be greater than 24 (your examples have
32).
 
Back
Top