Notifications
Clear all
Topic starter
Every week I have to run 6 or 7 inquiries from the Chart Reports section, and I have to run each of those inquiries 6 times with a different variable. Is there any way I can automate this with a script or something that will export the info into a csv or excel file? I believe I could get the same info from the SQL database, but is that the only way?
Posted : November 10, 2015 8:24 am
Hi DJ,
yes, the only way to do this is to either build a custom reporting application, or use a third party that will run your sql scripts to get your data based on a job/time you set. I have created custom applications for many offices that require this, and have the results sent to their email address or saved into a shared folder. Unfortunately, GE doesn't have this type of feature embedded into CPS or EMR.
Posted : November 10, 2015 9:21 am
Topic starter
Ah, ok. Thanks for your reply. I was hoping that wasn't the case, but I kinda figured it would be. When you say build a custom application, do you mean building and compiling it from scratch? In C or some other code?
Posted : November 10, 2015 9:27 am
Well, there are many ways of doing this, you can use the Report Services in SQL, I personally like building custom application in C# which I configure to create an excel spreadsheet. I have about 4 offices that run reports on a nightly basis to meet PCMH and MU.
Posted : November 10, 2015 9:32 am
Topic starter
That makes sense. I don't really have time to mess with writing an application, but maybe in the next few weeks I'll be able to come up with something. Thanks for your input!
Posted : November 10, 2015 9:44 am
