Hi there.. I use SAP Crystal Reports

I'm working on a report that has a running total field.

the columns are:

Date - Invoice # - Invoice Total - Manifest #

the report keeps repeating each line four times..

my table linking is correct, I'm 100% sure.
It repeats the rows because I'm pulling the manifest number which exists on each line item of every invoice...

I want some formula to suppress any duplicate invoice number...

I tried suppress if duplicate, but that only suppresses the column for the invoice # - it doesn't suppess the whole row which is what I want - because the running total keeps repeating and that throws off the whole report...

PLEASE HELP :(

you can do as Gurbs suggests but note that a Running Total does not stop evaluating just because something is suppressed. You need to alter the evaluation condition in the RT itself, like using on change of a field and choose the invoice#

Gurbs: it helped a LITTLE by navigating what's duplicate and how many duplicates do I have - it's a temporary solution..

DBlank: Thank you for the note.

hello:

that didn't work, it says:
"The remaining text does not appear to be part of the formula."
This is what I have..

{V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO} = previous {V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO}


Thank you guys..

That worked! thanks SO MUCH!!!!!!!!!!!!!!!!!!

but now, the running total, as DBlank mentioned - is still counting the suppressed fields. Any idea how to stop that? and only count 1 line?