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

Complex Crystal report crashes EMR

Trading Post

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

136 Views

RSS

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Topic starter

I created a new crystal report which I have added a few more "complex" features in it such as Crystal Reports SQL Commands, and a hyperlinked subreport with SQL Commands (a fairly complex one) and SQL Command parameters. The report works great on my PC in crystal 11.5 but it tends to crash emr. Sometimes it crashes when running the report before the parameters are selected, sometimes it crashes after the parameters are selected and before the report displays and most recently it crashes when closing the report. When it crashes, generally emr completely locks up and ends up having to be force closed.

Any ideas what could be causing this?Are there certain things that I need to avoid in my report? Maybe I need to move some of the functionality into a SQL View instead of a Crystal SQL Command? I do not have crashing on any other reports that I am aware of.

Posted : October 6, 2014 5:02 am

mmeerian

(@mmeerian)

Posts: 25

Eminent Member

Late response but I've seen a similar issue when I didn't make the SQL queries the way that the cEMR 'liked' them. Here's one below where I had to specify the specific location.

SELECT
OBS."OBSDATE",OBS."OBSVALUE",PERSON."LASTNAME",PERSON."FIRSTNAME"
FROM
(("ML"."OBS" "OBS"
INNER JOIN "ML"."PERSON" "PERSON" on "OBS"."PID"="PERSON"."PID")
INNER JOIN "ML"."RELPROV" "RELPROV" on "PERSON"."PID"="RELPROV"."PID")

Posted : February 11, 2015 7:31 am

Share:

24 Forums
9,942 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.1