Notifications
Clear all
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
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
