Report 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

 

[jajiyiko]

my crystal report version is 4.6

 

[IdoMillet]

The easiest solution for this is to:

1. Group on RecNo (looks like you already doing that).

2. Create a Running Total that sums Size, but in the 'Evaluate' option set it to 'On Change of Group' and select the RecNo group.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com