Creating Reports

Day-to-Day Users
1

aperezcrespo wrote on Sunday, April 25, 2010:

Hi

Can someone point out a nice simple WYSIWYG or GUI PHP Report generator.  And if reports are placed in reports/myreports   where would they show up (assuming this is the right place to put them in)?

Thanks

2

tmccormi wrote on Sunday, April 25, 2010:

Been looking for one one of those in the OpenSource world for a while, no luck so far.  There is talk about creating a ‘plug and play’ reporting framework, but not action just yet.  It’s one of the desired goals of new release (4), but no volunteers to develop it just yet.

Tony

3

ozyus wrote on Thursday, July 21, 2011:

Or even maybe a little tutorial from start to finsh for those of use willing to get our hands dirty. I undersand how to navigate the database, i even understand SQL, a little html… and so on. … i jsut dont have time to learn javascript,PHP, and style sheets from scratch… if there was a walk through… and maybe ive jsut missed it…  Being able to create a report that replicates what my Doctors office is hand writing would be really great.  Thanks for your help!!
Trae

4

drmarty wrote on Friday, July 22, 2011:

We are using a report generator created in conjunction with a Note generator made for me by ZH Services. You could contact Sam at ZH Services, this is his email sam@zhservices.com, if memory serves and he can get you into a demo I imagine. I have authorized him to contribute the note maker module called Nations Notes or somesuch to the community at least from the perspective of what I have paid for and helped develop. ZH did what we consider a great job so far. I think the community can help with things like making some needed changes to the Report/Letter/Referral portion as I was/am concentrating on the note generating portion. It was a huge project, at least from my perspective.

I hope this helps.

DrMarty

5

ozyus wrote on Friday, July 22, 2011:

Thanks DrMarty… I will concider contacting him if this latest discovery doesnt produce the results we need. If it does i will post the procedures here and recoment them be added to the wiki.

Anyone with further input is also very much welcome to chime in.

6

drmarty wrote on Friday, July 22, 2011:

Sorry, I seem to be lost. What “latest discovery” are you talking about?

DrMarty

7

ozyus wrote on Friday, July 22, 2011:

My apologies on not making that clear. I am waist deep in learning how to create and manipulate PHP and Style sheets…  While I’m not what you would consider a web developer i am learning my way through the tutorials on basic PHP and the trying different changes in our test server OPEN EMR.  The results are slow and painful but At this point I feel like I’ll get this figured out within a reasonable amount of time. Once I do… I’ll go back through my notes, consolidate, and try to piece together instruction on how to use a few free tools to do the reporting…  I’m Windows guy by default… so all this Linux, MySql, and other things are learning curves for me too… but having a good MS SQL background, my experience with reporting from that side is making it easier to connect the common elements. Anyway… you didn’t ask for a life story…  I’ll try to post my process quickly and some instructions on reporting soon. In theory its simple… query the data base for data in specific fields… print them to web or paper…   it’s all the little details that make it seem so complex.

Trae

8

verbus wrote on Tuesday, June 12, 2012:

Greetings,

We are also looking for a reporting tool. Any recommendations?

Regards,
Verbus Counts
EMR Technical Solutions, LLC
http://www.emrtsolutions.com
405-326-7440

9

tmccormi wrote on Wednesday, June 13, 2012:

We’ve been using Pentaho Report Designer (Community Version on sourceforge,net).  IPPF uses this as well, it a Java  Client that used JDBC connection to any database.  Has a Crystal Reports style graphical report layout designer.
-Tony

10

kodusote wrote on Wednesday, June 13, 2012:

Glad that this has come up and there is some progress.  For those not in public health sector that desire to get the most out of OpenEMR, a reporting tool is a great need.  Does the Pentaho Report Designer need a steep learning curve for non-IT users.  Is incorporate a reporting tool into OpenEMR still a goal for a release in the near future?

11

kevmccor wrote on Wednesday, June 13, 2012:

I’m commenting a lot today.  How about the idea of writing a quality php script that just retrieved the data from the database and allowed it to be accessed in an output array?  Maybe a function such as:

function report_data($type, $begin_date, $end_date, [other parameters] ) 
{
    ... call other functions with sql for the $type ...
    ... assemble sql results into array ...
   return data_array;
} 
function data_to_format($data_array, $format)
{
   ... code to format $data_array as csv, xml, json, etc. ...
  return $formatted_data;
}

If your $data_array is documented, then a javascript whiz could code the interface.  If someone else wants another type of report, they can add the functions to create that.  Just writing that php script will take a good while, so IMHO, it is worth dividing the process into chunks and involving others, making it easy for them to use your script.