Designing new reports in EMR

anamar-ippf wrote on Wednesday, September 26, 2007:

Is there any other tool/add-on that helps to design other reports that the sytem has not already includes? Our clinics have very specific needs of reports, i.e. crossing tables for services delivered by age group of clients. How can I prepare those reports? or just by queries?

Thanks!

andres_paglayan wrote on Wednesday, September 26, 2007:

SQL queries are the most effective and fast way, if you know SQL language,
so there’s a step learning curve implied if not.

Using phpmyadmin lets you visualize the tables and see what’s up,
you can also link to the tables on the server using the free suite openoffice
and run their database query tool, (kinda MS access graphic tool)
entry-level dba skills required,

Worst case scenario, Crystal reports can as well link to MySQL and provides a nice
(although no free nor open source) gui,
again, entry-level dba skills and some crystal training.

andres_paglayan wrote on Friday, September 28, 2007:

check
http://datavision.sourceforge.net
http://www.freereporting.com

markleeds wrote on Sunday, September 30, 2007:

I will soon upload some of my reports to contrib so you can use them as a starting point.