Suppressing SOME flds on detail line

[CESHRPR]

This is probably so easy, but I'm at a loss. Take example below:

CMPY PROCID AMOUNT STATUS EVENT

1234 092393 999.99 READY ORGRDYHLD
1234 092393 999.99 READY ORGRDYHALT
1234 092393 999.99 READY RPARDYHLD
1234 092393 999.99 USED RPARDYHLD

When a new 'event' happens to the same record, I only want to show the new event, not the whole record. However, if any other field changes (in this case status) I want to show the entire record. Hence, suppress if duplicate on the field won't work. Suggestions? Seems like it ought to be really basic but I'm brain dead.....

Thanks in advance!

 

[lbass]

You could try the following:

Create a formula {@fourfields} which concatenates the first four fields (not for display purposes, but for use in suppression):

{table.CMPY} & {table.PROCID} & {table.AMOUNT} & {table.STATUS}

Then use the following formula in format field->common->suppress formula area for each of the first four fields:

{@fourfields} = previous({@fourfields})

Check suppress if duplicated for the {table.event} field.

-LB