crystal report sum 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

 

[Madawc]

I assume you have grouped by Recno. Do a running total, and have it add once per Recno group.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.

That's for Crystal 10, but I did similar things in Crystal 8.5. It is best if you say which version you have - check under 'Help', and there is no need to say 10.0.5.746 or whatever.

Madawc Williams (East Anglia, UK)