Group Footer Sum only includes last record in group

[melburstein]

What I will describe below is not my actual report, but an attempt to simplify it.

ACTIVITY Table COMMIT Table
-------------- ------------
Activity (number) Activity (number)
Description (text) Amount (number)

There is a one to many relationship and the tables are joined with a left outer join (by Activity number).

My Report looks like this:
--------------------------
PH Activity Description Amount
GH1 [Supressed]
D 110051 Project A $1,000
D 110051 Project A $6,000
GF1 110051 Project A $6,000

While not shown, the difference in the detail records is that one is for one month and the other for another month.

As you can see the Group Footing total should be $7,000. Once I get the total working, my intent is to supress the detail lines from printing. But I can not get the total to sum properly, even though it is the proper SUM.

I would greatly appreciate help. I am relatively new to Crystal Reports, so tell me in detail what I must do.

Thank You.

 

[melburstein]

After all day yesterday, not being able to find the problem, I awoke this morning to find your message and an idea that popped into my head as to what the problem might be. While I was sure that I was using a Summary field on the GF1 line -- guess what? -- I was not. Now the report works.

Mel