Reporting Module

Building Report

Intelehealth uses in -built functionality in OpenMRS to create reports using the Reporting Module. Read more detailed information about the Reporting Module on the OpenMRS Wiki.

You can create a report by following these 3 steps.

Step 1. Build Data Set Definition

Step 2. Build Report

Step 3. Add Data Set to Report

Step 1. Build Data Set Definition

Step 1.1: Click 'Advance Administration' inside System Administration.

Step 1.2: Under 'Manage Report Definitions', click 'Data Set Definitions'.

Step 1.3: Click the plus sign next to SQL DataSet to add a new custom query.

Step 1.4: Under 'Name', input the title of your Data Set, so that you can find it later. You can type a more detailed description under 'Description.'

Step 1.5: Write your sql query in the yellow box provided.

Step 1.6: Hit 'Save'.

Note: If we select 'endDate' parameter in our SQL query we have to add an additional day to it by following this syntax:

DATE_ADD(:endDate, INTERVAL 1 DAY)

Why we need this to do manually?

This is because the 'endDate' parameter return till '00HH:00MM:00SS'. This leads in losing the whole day data so we have to add it manually until OpenMRS community finds a solution to it.

talk.openmrs.org/t/how-to-add-whole-day-in-reporting-module-enddate/19966

Step 2. Build Report

Step 2.1: Click 'Report Administration' under 'Manage Report Definitions'

Step 2.2: Click 'Custom Report (Advanced)'.

Step 2.3: Enter the name of your report under 'Name.' You can enter a more detailed description in the 'Description' text-box. Then click 'Submit.'

Step 3. Add Data Set to Report

Step 3.1: In the Report Editor, click the plus sign under Data Set Definitions to add a new data set .

Step 3.2: In the 'Key', enter an appropriate label for your Data Set. Under 'Data Set Definition,' select the name of the data set you created in Step 1 . Then click submit.

Step 3.3: In this stage, you may add parameters to the Report, such as Start Date, EndDate, and Location. (optional)

To create Output design (Optional)

OpenMRS by default output report in web preview. But we can customize it to 8 more templates(Excel, HTML, XML etc) provided by OpenMRS. We can achieve this by following these steps.

Step 1. Click 'Administration' from the main toolbar.

Step 2. Click 'Report Administration' under 'Manage Report Definitions'

Step 3. Select your Report and under action click on edit icon.

Step 4. Under 'Output Design' select the prefer output format(you can add multiple Output for a single report).