Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Crystal Report to query Medications Provider has prescribed

Page 2 / 2 Prev

Trading Post

Last Post by Anonymous 1 second ago

28 Posts

12 Users

0 Reactions

210 Views

RSS

mbellis

(@mbellis)

Posts: 293

Reputable Member

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

As the creator, I am on Oracle and EMR 9.5

Perhaps some differences in file structure?

Posted : September 12, 2013 12:28 am

mbellis

(@mbellis)

Posts: 293

Reputable Member

Ah, maybe thats our issue. We run SQL. We are on CPS version 11

Posted : September 12, 2013 1:26 am

redde

(@redde)

Posts: 115

Estimable Member

We are on sql, so that is probably the issue.

Posted : September 12, 2013 1:27 am

redde

(@redde)

Posts: 115

Estimable Member

Does anyone have this report or one like it for SQL?

Posted : September 17, 2013 6:28 am

JBell

(@jbell)

Posts: 285

Honorable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I have attached our version of this form. Feel free to post questions if you have any.

ScheduledLists.rpt

Hope this is helpful to you!

Posted : October 8, 2013 2:58 pm

JBell

(@jbell)

Posts: 285

Honorable Member

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

Rebecca B.

(@rebeccabert)

Posts: 130

Estimable Member

Has anyone made a similar report that works with SQL?

Hopeful that someone has!

Laugh

Rebecca

Posted : October 15, 2013 2:06 am

jfhorkan

(@jfhorkan)

Posts: 13

Eminent Member

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

jfhorkan

(@jfhorkan)

Posts: 13

Eminent Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0