Summing the last entry in a group

[jamiesadler]

I am grouping data by date. I then need to sum the data in the last entry for each group.

If I setup a formula in the group footer that is equal to the data I am after the report displays the last entry in the group footer. If I try to sum this formula, is sums the data from all of the entries in the group.

Any Ideas??

 

[kenhamady]

You will need to use the 3-formula technique to create this total (faq149-182) Put the incrementing formula in the Group Footer to get just one value per group. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com