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

Adding Medications to a Crystal Report

General Discussion

Last Post by kmarsh 8 years ago

5 Posts

4 Users

0 Reactions

63 Views

RSS

kmarsh

(@kmarsh)

Posts: 85

Estimable Member

Topic starter

I have a CR that totals the CHAD score and it seems to be working fine. Now, I want to add 2 columns - one that would indicate is some way (Y, N) whether or not the patient was on Warfarin/NOAC and a second column that would indicate whether or not the patient is on Plavix/Brillinta. I've tried this by adding the MEDICATE_CHAIN table and because that didn't work, by adding the MEDICATE and MEDINFO tables. But I've got something wrong - the report runs for 10-15 minutes and then returns an error - "Failure to retrieve data from the database." and then another one 'unable to to extend temp segement by 128...". I'm way off track. Can some one help?
Thanks

Posted : April 18, 2017 8:47 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Contact me directly and I will show you how to solve this problem. Basically, the approach uses the initial digits of the GPI field to establish if the are on Warfarin/NOAC, Plavix/Brillinta.

Posted : April 18, 2017 9:44 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Would recommend adding a SubReport to your existing detail line (assuming the patient listing is currently printed at the detail line level.)

The SubReport would link via PERSON.PID to MEDICATE and then to the MEDINFO tables.

And then in the SubReport a variable to see if the medication in on the med list for the patient.

Be happy to go into more detail, or attach your report here and it can be augmented.

Posted : April 19, 2017 1:29 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

For complicated reports like this, it is usually easier to write the SQL code you need and then create a custom view or use Crystal Reports database "Commands".

If you need examples of either let me know and I can supply you with some.

Posted : April 20, 2017 3:00 am

kmarsh

(@kmarsh)

Posts: 85

Estimable Member

Topic starter

Thank you to all who replied. Using SubReports (I needed 2) worked.

Posted : April 26, 2017 7:31 am

Share:

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