Skip to Content
0
Former Member
Aug 08, 2016 at 04:08 PM

How to achieve the following logic

22 Views

Hi All,

I have following columns on my report

PersonID Audit Date Audit Action

1234 08/01/2016 4

1234 08/05/2016 5

An Audit Action of 4 means that an error was added while an Audit action of 5 means that the error was deleted.

I want to display only the first line of data on the report till the Audit Action was 4 (i.e. error was added), however as soon as the same PersonID encounters an AudIt Action of 5 (error deleted), then i do not want to display either of the records on the report.

Is it possible to achieve this logic on a crystal report?

Thanks.