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 1 / 2 Next

Trading Post

Last Post by Anonymous 1 second ago

28 Posts

12 Users

0 Reactions

200 Views

RSS

lmcmillen

(@lmcmillen)

Posts: 7

Active Member

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 Cry

Posted : June 20, 2012 11:32 pm

Sirna

(@sirna)

Posts: 384

Honorable Member

Did you ever get a response to this? We are looking for something like this as well.

Posted : June 19, 2013 3:13 am

ganewman

(@ganewman)

Posts: 25

Eminent Member

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

Sirna

(@sirna)

Posts: 384

Honorable Member

We are still looking for this if you would be willing to share!

[email protected]

Posted : August 6, 2013 10:15 pm

mbellis

(@mbellis)

Posts: 293

Reputable Member

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

cisaac

(@cisaac)

Posts: 33

Trusted Member

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

cisaac

(@cisaac)

Posts: 33

Trusted Member

my e-mail is [email protected]

Posted : September 8, 2013 11:23 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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!

[email protected]

Thanks!

Posted : September 10, 2013 1:55 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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).

M100MedsPrescrib.rpt

Posted : September 10, 2013 11:22 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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).

M100MedsPrescrib.rpt

Thanks so much!

Posted : September 11, 2013 1:56 am

redde

(@redde)

Posts: 115

Estimable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

redde

(@redde)

Posts: 115

Estimable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

redde

(@redde)

Posts: 115

Estimable Member

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

24 Forums
9,940 Topics
39.9 K Posts
0 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