Conditionally Suppress Records 1

[sandy1447]

My report groups data by
Employee name, ID# then details test name. I need to exclude ID#s based on a test name in the detail. Example:
Smith ID#000265576
Art Access
Rt Coronary Angio
Left Heart Cath
Hemostasis

Jones ID#000266954
Art Access
Right Heart Cath
Hemostasis
Left Heart Cath

I need to exclude Jones based on test Right Heart Cath only.

 

[trixiegrrl]

Create a formula to test for Right Heart Cath:

if {TestName} = "Right Heart Cath"
then 1
else 0

not necessary, but if you want, put the formula in details and do a Sum on it by the ID Group. (you can then suppress these or delete them)

then go to Report Menu > Selection Formulas > Group and reference the summary you just created above.

Sum(@formulaabove, IdNumbergroup)=0

 

[trixiegrrl]

oh and be advised that if you have any totals you will need to do Running Total instead.

 

[sandy1447]

Thanks, worked perfectly!