Sorting

- Sorting - Often you will be making reports where the first column is organisation unit names. However, it can be a problem that the list of organisation units are not sorted alphabetically. This can be fixed in iReport through a few simple steps. - In the report inspector, right click on the name of the report (by default this is dpt) and select Edit query. - - Choose Edit Query - - - - - - - A Report query window will appear. Click on the Sort options button. - - Choose Sort Options... - - - - - - - A Sorting window as show below will appear. Here, we can add our sorting options. Click the Add field button. Another small window will show up, with a drop down menu where you can choose Sort by organisationunitname to have the table sorted alphabetically by name. - - Choose Add - - - - - - - - Choose sort parameter - - - - - - - Click OK - Close - OK to close the three windows. The table should now be sorted. -

Changing indicator/data element names By default, the reports from DHIS 2 uses the short names for indicators and data elements in reports and charts. In some cases these are not always very meaningful for third parties, but with some work they can be given custom names through iReport. This is useful for example if you are making a report with indicators as rows and periods as column, or for charts with indicators.