[RESOLVED] Suppressing Data

Hi,

I'm having trouble with running totals.

I would like to only have the top 10 results in each group (added to the average sum), although the suppressing only shows 10 lines, it's adding all cells in the background to the sums as shown in the attachment.

Is there away to solve this?

Any help would be must appreciated

Attachment 31823

Then change to formula fields instead of running totals fields
...and in the formula start with :

Code:

---

WhilePrintingRecords

---

Thanks for that!

When using whileprintingrecords, do you have it so that it < 10 or against the boolean column when it = true?

Little bit new to crystal reports.

Thanks

When we use WhilePrintingRecords, it mean that the formula it's going to be calculated exactly when the records are printed
So if you already have suppressed some records, these suppressed records are not going to be considered in the sum, only the printed ones

If I'm not mistaken...WhilePrinitingRecords I'm unable to then calculate sums based on sums that have already used WhilePrintingRecords?

If this is the case then it won't work for me as the sums in red are based on the sums already calculated?

Thanks

You could do it if you change from RunningTotal fields to Formula fields as I posted in post #2

Sorted!!! :) Used two shared variables, first being a counter and the second plusing the table field all the time it was less than 10.

Happy days...Thanks again