Notifications
Clear all
Topic starter
Application EMR 9.5
I have a referral report that I'm modifying for my user. She would like to have the Referring Provider show up on the report from Contacts in Registration.
The problem I'm having is, if there is no Referring Provider in Contacts the patient does not show up on her report; it works when the field is filled in.
I've tried using this formula:
if {RELPERS.RELATIONSHIP} = "RP" then {PERSON_1.FIRSTNAME} + " " +{PERSON_1.LASTNAME} else "None"
Any suggestions is appreciated.
Nancy
Posted : August 31, 2012 1:43 am
You need a left-outer join going to RELPERS so if a referring provider doesn't exist, it will still return the rest of the data for that patient.
Posted : August 31, 2012 1:48 am
