Notifications
Clear all
Topic starter
I am trying to get a list of patients that belong to a certain pharmacy. I am using Crystal Reports XI and EMR 9.5. Any help that you could provide me would be greatly appreciated. Thanks!
Posted : June 26, 2013 5:31 am
Tables
PERSON
RELBUSS
BUSINESS
Links
PERSON.PID -->RELBUSS.PID
RELBUSS.BUSID-->BUSINESS.BUSID
Selection criteria
{BUSINESS.ISPHARMACY} = "Y"
and uppercase({BUSINESS.SEARCHNAME}) startswith "WALGREENS"
//just an eg. to pull pts with Walgreens as pharmacy
Hope this helps.
Posted : June 26, 2013 11:37 pm
Topic starter
Perfect!! Thanks!!
Posted : June 26, 2013 11:48 pm
