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?
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.