=== modified file 'src/docbkx/en/dhis2_user_man_creating_reporting.xml'
--- src/docbkx/en/dhis2_user_man_creating_reporting.xml 2012-11-15 11:21:48 +0000
+++ src/docbkx/en/dhis2_user_man_creating_reporting.xml 2013-03-14 16:42:29 +0000
@@ -1177,8 +1177,8 @@
Designing SQL based standard reports
- A standard report might also be based on SQL queries. This is useful when you need to
- access multiple tables in the DHIS database and do custom selects and joins.
+ A standard report might be based on SQL queries. This is useful when you need to access
+ multiple tables in the DHIS database and do custom selects and joins.
- This step is optional, but handy when you need to debug your reports and when you have
direct access to the database you want to use. Click on the "report datasources" button,
"New", "Database JDBC connection" and click "next". In this window you can give you
@@ -1254,5 +1254,69 @@
parameters. Click save. This will redirect you to the list of reports, where you can click
the green "create" icon next to your report to render it.
+
+ Designing HTML based standard reports
+ A standard report can be designed using purely HTML and Javascript. This requires a
+ little bit of development experience in the mentioned subjects. The benefit of HTML based
+ standard reports is that it allows for maximum flexibility. Using HTML you can design
+ exactly the report you want, positioning tables, logos and values on the page acccording to
+ your design needs. You can write and save your standard report design in a regular text
+ file. To upload your HTML based standard report to DHIS 2 do the following:
+
+
+ Navigate to standard reports and click "Add new".
+
+
+ Give the report a name.
+
+
+ Select "HTML report" as type.
+
+
+ If you want to you can download a report template by clicking on "Get HTML report
+ template".
+
+
+ Select desired relative periods - these will be available in Javascript in your
+ report.
+
+
+ Select report parameters - these will be available in Javascript in your
+ report.
+
+
+ The report template, which you can download after selecting report type, is a useful
+ starting point for developing HTML based standar reports. It gives you the basic structure
+ and suggests how you can use Javascript and CSS in the report. Javascript and CSS can easily
+ be included using standard script and style tags.
+ If you selected relative periods when creating the standard report you can access these
+ in Javascript like this:
+ var periods = dhis2.report.periods; // An array with period identifiers
+var period = periods[0];
+ If you selected the organisation unit report parameter when creating the standard report
+ you can access the selected organisation unit in Javascript like this:
+ var orgUnit = dhis2.report.organisationUnit; // An object
+var id = orgUnit.id;
+var name = orgUnit.name;
+var code = orgUnit.code;
+ When designing these reports you can utilize the analytics Web API resource in order to
+ retrieve aggregated data in Javascript. Have a look in the Web API chapter in this guide for
+ a closer description. As an example you can retrieve analytics data after the report has
+ been loaded and use that data to set the inner text of an HTML element like this:
+ <script type="text/javascript">
+$( document ).ready( function() {
+ $.get( "../api/analytics?dimension=dx:FnYCr2EAzWS;eTDtyyaSA7f&dimension=pe:THIS_YEAR&filter=ou:ImspTQPwCqd", function( json ) {
+ $( "#bcg" ).html( json.rows[0][2] );
+ $( "#fic" ).html( json.rows[1][2] );
+ } );
+} );
+</script>
+ A few other tips: To include graphics you can convert an image to SVG and embed that SVG
+ content directly in the report - DHIS 2 is based on HTML 5 where SVG tags are valid markup.
+ To include charts and maps in your report you can use the charts and maps resources in the
+ Web API. You can use the full capability of the Web API from Javascript in your report - it
+ may be useful to read through the Web API chapter to get an overview of all available
+ resources.
+