Totals Problem

[Wayne79]

Creating a report in CR 8.5

Data from tables looks like:

Trip Miles Cost Other$ Fuel
1 150 57.5 2.5 0.0
1 150 57.5 0.0 23.5
2 130 69.0 13.5 0.0
2 130 69.0 4.5 0.0
2 130 69.0 0.0 27.5

Results should look like:

Trip Miles Cost Other$ Fuel
1 150 57.5 2.5 23.5
2 130 69.0 18.0 27.5
-------------------------------------------
Totals: 280 126.5 20.5 50.0


What I'm getting is

Trip Miles Cost Other$ Fuel
1 150 57.5 2.5 0.0
1 150 57.5 0.0 23.5
2 130 69.0 13.5 0.0
2 130 69.0 4.5 0.0
2 130 69.0 0.0 27.5
--------------------------------------------
Totals: 590 322.0 20.5 50.0

How do I fix this?

 

[lbass]

Insert a group on trip and then ddrag the miles and cost field into the group header. Then right click on the Other$ field and insert a sum. Do the same for fuel, and then drag the summaries to the group header and suppress the detail section. For the Totals, you can again insert summaries on other and fueld, but insert running totals on miles and cost where you select the field, sum, evaluate on change of group (trip), reset never.

-LB