Notifications
Clear all
Topic starter
Is it possible to pull in a list of controlled substance prescribed by a specific provider using Crystal Reports?
Thanks
Debbie
Posted : April 1, 2013 1:18 am
The column "classcode" in MEDINFO will have a number instead of NULL if it is a schedule class drug. So, in your case you can just JOIN MEDINFO to MEDICATE on DDID and check in the WHERE clause whether it has a classcode or not.
Posted : April 2, 2013 12:17 am
Topic starter
Thanks Mike, we'll give that a shot.
Posted : April 2, 2013 12:24 am
