Notifications
Clear all
Topic starter
Hi, trying to figure out a way to build a (text) table to show LDL-C compared to when medications were begun, changed, etc (to work with guidelines that say LDL should be lowered to 30-50% or pretreatment levels)
ideally it would end up showing something like
LDL value(date) Statin 1 start/stop date
LDL value 2(date) Statin start/stop date
etc.
Does anyone know a function or way to list all the past statins and when they were stopped/started?
Maybe there is a better solution.
Posted : January 21, 2017 3:39 am
Simplest is to use GPI code to identify statin, initial 4 digits 3940, then retrieve all data into array via Meds_After("delimited"), extract the rows and fields using getfields(), then process the array. If you want a code example, contact me directly.
Posted : January 21, 2017 8:21 am
Below is a snippet of the Crystal Report I built once before to help with a similar question. And the .rpt definition is included at the very bottom.
Essentially printing one page per patient, and printing a chronological report of LDL labs and statin prescriptions over the past few years. The report only prints for patients 40-75 years old, and with the last LDL >= 110.
Feel free to use the report. Be warned, it may take a while to run. I think I ran for sections of patients (last names A-H for example). And some things like 'Team" were specific to my site.
And let me know any thoughts, suggestions.
Posted : January 23, 2017 2:38 am
