INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Formula to suppress records

Formula to suppress records

(OP)
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!

RE: Formula to suppress records

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

RE: Formula to suppress records

(OP)
Thank you so much! This was really helpful.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close