# Designing new reports in EMR

**URL:** <https://community.open-emr.org/t/designing-new-reports-in-emr/4183>\
**Category:** Day-to-Day Users\
**Created:** [September 26, 2007, 10:16am UTC](https://community.open-emr.org/t/designing-new-reports-in-emr/4183 "2007-09-26T10:16:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 26, 2007, 10:16am UTC](https://community.open-emr.org/t/designing-new-reports-in-emr/4183/1 "2007-09-26T10:16:19Z")

</div>

**[anamar-ippf](https://sourceforge.net/u/anamar-ippf/)** wrote on [Wednesday, September 26, 2007](https://sourceforge.net/p/openemr/discussion/202504/thread/cf01d605/#23e4):

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!

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 26, 2007, 3:32pm UTC](https://community.open-emr.org/t/designing-new-reports-in-emr/4183/2 "2007-09-26T15:32:41Z")

</div>

**[andres\_paglayan](https://sourceforge.net/u/andres_paglayan/)** wrote on [Wednesday, September 26, 2007](https://sourceforge.net/p/openemr/discussion/202504/thread/cf01d605/#23e4/fb63):

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.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 28, 2007, 7:45pm UTC](https://community.open-emr.org/t/designing-new-reports-in-emr/4183/3 "2007-09-28T19:45:19Z")

</div>

**[andres\_paglayan](https://sourceforge.net/u/andres_paglayan/)** wrote on [Friday, September 28, 2007](https://sourceforge.net/p/openemr/discussion/202504/thread/cf01d605/#23e4/fb63/4c12):

check  
[http://datavision.sourceforge.net](http://datavision.sourceforge.net)  
[http://www.freereporting.com](http://www.freereporting.com)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 30, 2007, 12:12am UTC](https://community.open-emr.org/t/designing-new-reports-in-emr/4183/4 "2007-09-30T00:12:51Z")

</div>

**[markleeds](https://sourceforge.net/u/markleeds/)** wrote on [Sunday, September 30, 2007](https://sourceforge.net/p/openemr/discussion/202504/thread/cf01d605/#23e4/0f03):

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