Total of Group Footer records in Report Footer?

[mrtroy]

I have a table that resembles this:

RECID ITEM COST
001 ALPHA 5.00
002 ALPHA 6.00
003 ALPHA 7.00
004 BRAVO 3.00
005 BRAVO 4.00.

My report is set up so that the output is the last record for any given item. I do this by hidding the details and putting fields in the group footer. I want to sum the cost of the last record for each item only. If I insert a summary into the report footer I get 25.00. What I want is 11.00. How can I do this?

 

[lbass]

Try grouping on item (you can suppress the group header and footer if you want), and sorting DESCENDING on {table.recID}. Then use a running total that sums cost, evaluates on change of group, and resets never.

Place the running total in the report footer.

-LB

 

[mrtroy]

Ahhhhh...thanks!