Notifications
Clear all
Topic starter
Does anyone have a crystal report built which would show all the medications a provider has prescribed?
If so could you email me at [email protected]
Thanks in advance.
Lorrie
Posted : June 20, 2012 11:32 pm
Did you ever get a response to this? We are looking for something like this as well.
Posted : June 19, 2013 3:13 am
Are you still looking for a report? I have a couple that may work depending on the detail you are looking for.
Posted : August 6, 2013 7:20 am
We are still looking for this if you would be willing to share!
Posted : August 6, 2013 10:15 pm
I am looking for a report that lists the following:
- 6mos of Rx data with the following info by prescription:
- Date
- Prescriber
- Drug name and strength
- # of refills
- DAW (yes/no)
- Method of insurance
- Name of pharmacy prescription sent
Does anyone have something that would pull something similar to this? We are on Version 11 CPS. (not sure if that matters)
Posted : August 28, 2013 9:41 pm
ganewman said:
Are you still looking for a report? I have a couple that may work depending on the detail you are looking for.
Hi I am looking for a report that I could run for specific medications prescribed by Provider for a certain time-frame, would you be willing to share your reports?
Thanks!!
Posted : September 8, 2013 11:23 pm
ganewman said:
Are you still looking for a report? I have a couple that may work depending on the detail you are looking for.
Hi, I see this is a popular report request. If you are if you are willing to continue to share we would appreciate it!
Thanks!
Posted : September 10, 2013 1:55 am
I have the attached report.
It asks for begin/end date, as well as a question if to only look for narcotics.
The narcotics filter is set to either class code (2-3-4-5) or a GPI beginning with 65 (analgesic-narcotic).
Posted : September 10, 2013 11:22 pm
joeg1962 said:
I have the attached report.
It asks for begin/end date, as well as a question if to only look for narcotics.
The narcotics filter is set to either class code (2-3-4-5) or a GPI beginning with 65 (analgesic-narcotic).
Thanks so much!
Posted : September 11, 2013 1:56 am
I am looking for a report like this, so I downloaded this one, but I am not getting any results. Am I doing something wrong?
Posted : September 11, 2013 5:41 am
Unsure what could be wrong - and not getting any data.
Something in selection logic?
Are your PERSON's not PATIENT's?
Did you pick TRUE/FALSE for the Narcotics initial question?
{PRESCRIB.CLINICALDATE} in ({?Start_Date} to {?End_Date}) and
cstr({MEDICATE.XID}) = "1.00e+035" and
{PERSON.ISPATIENT} = "Y" and
not (LowerCase({PERSON.LASTNAME}) like ["test","testing","logician"]) and
{MEDICATE.STOPDATE} = Date (4700, 12, 31) and
{@_ValidLine} = "OK" and
{MEDINFO_1.LEGEND} = "R"
Posted : September 11, 2013 5:48 am
Thanks for your quick response. We usually have our VAR create any custom reports we need, so this is the first time I have tried a report from elsewhere. I may have done something wrong. I went to Administration\Reports\Clinical Reports and added the report. I then went to the chart and chose Quality and Report, picked the report, keyed in the start date, end date and tried both true and false for narcotics. I didn't see anything about selecting a patient.
Posted : September 11, 2013 5:58 am
Yes, I think what you did was correct.
My question about 'patient' was more of an internal setting; I do not think likely, but wanted to ask. Don't worry about it.
I will take a look at the coding to see what else might be happening. Or maybe someone else on this board will notice something I customized for my site, but that is not standard.
Posted : September 11, 2013 9:29 pm
Is there something in the report that I have to change to look at our database?
Posted : September 11, 2013 10:58 pm
Page 1 / 2
Next
