Summary Problem

[jajiyiko]

Hi!

This is my Crystal report problem.

I have a file like this

Recno Size Time
===== ====== ======
1 12.000 14
1 12.000 19
2 10.000 23
2 10.000 42
3 26.000 18

I have a crystal report like this

Recno Size Time
===== ====== ======
1 12.000 33
2 10.000 65
3 26.000 18
==========================
Sum: 70.000 116

but I dont want to Size sum like this

Size sum must be 48.000

please help me

Sorry my english

 

[lbass]

It looks like you have a group on recno. For size, go to the field explorer and insert a running total that uses the sum of size, evaluate on change of group (recno), reset never.

-LB

 

[jajiyiko]

Hi lbass

Thank you for your answer

I tried your answer before.It not solve my problem

thank you

 

[lbass]

Then you are not implementing it correctly. This will work. The running total should be placed in the report footer. Please describe how you tried my suggestion.

-LB

 

[jajiyiko]

Hi!

My Crystal Report version is 4.6

Running total is not placed in the report footer

thank you again

 

[jajiyiko]

Hi


Records are correct but grand total is incorrect.

 

[lbass]

In your example you only had a group on {table.recno}. If you have an outer group, then go to the field explorer->running total->new->select {table.size}, sum, evaluate on change of group (recno), reset on change of your outer group. This running total would then be placed in the group footer of your outer group.

If you mean for this to be a grand total, then the running total should not be reset, and it must be placed in the report footer.

-LB