Subtotals in Group Headers

[John Michl]

Is it possible to have a subtotal in a group header that totals the groups
and/or detail below it? I need a report such as the following.

Units Sales
Total Apples 10 $20
Red Delicious 3 $5
Golden Delicious 7 $15

Total Oranges 6 $12
Navel 4 $8
Velencia 2 $4

Total Fruit 16 $32


Thanks - John Michl

 

[Jim/Chris]

Yes you can. In your group header add 2 unbound controls.
Set the control source to
=sum([Units])
=sum([sales])

don't forget to format the controls

Jim

 

[John Michl]

Thanks, that was easy enough.

Yes you can. In your group header add 2 unbound controls.
Set the control source to
=sum([Units])
=sum([sales])

don't forget to format the controls

Jim

-----Original Message-----
Is it possible to have a subtotal in a group header that totals the groups
and/or detail below it? I need a report such as the following.

Units Sales
Total Apples 10 $20
Red Delicious 3 $5
Golden Delicious 7 $15

Total Oranges 6 $12
Navel 4 $8
Velencia 2 $4

Total Fruit 16 $32


Thanks - John Michl


.