conditional supress 1

[yehong]

I need to supress the lines and show one line only when the amount field is repeated.
Here is an example data:

Date Amount
01/01/04 4000.00
07/01/04 4000.00
12/31/04 4000.00

So, here is how it should appear on the report
01/01/04 4000.00.

Both fields are in the details section. How do I compare the Amounts and decide if they are repeating and then supress?

 

[lyanch]

right click on the detail section and choose "format section" or "section expert" depending on your crystal version. Click on the formula button for suppresion (x-2).

Add:

{table.amount} = previous({table.amount})

placing your actual field in {table.amount}

One note, this only changes the display, the suppressed amounts will still show up in totals etc.

Lisa

 

[yehong]

Lisa, it worked like removing a hair from butter.
Thanks.