Notifications
Clear all
Topic starter
Would anyone like to share how they are exporting reports ran out of the EMR, to a format that can be manipulated, such as Excel? Any other suggestions of how to obtain more flexible data than writing numerous inquiry reports and sorting them manually?
Posted : March 19, 2014 3:07 am
The GE EMR allows for the use of custom-designed Crystal Report definitions. Crystal is a commercial product that is a report writing tool that will work with GE data, as well as data from many other kinds of computer programs (I say this because the skillset is not unique to GE; the tables are, but the use of the Crystal tool is something many more may know of.)
I export many of my Crystal Reports (for GE) in Excel, and then do more manipulation and linking with Excel.
What are you trying to accomplish?
Posted : March 19, 2014 3:59 am
ChrissieS said:
Would anyone like to share how they are exporting reports ran out of the EMR, to a format that can be manipulated, such as Excel? Any other suggestions of how to obtain more flexible data than writing numerous inquiry reports and sorting them manually?
Hi Chrissie,
You can preview the report from Centricity, then click the export icon located in the upper left. From there you can choose the Excel format. I can do a short online meeting with you if you would like me to walk you through this. [email protected]. There is also another product you can purchase called Centricity Analytics that pulls info into Excel for you and you can make your own "custom" reports using Pivot Tables and Microsoft Query Wizard. It's not that hard to learn. And, as Joe mentioned, getting custom Crystal Reports is another option.
Posted : March 19, 2014 4:31 am
Topic starter
joeg1962 said:
The GE EMR allows for the use of custom-designed Crystal Report definitions. Crystal is a commercial product that is a report writing tool that will work with GE data, as well as data from many other kinds of computer programs (I say this because the skillset is not unique to GE; the tables are, but the use of the Crystal tool is something many more may know of.)
I export many of my Crystal Reports (for GE) in Excel, and then do more manipulation and linking with Excel.
What are you trying to accomplish?
WE can export these from the PM side of things to Excel, easily, but it is the EMR inquiry reports that are the issue.
Posted : March 19, 2014 4:52 am
I always use Crystal Reports. However, since you asked...
1) Define your query rules
2) Click the SEARCH and then PRINT buttons, then click PREVIEW
3) Top left is a little icon (looks like disc and piece of paper), click that
4) Then choose on the dropdown (default might be Adobe) for Excel; be cautious about choosing 'data only' here as it will combine all fields into one.
5) Pick filename and destination
You will now have an Excel file. Beware, there may be multiple lines per data record to deal with. Or, you could choose the 'data only' option and then do some string manipulation within Excel.
Posted : March 19, 2014 5:04 am
