Skip to Content
0

Suppress Patients that do not have a specific Order

Apr 24, 2017 at 08:20 PM

61

avatar image

I have a report that contains a sub-report. The main report pulls all patients. The sub-report only pulls certain orders the patient had done. In the main report I get all patients but I really only want the patients that DID NOT have the certain orders. I tried to write in my main report a formula where the order was not in xxxx but I still get all of the patients, but it just doesn't display those certain orders. Is there a way to suppress the patients in the main report that don't have those orders or do I need to do something in my main report to accomplish this ?

patients.jpg

patients.jpg (13.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Apr 25, 2017 at 08:28 AM
0

You will have to use group suppression instead of record selection. Group report by patient

Create formula

@order

If Orderfield = xxxx then 1 else 0

In group selection enter formula

Sum(@order, Patientgroupfield) >0

This will suppress all patients which have that order number/ref.

Please note data is just suppressed thus any summaries in higher groups or report level will include these records. You will need to use Running totals and use a formula to exclude these patients too.

Ian

Share
10 |10000 characters needed characters left characters exceeded
Curt Othmer Apr 25, 2017 at 03:33 PM
0

I don't quite understand your post. So I create a formula that says: if orderfield in ["xxx","xxx"] then 1 else 0, then in the group expert I select the formula @order and then do what ?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Not the group Expert

Report-> Selection Formula -> Group and then add the condition

Sum(@order, Patientgroupfield) >0

Replace PatientGroupField with whatever field you are using to Group by Patent

Ian

0