A proposed future version of OpenEMR, the design of which has just begun, will not include PhpMyAdmin as part of the package. I am considering a replacement for the PhpMyAdmin functionality which supported user-defined reports. One such package is PM Report (http://linux.softpedia.com/get/Database/Administrative-frontents/PM-Report-3092.shtml)
If you have a favorite report generator for MySQL, written in php, without any licensing restrictions, I invite you to suggest it for inclusion.
The program mentioned in the link is merely an example for the sake of discussion - it would have to be heavily modified and expanded to meet the needs of OpenEMR. If you already have a favorite report generator, other than PhpMyAdmin, let me know. I am trying to find out what others *already* use, if anything.
FreeMED uses Agata Reports with some success. The ar e a PHP-GTK based solution. You develop your reports in the PHP-GTK interface but once they are developed you can call them from a web interface.
Uversa has developed a powerful reporting solution in-house called phReporting. It is intereseting because it allows web based output. I have used it to successfully replicate current paper reports, with lots of pretty formating.
The other interesting thing about phReporting is that it is a two way web interface, so you can get a report that can easily be output into a slick pdf, but that report has select boxes for limiting the results of the report. Of course, it uses Smarty for layout…
Thanks. Agata Reports looks very interesting. However, I am looking for a server-based tool, which allows report design, administration, and execution through a html interface. Any tool selected will be modified somewhat to meet the specific requirements of OpenEMR. Smarty is being deprecated for the proposed release, and will eventually be eliminated.