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 6: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 27, 2013 12:37 am
Topic starter
Perfect!! Thanks!!
Posted : June 27, 2013 12:48 am
