To put sub- totals in a report.

  • Thread starter Thread starter Sergio Mund
  • Start date Start date
S

Sergio Mund

Example: John 3 21,8
4 3,2
Sub: 7 25,00

Paul 3 2,7
4 1,3
2 1,1
Sub: 9 5,1

Total: 16 30,1

How to insert a sub-total of the itens and at the end the total?
Thanks.
 
Sergio said:
Example: John 3 21,8
4 3,2
Sub: 7 25,00

Paul 3 2,7
4 1,3
2 1,1
Sub: 9 5,1

Total: 16 30,1

How to insert a sub-total of the itens and at the end the total?
Click to expand...


Use the Sorting and Grouping window (View menu) to create a
group (with footer) on the person field. Then add text
boxes to the group footer section. One with an expression
like =Sum([number field]) and the other like
=Sum([value field])

The exact same expressions can be used in the report footer
to display the grand total.
 
Back
Top