Notifications
Clear all
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
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
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
if UpperCase ({MEDICATE.DESCRIPTION}) like "search med" then
1
else
0
Posted : October 19, 2012 5:30 am
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
