Reporting

Reporting with OpenMRS

TODO: Restructure this page, separating out the different reporting frameworks - cohort report designer, Birt Reporting, etc.

Quick summary of what was done to get reporting up and running in Kenya with the cohort report designer and Excel-based report templates:

1. Install cohort_report_designer branch
2. Install versionfileupload and reporttemplate modules. (Reporttemplate module currently requires building from source.)
3. Create a cohort in the cohort builder. Put some parameters in the cohort like a begin date and end date.
4. In Administration --> Manage Reports create a cohort report.
5. On the Indicators tab, Add an indicator by choosing from the list of cohorts on the right. (There should be a list of cohorts on the right after you make them in the cohort builder.)
6. For the indicator, use an expression prefix and expression postfix. For example, if you want the indicator name to be 1.A, put @1.A@ in the indicator box. Put whatever for the description.
7. Go to Administration --> Manage Patient Searches. Find the Cohort you made and manually edit the begin date and end date from step #3 above. Put something like "$begin_date$" and "$end_date$" in place of the real dates.
8. Go back to the Manage Reports section to your cohort report. Go to the Parameters tab. For the Name of the first parameter, put "begin_date" (without the dollar signs if I remember correctly). Put something human readable for the Display Label like "Report Start Date".
9. Make another parameter for end_date.
10. Create a Microsoft Excel spreadsheet and fill it with indicators like "@1.A@". Save it.
11. For the Report Templates tab, upload the file and make sure to put in the expression prefix and postfix ("@" in this example).
12. Take out the @'s from the Name field of the Indicator section.
13. Run the report.

That's it to the best of my recollection at the moment. Hope it helps some. In Kenya we are running database version 1.3.0.15.