Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Patients taking/not taking certian meds

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

90 Views

RSS

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I am trying to run a report to show patients that are not on certain meds. But what my report is doing now is using MEDICATE.Description & listing one med for each patient so if the meds that I am trying to list isnt there then patient will still appear on the report. How can I get the report to list all the active meds for each patient then have the report search the whole list of meds for each patient for a certain meds and if its not there, then list the patient on the report? Ive been using "Does not contain *somemedname* where the * represents multiple chars in the crystal formula. In other words, if patient is not taking "a certain med" then list on report.

Posted : October 19, 2012 3:08 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

checking for 'not' something is tough. I would group by patient, create a formula for the med in question, returning 1 if exists else 0, then suppress the detail and in the group footer sum this formula, then suppress the group is this sum = 0.

Posted : October 19, 2012 4:13 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

jjordet said:

checking for 'not' something is tough. I would group by patient, create a formula for the med in question, returning 1 if exists else 0, then suppress the detail and in the group footer sum this formula, then suppress the group is this sum = 0.

Can you please help me get started with the formula? I've never done if exists or not exists before. All new to me. I am using the MEDICATE.Description field from Centricity EMR 95. database. Thanks!

Posted : October 19, 2012 5:15 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

if UpperCase ({MEDICATE.DESCRIPTION}) like "search med" then
1
else
0

Posted : October 19, 2012 5:30 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Will I do a report listing ALL patients (grouped) then list all the meds taken first then filter out the meds, before adding the other criteria(fields) to the report?

Posted : October 21, 2012 11:40 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0