Notifications
Clear all
General Discussion
4
Posts
4
Users
0
Reactions
88
Views
Topic starter
Our reports team spends a lot of time not only creating reports for our end-users, but also running them. Up to this point, we have not granted many users access to the "Reports" function in the EMR, for fear it would slow down the system. What do you do? Do you utilize the "Reports" function built into the EMR? Is there a 3rd party solution that works better? We'd like to move towards a "self-service" model, especially since our reports team just keeps getting busier.
Looking forward to hearing how things work at other organizations!
Jennifer Gardner
Posted : June 27, 2013 7:15 am
We use Crystal Reports to write our reports in and we use a combination copy of our production database and Crystal Reports Server to automate report running and delivery.
This was the production database is not slowed down by report writing or running. It works out fairly well.
Posted : June 27, 2013 11:01 pm
We provide 2 options for our users:
1) Data Warehouse with pre-defined reports for the user to run anytime. Most reports allow the user to define timeframes and groupings. The warehouse is updated nightly.
2) Data Warehouse MS Access where our more technical savvy users can build their own queries using the pre-defined tables we have built and published in MS Access.
Right now we don't provide end user access to the [Reports] icon in EMR.
Posted : July 11, 2013 10:58 pm
We have a number of Crystal Reports embedded into the application. As long as you have a 64-bit server, they shouldn't really impact performance in a noticeable way. That's always the first thing we look at when things get 'slow' and I've never really been able to blame a report.
1. You can create a Role within EMR in order to limit access to specific reports. Just note that you can only have 5 Roles(?) on a login.
2. If on Oracle, the Oracle Enterprise Manager can show you the 'top SQLs' or you can run AWRs to check activity. That's what GE looks at.
3. If saving reports onto virtual Citrix servers, make sure you have enough C:\ space if the report compiles a lot of temporary data. We had run into that space issue with the GE CVS MU report.
4. We use both a data-warehouse and reports embedded within EMR. EMR is simpler for 'real-time' reporting and pushing things to end-users which are similar to Inquiries, but for which Inquiries can't quite do (ex: Orders by Practice).
5. Logicity provides a free Crystal Reports runtime program if you want select users to be able to run (but not create) and/or schedule their own reports. You still need the database hooks installed (I use Oracle's InstantClient) but it can run as a Windows scheduled task. Not as good as a full Crystal Reports server, but hey, it's free!
Jim Eppright
Posted : July 14, 2013 11:23 pm
