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.