# Reports in OpenMRS

**URL:** <https://talk.openmrs.org/t/reports-in-openmrs/23567>\
**Category:** GSoC\
**Created:** [June 13, 2019, 2:12pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567 "2019-06-13T14:12:28Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![haripriya](https://talk.openmrs.org/user_avatar/talk.openmrs.org/haripriya/32/10799_2.png) [@haripriya](https://talk.openmrs.org/u/haripriya)\
**Post date:** [June 13, 2019, 2:12pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/1 "2019-06-13T14:12:28Z")

</div>

What is the functionality of Reports in OpenMRS? On clicking the Reports tab in the home page, I don’t see any information being displayed.

 ![Screenshot%20(188)](https://talk.openmrs.org/uploads/default/original/2X/f/f9995a441b794c69e3b51ef2464454254a62d47e.png)

 ![Screenshot%20(189)](https://talk.openmrs.org/uploads/default/original/2X/9/933b8fd80c291fbefa26f314461b6053b00091ad.png)

Can I consider, to include the functionality of exporting data as .csv file using reports?

Thank you 🙂

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [June 13, 2019, 2:36pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/2 "2019-06-13T14:36:24Z")

</div>

@haripriya it depends on the use case, i wonder if you can generate a report without sample data.

Have you taken a look at [Generating Reports](https://wiki.openmrs.org/pages/viewpage.action?pageId=19300405)

---

<div class="post-metadata">

**Author:** ![haripriya](https://talk.openmrs.org/user_avatar/talk.openmrs.org/haripriya/32/10799_2.png) [@haripriya](https://talk.openmrs.org/u/haripriya)\
**Post date:** [June 13, 2019, 3:31pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/3 "2019-06-13T15:31:47Z")

</div>

Thank you for linking the resource. 🙂 But what is the use of having reports when its blank? And Do I consider to export condition list data using reports, or is there some better way that the community would prefer to export data instead of reports?

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [June 14, 2019, 6:43am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/4 "2019-06-14T06:43:20Z")

</div>

Am not sure i get you well ,

> [@haripriya](#):
>
> But what is the use of having reports when its blank?

But like i said you generate reports basing on either demo Data which OpenMRS can generate /imported data or data generated by user.

---

<div class="post-metadata">

**Author:** ![ball](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ball/32/277_2.png) [@ball](https://talk.openmrs.org/u/ball)\
**Post date:** [June 18, 2019, 10:53pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/5 "2019-06-18T22:53:23Z")

</div>

I would expect that the RefApp would have preloaded reports on the “Reports” page, but as @haripriya wrote – the the RefApp demo server only shows a blank page.

PIH has all these reports on our “Reports” page – which is a customized distribution.

 ![image](https://talk.openmrs.org/uploads/default/original/2X/4/4233d5baa76f142ebc3b6840a5e4b223778ead99.png)

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [June 19, 2019, 5:47am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/6 "2019-06-19T05:47:34Z")

</div>

@haripriya does @ball 's observation suggest any help for you ?

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [June 19, 2019, 7:08am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/7 "2019-06-19T07:08:56Z")

</div>

@ssmusoke do you have some reports under that button in UgandaEMR?

---

<div class="post-metadata">

**Author:** ![ssmusoke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ssmusoke/32/8020_2.png) [@ssmusoke](https://talk.openmrs.org/u/ssmusoke)\
**Post date:** [June 19, 2019, 7:18am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/8 "2019-06-19T07:18:38Z")

</div>

@dkayiwa @haripriya I think the Ref App reports moved to an OWA - Prebuilt reports - not sure if it is packaged with the distribution

The UgandaEMR reports approach is:

1. Override the reports page - [https://github.com/METS-Programme/openmrs-module-ugandaemr-reports/blob/master/omod/src/main/webapp/pages/reports.gsp](https://github.com/METS-Programme/openmrs-module-ugandaemr-reports/blob/master/omod/src/main/webapp/pages/reports.gsp)

2. Define the reports as app links here [https://github.com/METS-Programme/openmrs-module-ugandaemr-reports/blob/master/omod/src/main/resources/apps/ugandaemr\_reports\_app.json](https://github.com/METS-Programme/openmrs-module-ugandaemr-reports/blob/master/omod/src/main/resources/apps/ugandaemr_reports_app.json)

@solemabrothers can provide links to how to generate reports as CSV

---

<div class="post-metadata">

**Author:** ![solemabrothers](https://talk.openmrs.org/letter_avatar/solemabrothers/32/5_5575768a8748004e209b776fc1b2916d.png) [@solemabrothers](https://talk.openmrs.org/u/solemabrothers)\
**Post date:** [June 19, 2019, 12:27pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/9 "2019-06-19T12:27:16Z")

</div>

@haripriya @dkayiwa we have been able to deploy reports in UgandaEMR in both formats excel and CSV, however, the default is excel, @haripriya please let us know on how we can help to share the knowledge we have used

---

<div class="post-metadata">

**Author:** ![sharif](https://talk.openmrs.org/user_avatar/talk.openmrs.org/sharif/32/11982_2.png) [@sharif](https://talk.openmrs.org/u/sharif)\
**Post date:** [June 19, 2019, 1:01pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/10 "2019-06-19T13:01:38Z")

</div>

Thanks for that great work. j think the same idea can be used in the ticket issued on the support of exporting openmrs data using Fhir appointment resources.

---

<div class="post-metadata">

**Author:** ![haripriya](https://talk.openmrs.org/user_avatar/talk.openmrs.org/haripriya/32/10799_2.png) [@haripriya](https://talk.openmrs.org/u/haripriya)\
**Post date:** [June 20, 2019, 5:38pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/11 "2019-06-20T17:38:06Z")

</div>

@ssmusoke Thank you for the resources, It would be very helpful. 🙂 @solemabrothers could you please provide me the link of how to generate reports as CSV, Thank you 🙂

---

<div class="post-metadata">

**Author:** ![solemabrothers](https://talk.openmrs.org/letter_avatar/solemabrothers/32/5_5575768a8748004e209b776fc1b2916d.png) [@solemabrothers](https://talk.openmrs.org/u/solemabrothers)\
**Post date:** [June 21, 2019, 7:28am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/12 "2019-06-21T07:28:46Z")

</div>

@haripriya please find herein the link to one of the CSV exports in our reports [https://github.com/solemabrothers/openmrs-module-ugandaemr-reports/blob/3e7725dca50fce3cfa6e6fb94b79bb37f1dab632/api/src/main/java/org/openmrs/module/ugandaemrreports/reports/SetupANCRegister.java#L73](https://github.com/solemabrothers/openmrs-module-ugandaemr-reports/blob/3e7725dca50fce3cfa6e6fb94b79bb37f1dab632/api/src/main/java/org/openmrs/module/ugandaemrreports/reports/SetupANCRegister.java#L73) let me know how i can guide you through the process

---

<div class="post-metadata">

**Author:** ![haripriya](https://talk.openmrs.org/user_avatar/talk.openmrs.org/haripriya/32/10799_2.png) [@haripriya](https://talk.openmrs.org/u/haripriya)\
**Post date:** [June 21, 2019, 11:03am UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/13 "2019-06-21T11:03:32Z")

</div>

Thank you @solemabrothers . I will let you know if i get stuck in the process 🙂😀

---

<div class="post-metadata">

**Author:** ![haripriya](https://talk.openmrs.org/user_avatar/talk.openmrs.org/haripriya/32/10799_2.png) [@haripriya](https://talk.openmrs.org/u/haripriya)\
**Post date:** [June 22, 2019, 4:56pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/14 "2019-06-22T16:56:52Z")

</div>

Currently as there is no functionality in Reports, should I add data export functionality for condition list in reports tab or can we have this functionality as an extension of existing condition list UI? I personally feel it would be much effective if we can have Data export button next to Add new condition button. When the user clicks on the data export button, they will be redirected to another screen where data is downloaded based on some criteria.

---

<div class="post-metadata">

**Author:** ![solemabrothers](https://talk.openmrs.org/letter_avatar/solemabrothers/32/5_5575768a8748004e209b776fc1b2916d.png) [@solemabrothers](https://talk.openmrs.org/u/solemabrothers)\
**Post date:** [June 22, 2019, 5:10pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/15 "2019-06-22T17:10:50Z")

</div>

@ssmusoke and @dkayiwa can probably guide on this, the good thing is you have seen our implementation in UgandaEMR of data exports

---

<div class="post-metadata">

**Author:** ![ball](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ball/32/277_2.png) [@ball](https://talk.openmrs.org/u/ball)\
**Post date:** [June 24, 2019, 3:15pm UTC](https://talk.openmrs.org/t/reports-in-openmrs/23567/16 "2019-06-24T15:15:59Z")

</div>

@haripriya About data export from condition list page. Definitely no. That page is specifically about that patient, not all patients.

We do not allow data export from a clinician-facing patient page. Data exports are only for a subset of users (ie. data manager, researchers). We don’t allow clinical users to generate a list of patients.
