Skip to Content

Suppress Patients that do not have a specific Order

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 25, 2017 at 08:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 03:33 PM

    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 ?

    Add comment
    10|10000 characters needed 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