Ron,
That was a great report and I used it daily to create a "Fail Safe" in case of a system or network downtime event. We use "CView Server" to schedule and deliver Crystal reports daily and this particular report ran at 2:00am and generated appointment summaries that could be delivered to any of our offices that lost the EMR for an extended period so they could continue to see patients.
We had EMR 9.5 Oracle and as of December 2013, upgraded to CPS 11. Needless to say, the tables have changed substantially in SQL and this report no longer works. Before I dig into the schema, I was curious if anyone has adapted this report to run against SQL? If so, I'd be extremely interested in getting a copy.
Thanks
Michael Shastany
LRGHealthcare
Laconia, NH
Ron,
Could you please send me this report. I tried to download it from this site and I keep getting weird symbols.
Thanks in advance,
Tonya Racine
[email protected]