Notifications
Clear all
Topic starter
Hello everyone,
Does anyone have a report that you can run that would print out all of the medications in a particular physicians custom list. I have a doctor that would like to review what is in his custom list and I can not find a good way to present the information to him.
Thanks for your help.
Posted : May 27, 2015 5:24 am
The only way I know is to Export Clinical Kits. Select Medication Custom List, Select Physician and export. Right Click on the MCL file and open with Notepad. Looks messy but it will have their whole list.
Michelle
Posted : May 27, 2015 5:41 am
I have a report that lists out the medications present in a custom list (by custom list name) and is easily exported to excel. This is for Oracle as we are on CEMR - do you have crystal reports? I can't get it to upload but feel free to email me:
The other option is to build a very quick one - all you really need is two tables. Pull in QPICKS and MEDDEPT tables - link QPICKS to MEDDEPT via the QPICKS.QPID to MEDDEPT.GID. From there set your record selection to QPICKS.DESCRIPTION = "custom list name" and put the fields you are interested in from the MEDDEPT table into the detail of the report then run. Mine has the Generic name, Sig, Quantity and Refills.
Thanks
Mike
Posted : May 27, 2015 5:57 am
Posted : May 27, 2015 7:28 am
Topic starter
Thanks everyone!!
Posted : May 28, 2015 3:13 am
You could also open using excel; viewing all file types and selecting delimited on the Text Import Wizard using your [ or ] as delimiters. This at least allows you to get rid of stuff they don't need to see and makes it cleaner. BUT, I am very excited and thankful for the report that rwilliams supplied that will make it easier.
Posted : June 3, 2015 2:01 am
That was actually the first report I ever wrote (3rd version as you can see from the name) and was the reason I decided to learn Crystal. (which is why it is so fancy, I was playing with different features) I have probably written 50+ since then.
Posted : June 3, 2015 4:05 am
Hi, I am trying to use this crystal report but I have to hook it up to my own database and once I do, the report still does not work. I think I have to recreate the whole report after I connect it to my own db. Do you know what I am doing wrong? Thanks for providing this!
Posted : December 12, 2016 10:27 am
Can you send me an email with screenshots of what you see?
Posted : December 13, 2016 2:24 am
