Notifications
Clear all
We are unable to import the report. IT says we need the .bin file in order to do so. Do you happen to have that? Thank you for posting!
Posted : September 11, 2013 11:44 pm
Are you on oracle or sql? We are on oracle 9.2 and the report worked fine for us but I just loaded it into our beta version of CPS 11 and it produced blank results.
Posted : September 12, 2013 12:24 am
As the creator, I am on Oracle and EMR 9.5
Perhaps some differences in file structure?
Posted : September 12, 2013 12:28 am
Ah, maybe thats our issue. We run SQL. We are on CPS version 11
Posted : September 12, 2013 1:26 am
We are on sql, so that is probably the issue.
Posted : September 12, 2013 1:27 am
Does anyone have this report or one like it for SQL?
Posted : September 17, 2013 6:28 am
I have tried running the report in Oracle 9.5 and it seems that it is not catching all of our patients. I prescribed a medication on one of our test patients and the patient did not pull to the report.
Is it only looking at certain document types or are there any other limitations.
Thanks,
Janet
Posted : September 24, 2013 7:52 am
Not seeing a test patient is very likely given the selection criteria:
{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"
The report specifically tries to exclude test patient with the line in bold above.
Posted : September 24, 2013 10:00 pm
I have attached our version of this form. Feel free to post questions if you have any.
Hope this is helpful to you!
Posted : October 8, 2013 2:58 pm
Thank you so much for sharing. When I try to run it in Oracle 9.5 it asks for a groupname which I do not have and then I get an error.
When I try to run it in CPS 11 I get an error source message.
What version are you using this report in?
thanks!
Posted : October 9, 2013 2:21 am
Has anyone made a similar report that works with SQL?
Hopeful that someone has!
Rebecca
Posted : October 15, 2013 2:06 am
I am looking for this exactly! Did you ever find anything? If so, do you think you could kindly send it to my email? [email protected]
Posted : June 6, 2016 9:38 am
Did you ever end up finding one? I am looking for the same thing.
Posted : June 6, 2016 9:41 am
Page 2 / 2
Prev
