Formula to suppress records

[bp7]

Does SAP Crystal Reports 2013 have capability to suppress output for records that do not meet certain criteria. If it does, I would welcome any suggestions as to how I might do this. If there is a formula that might do this, I would welcome some help with the syntax and expression.

I want to limit output to revision hip or revision knee surgery occurring after a THR (total hip replacement) or TKR (total knee replacement). The THR or TKR are considered the “index surgery”.

I am interested in revision on the same laterality.

My fields are PName (Patient Name), PDate (Procedure Date), Proc (Procedure Name) and Laterality (which indicates left or right).
I have grouped my records by PName and then by Pdate.

In the illustration below, I would want to see output for Adams and Fox only, and suppress all records for Jones, Williams, and Doe, and the first Revision Knee for Fox (while keeping Fox's other records).

Name Pdate Proc Laterality

Jones 1/4/2016 TKR Left
Jones 1/12/2016/ TKR Right

Williams 2/24/2016 RevisionHip Right
Williams 3/20/2016 THR Left

Doe 4/1/2016 TKR Right
Doe 4/14/2016 RevisionKnee Left

Adams 1/3/2016 THR Left
Adams 2/14/2016 RevisionHip Left

Fox 3/12/2016 RevisionKnee Left
Fox 5/22/2016 THR Right
Fox 6/2/2016 RevisionHip Right

Thank you in advance for your help!

 

[Charliy]

You could create a formula like
if {table.proc} in ["TKR Left","TKR Right","THR Left", "THR Right"]
then 1
else if previous({table.proc}) in ["TKR Left","TKR Right","THR Left", "THR Right"]
then 1
else 0

Then do suppression if that formula is 0

 

[bp7]

Thank you so much! This was really helpful.