Adding Charts

- Adding Charts - -It is possible to add charts to reports. In the example below, we will make a chart comparing the ANC Coverage among organisation units. We start by dragging a "Chart" element from the "Palette" onto the report. - - - Drag a Chart element to the report - - - - - - - -A new window appears where we can choose chart type. In this example, we use a regular bar chart. Click "OK", and then "Finish" on the next screen. - - - Select a chart type - - - - - - - -We have now added the chart and can place it at the desired position on the screen. However, we have not yet added any data. To do this, we start by right clicking on the chart and selecting "Chart Data" - - +

ChartsThe auto-generated report comes shipped with a chart within. This can however be edited. To do that, right-click on the chart and select "Chart Data". Select Chart Data by right clicking on the chart - - -Choose the "Details" tab, then click "Add". - - + Go to the "Details" tab to see what is actually shown in the chart. + Go the Details and Add a Category series - - -A new window will appear, where we can add the actual data series. There are four fields that we can fill out, where the three first are mandatory. - - + If you select a series and then click the "Modify" button, a new window will appear. There are four fields that we can fill out, where the three first are mandatory and are already automatically filled. + The Category series window - - -In our example, we want to create a bar chart with organisation units along the category/x-axis, and the ANC coverage indicator value along the value/y-axis. The "Series Expression" is not relevant for this, so we only put in an empty quote. To add the organisation units to the "Category expression", we click the edit-button. - - + You can edit each field by pressing the edit button on the right: Edit the category expression - - -A new window appears with the available fields. We double click on "organisationunitname", which will automatically create the desired expression. Then click "Apply". - - + A new window appears with the available fields. A list of available fields to put in the chart will show. If you double-click one of the items, it will be added to the Expression editor. + Double click on the desired field - - -We do the same for "Value expression", this time clicking on "anc_coverage_reporting_month" instead. - - - Double click on the desired field - - - - - - - -Our table should now look like the one below, with all the required fields filled out. Click "OK" and then close the "Chart details" window. - - - Close the window the the required expressions are filled - - - - - - - -Use "Preview" to check that the chart is displayed with the correct values. - - + To make the chart more informative and better looking, we can select it by clicking on it and use the "Properties" panel on the right hand side to make adjustments. For example, you can add a title to the chart, change the font, rotate the axis labels (as shown below) and so on. - - + Edit the chart properties - -

Adding the Report to DHIS 2 - -To use the report we have created as a Standard Report in DHIS 2, we must first prepare the file in iReport and then upload the file to DHIS 2. - - -The first step is to correct the expression language of the report to a format DHIS 2 understands. We do this by clicking on the report in the "Report Inspector", and then changing the "Language" property to Java. - - - Set report language to Java - - - - - - - -Next, we must change the file format of the report from .jrxml to .xml. We do this by selecting "File -> Save As..." and simply replacing .jrxml with .xml in the file name. Then click "Save". - - -We can now switch to DHIS 2 and import our report. Enter the Report Module in DHIS 2, and select "Standard Report". In the "Standard Report" screen, click "Add new". - - -In the following screen, there are several actions we need to take. First, enter a name for the new "Standard Report". Second, for design, click "Choose File" and find the .xml-file we created in iReport. Then, we select the report table that we used as a basis for the report in iReport. In our case, that was the "Outpatient" table. Click add, and it should move to the "Selected report tables" area. Finally, click save. + To use the report we have created as a Standard Report in DHIS 2, we must first prepare the file in iReport and then upload the file to DHIS 2. + + We must change the file format of the report from .jrxml to .xml. We do this by selecting "File -> Save As..." and simply replacing .jrxml with .xml in the file name. Then click "Save". + + We can now switch to DHIS 2 and import our report. Go to the Report Module in DHIS 2, and select "Standard Report". In the "Standard Report" screen, click "Add new", or edit an existing one. + + In the following screen, there are several actions we need to take. First, enter a name for the new "Standard Report". Second, for design, click "Choose File" and find the .xml-file we created in iReport. Then we select the report table that we used as a basis for the report in iReport. Click add, and it should move to the "Selected report tables" area. Finally, click save. Upload the file and choose the right report table @@ -689,8 +604,7 @@ - -The report is now available as a "Standard Report" in DHIS 2. + The report is now available as a "Standard Report" in DHIS 2. The report is available as a Standard Report @@ -705,7 +619,7 @@ Some final guidelines - Use the same version of IReport and DHIS 2's version of Jasper reports. See the About page in DHIS 2 for the Jasper version in use. + Use the same version of iReport and DHIS 2's version of Jasper reports. See the About page in DHIS 2 for the Jasper version in use. Use report tables with cross tab dimensions as your data source for your report designs. This will make it a lot easier to design reports where you need to put specific indicators, periods, or orgunits on columns. === modified file 'src/docbkx/en/resources/images/dhis2_creating_reporting/ireport/33_editchart_2.jpg' Binary files src/docbkx/en/resources/images/dhis2_creating_reporting/ireport/33_editchart_2.jpg 2011-02-24 07:41:08 +0000 and src/docbkx/en/resources/images/dhis2_creating_reporting/ireport/33_editchart_2.jpg 2011-03-29 13:28:45 +0000 differ