------------------------------------------------------------ revno: 2157 committer: Lars <larsh...@larshelg-laptop> branch nick: trunk timestamp: Fri 2010-09-17 18:16:32 +0200 message: Added Olas new reports for the new demo database added: resources/jrxml/sl_anc_fixed_outreach_raw_coverage.jrxml resources/jrxml/sl_immunisation coverage-sl.jrxml resources/jrxml/sl_top10_new_cases-sl.jrxml
-- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== added file 'resources/jrxml/sl_anc_fixed_outreach_raw_coverage.jrxml' --- resources/jrxml/sl_anc_fixed_outreach_raw_coverage.jrxml 1970-01-01 00:00:00 +0000 +++ resources/jrxml/sl_anc_fixed_outreach_raw_coverage.jrxml 2010-09-17 16:16:32 +0000 @@ -0,0 +1,256 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="ANC fixed and outreach" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <subDataset name="ANC_coverage"> + <queryString> + <![CDATA[SELECT + _report_anc_coverages.reporting_month_name AS reporting_month_name, + _report_anc_coverages.organisationunitname AS organisationunitname, + _report_anc_coverages.anc_2_coveragea AS anc_2_coveragea, + _report_anc_coverages.anc_1_coveragea AS anc_1_coveragea, + _report_anc_coverages.anc_3_coveragea AS anc_3_coveragea +FROM + _report_anc_coverages]]> + </queryString> + <field name="REPORTING_MONTH_NAME" class="java.lang.String"/> + <field name="ORGANISATIONUNITNAME" class="java.lang.String"/> + <field name="ANC_2_COVERAGEA" class="java.lang.Double"/> + <field name="ANC_1_COVERAGEA" class="java.lang.Double"/> + <field name="ANC_3_COVERAGEA" class="java.lang.Double"/> + </subDataset> + <queryString> + <![CDATA[SELECT + _report_anc_visits_by_fixedoutreach.dataelementname AS dataelementname, + _report_anc_visits_by_fixedoutreach.organisationunitname AS organisationunitname, + _report_anc_visits_by_fixedoutreach.fixed AS fixed, + _report_anc_visits_by_fixedoutreach.outreach AS outreach, + _report_anc_visits_by_fixedoutreach.total AS total, + _report_anc_visits_by_fixedoutreach.reporting_month_name AS reporting_month_name +FROM + _report_anc_visits_by_fixedoutreach]]> + </queryString> + <field name="DATAELEMENTNAME" class="java.lang.String"/> + <field name="ORGANISATIONUNITNAME" class="java.lang.String"/> + <field name="FIXED" class="java.lang.Double"/> + <field name="OUTREACH" class="java.lang.Double"/> + <field name="TOTAL" class="java.lang.Double"/> + <field name="REPORTING_MONTH_NAME" class="java.lang.String"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="6" splitType="Stretch"/> + </title> + <pageHeader> + <band height="57" splitType="Stretch"> + <staticText> + <reportElement x="0" y="25" width="555" height="20"/> + <box bottomPadding="0"/> + <textElement textAlignment="Center"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[No of ANC visits]]></text> + </staticText> + <textField> + <reportElement x="0" y="0" width="555" height="26"/> + <textElement textAlignment="Center"> + <font size="20" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{ORGANISATIONUNITNAME}+" - "+ $F{REPORTING_MONTH_NAME}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="28" splitType="Stretch"> + <staticText> + <reportElement mode="Opaque" x="68" y="0" width="107" height="28" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.25"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center"> + <font size="16" isBold="true"/> + </textElement> + <text><![CDATA[ANC Visit]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="174" y="0" width="100" height="28" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.25"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center"> + <font size="16" isBold="true"/> + </textElement> + <text><![CDATA[Fixed]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="274" y="0" width="105" height="28" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.25"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center"> + <font size="16" isBold="true"/> + </textElement> + <text><![CDATA[Outreach]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="380" y="0" width="105" height="28" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.25"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center"> + <font size="16" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="26" splitType="Stretch"> + <textField pattern="###0"> + <reportElement x="174" y="0" width="100" height="26"/> + <box rightPadding="2"> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{FIXED}]]></textFieldExpression> + </textField> + <textField pattern="###0"> + <reportElement x="274" y="0" width="105" height="26"/> + <box rightPadding="2"> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{OUTREACH}]]></textFieldExpression> + </textField> + <textField pattern="###0"> + <reportElement x="380" y="0" width="105" height="26"/> + <box rightPadding="2"> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{TOTAL}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="68" y="0" width="106" height="26"/> + <box leftPadding="2"> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement> + <font size="12"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{DATAELEMENTNAME}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="271" splitType="Immediate"> + <barChart> + <chart isShowLegend="false"> + <reportElement x="116" y="36" width="306" height="174"/> + <chartTitle> + <font size="18" isBold="true"/> + <titleExpression><![CDATA["ANC coverage (%) by visit for "+$F{ORGANISATIONUNITNAME}+" "+$F{REPORTING_MONTH_NAME}]]></titleExpression> + </chartTitle> + <chartSubtitle/> + <chartLegend/> + </chart> + <categoryDataset> + <dataset> + <datasetRun subDataset="ANC_coverage"/> + </dataset> + <categorySeries> + <seriesExpression><![CDATA["ANC coverage (%)"]]></seriesExpression> + <categoryExpression><![CDATA["1st visit"]]></categoryExpression> + <valueExpression><![CDATA[$F{ANC_1_COVERAGEA}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{ANC_1_COVERAGEA}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["ANC coverage (%)"]]></seriesExpression> + <categoryExpression><![CDATA["2nd visit"]]></categoryExpression> + <valueExpression><![CDATA[$F{ANC_2_COVERAGEA}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{ANC_2_COVERAGEA}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["ANC coverage (%)"]]></seriesExpression> + <categoryExpression><![CDATA["3rd visit"]]></categoryExpression> + <valueExpression><![CDATA[$F{ANC_3_COVERAGEA}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{ANC_3_COVERAGEA}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + </categoryDataset> + <barPlot> + <plot/> + <itemLabel color="#000000" backgroundColor="#FFFFFF"/> + <categoryAxisFormat> + <axisFormat> + <labelFont/> + <tickLabelFont/> + </axisFormat> + </categoryAxisFormat> + <valueAxisLabelExpression><![CDATA["%"]]></valueAxisLabelExpression> + <valueAxisFormat> + <axisFormat> + <labelFont> + <font size="14" isBold="false"/> + </labelFont> + <tickLabelFont/> + </axisFormat> + </valueAxisFormat> + </barPlot> + </barChart> + </band> + </columnFooter> + <pageFooter> + <band height="97" splitType="Stretch"> + <textField> + <reportElement x="455" y="77" width="100" height="20"/> + <textElement/> + <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField pattern="MMMMM dd, yyyy"> + <reportElement x="0" y="77" width="100" height="20"/> + <textElement/> + <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="61" width="100" height="16"/> + <textElement/> + <text><![CDATA[Created]]></text> + </staticText> + </band> + </pageFooter> + <summary> + <band height="12" splitType="Stretch"/> + </summary> +</jasperReport> === added file 'resources/jrxml/sl_immunisation coverage-sl.jrxml' --- resources/jrxml/sl_immunisation coverage-sl.jrxml 1970-01-01 00:00:00 +0000 +++ resources/jrxml/sl_immunisation coverage-sl.jrxml 2010-09-17 16:16:32 +0000 @@ -0,0 +1,446 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="immunisation_coverages_incl_parent" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="ireport.zoom" value="1.610510000000002"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <subDataset name="parent_data"> + <queryString> + <![CDATA[select + +organisationunitname as parent_name, +bcg_coverage_lt_1_a_reporting_month as parent_bcg_rm, +bcg_coverage_lt_1_a_last3_months as parent_bcg_l3 , +penta3_coveragea_reporting_month as parent_penta_rm, +penta3_coveragea_last3_months as parent_penta_l3 , +measles_cov_lt_1_a_reporting_month as parent_measles_rm, +measles_cov_lt_1_a_last3_months as parent_measles_l3, +fullyimmunizedcova_reporting_month as parent_fully_rm, +fullyimmunizedcova_last3_months as parent_fully_l3 + +from _REPORT_IMMUNISATION_COVERAGES_PARENT where organisationunitid IN ( select child.parentid from _REPORT_IMMUNISATION_COVERAGES report, organisationunit child +where report.organisationunitid=child.organisationunitid)]]> + </queryString> + <field name="PARENT_NAME" class="java.lang.String"/> + <field name="PARENT_BCG_RM" class="java.lang.Double"/> + <field name="PARENT_BCG_L3" class="java.lang.Double"/> + <field name="PARENT_PENTA_RM" class="java.lang.Double"/> + <field name="PARENT_PENTA_L3" class="java.lang.Double"/> + <field name="PARENT_MEASLES_RM" class="java.lang.Double"/> + <field name="PARENT_MEASLES_L3" class="java.lang.Double"/> + <field name="PARENT_FULLY_RM" class="java.lang.Double"/> + <field name="PARENT_FULLY_L3" class="java.lang.Double"/> + </subDataset> + <queryString> + <![CDATA[SELECT + organisationunitname, + reporting_month_name, + BCG_COVERAGE_LT_1_A_REPORTING_MONTH, + BCG_COVERAGE_LT_1_A_LAST3_MONTHS, + PENTA3_COVERAGEA_REPORTING_MONTH, + PENTA3_COVERAGEA_LAST3_MONTHS, + MEASLES_COV_LT_1_A_REPORTING_MONTH, + MEASLES_COV_LT_1_A_LAST3_MONTHS, + FULLYIMMUNIZEDCOVA_REPORTING_MONTH, + FULLYIMMUNIZEDCOVA_LAST3_MONTHS, + 0 as sortorder + +FROM + _report_immunisation_coverages + +UNION + +select + +organisationunitname, +reporting_month_name, +bcg_coverage_lt_1_a_reporting_month, +bcg_coverage_lt_1_a_last3_months, +penta3_coveragea_reporting_month, +penta3_coveragea_last3_months, +measles_cov_lt_1_a_reporting_month, +measles_cov_lt_1_a_last3_months, +fullyimmunizedcova_reporting_month, +fullyimmunizedcova_last3_months, +1 as sortorder + +from _REPORT_IMMUNISATION_COVERAGES_PARENT where organisationunitid IN ( select child.parentid from _REPORT_IMMUNISATION_COVERAGES report, organisationunit child +where report.organisationunitid=child.organisationunitid) +order by sortorder, organisationunitname]]> + </queryString> + <field name="ORGANISATIONUNITNAME" class="java.lang.String"/> + <field name="REPORTING_MONTH_NAME" class="java.lang.String"/> + <field name="BCG_COVERAGE_LT_1_A_REPORTING_MONTH" class="java.lang.Double"/> + <field name="BCG_COVERAGE_LT_1_A_LAST3_MONTHS" class="java.lang.Double"/> + <field name="PENTA3_COVERAGEA_REPORTING_MONTH" class="java.lang.Double"/> + <field name="PENTA3_COVERAGEA_LAST3_MONTHS" class="java.lang.Double"/> + <field name="MEASLES_COV_LT_1_A_REPORTING_MONTH" class="java.lang.Double"/> + <field name="MEASLES_COV_LT_1_A_LAST3_MONTHS" class="java.lang.Double"/> + <field name="FULLYIMMUNIZEDCOVA_REPORTING_MONTH" class="java.lang.Double"/> + <field name="FULLYIMMUNIZEDCOVA_LAST3_MONTHS" class="java.lang.Double"/> + <field name="SORTORDER" class="java.lang.Integer"/> + <variable name="variable1" class="java.lang.String"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="60" splitType="Stretch"/> + </title> + <pageHeader> + <band height="57" splitType="Stretch"> + <textField> + <reportElement x="10" y="10" width="555" height="26"/> + <textElement textAlignment="Center"> + <font size="20" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA["Immunisation coverages - "+ $F{REPORTING_MONTH_NAME}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="61" splitType="Stretch"> + <staticText> + <reportElement mode="Opaque" x="0" y="0" width="97" height="60" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement/> + <text><![CDATA[]]></text> + </staticText> + <elementGroup> + <elementGroup> + <staticText> + <reportElement mode="Opaque" x="193" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[This month]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="289" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[This month]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="337" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Last 3 months]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="97" y="0" width="96" height="20" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[BCG]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="193" y="0" width="96" height="20" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Penta3]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="145" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Last 3 months]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="385" y="0" width="108" height="20" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Fully Immunised]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="241" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Last 3 months]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="289" y="0" width="96" height="20" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Measles]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="97" y="20" width="48" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[This month]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="444" y="20" width="49" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Last 3 months]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="385" y="20" width="59" height="40" backcolor="#CCCCCC"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[This month]]></text> + </staticText> + </elementGroup> + </elementGroup> + </band> + </columnHeader> + <detail> + <band height="20" splitType="Stretch"> + <textField> + <reportElement x="97" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{BCG_COVERAGE_LT_1_A_REPORTING_MONTH}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="145" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{BCG_COVERAGE_LT_1_A_LAST3_MONTHS}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="193" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{PENTA3_COVERAGEA_REPORTING_MONTH}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="241" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{PENTA3_COVERAGEA_LAST3_MONTHS}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="289" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{MEASLES_COV_LT_1_A_REPORTING_MONTH}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="337" y="0" width="48" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{MEASLES_COV_LT_1_A_LAST3_MONTHS}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="385" y="0" width="59" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{FULLYIMMUNIZEDCOVA_REPORTING_MONTH}]]></textFieldExpression> + </textField> + <textField pattern=""> + <reportElement x="0" y="0" width="97" height="20"/> + <box leftPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{ORGANISATIONUNITNAME}]]></textFieldExpression> + </textField> + <textField pattern=""> + <reportElement x="444" y="0" width="49" height="20"/> + <box leftPadding="0" rightPadding="2"> + <topPen lineWidth="0.5" lineStyle="Solid"/> + <leftPen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5" lineStyle="Solid"/> + <rightPen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{FULLYIMMUNIZEDCOVA_LAST3_MONTHS}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="21" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="16" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="268" splitType="Stretch"> + <barChart> + <chart isShowLegend="false"> + <reportElement x="126" y="56" width="289" height="169"/> + <chartTitle> + <font size="14" isBold="true"/> + <titleExpression><![CDATA["Immunisation coverage for " + ($F{SORTORDER} == 1 ? $F{ORGANISATIONUNITNAME} : "") + " last 3 months"]]></titleExpression> + </chartTitle> + <chartSubtitle/> + <chartLegend/> + </chart> + <categoryDataset> + <dataset> + <datasetRun subDataset="parent_data"/> + </dataset> + <categorySeries> + <seriesExpression><![CDATA["Immunisation coverage last 3 months (%)"]]></seriesExpression> + <categoryExpression><![CDATA["BCG"]]></categoryExpression> + <valueExpression><![CDATA[$F{PARENT_BCG_L3}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{PARENT_BCG_L3}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["Immunisation coverage last 3 months (%)"]]></seriesExpression> + <categoryExpression><![CDATA["Penta3"]]></categoryExpression> + <valueExpression><![CDATA[$F{PARENT_PENTA_L3}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{PARENT_PENTA_L3}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["Immunisation coverage last 3 months (%)"]]></seriesExpression> + <categoryExpression><![CDATA["Measles"]]></categoryExpression> + <valueExpression><![CDATA[$F{PARENT_MEASLES_L3}]]></valueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{PARENT_MEASLES_L3}.toString()]]></hyperlinkTooltipExpression> + </itemHyperlink> + </categorySeries> + </categoryDataset> + <barPlot> + <plot/> + <itemLabel color="#000000" backgroundColor="#FFFFFF"/> + <categoryAxisFormat> + <axisFormat> + <labelFont/> + <tickLabelFont/> + </axisFormat> + </categoryAxisFormat> + <valueAxisLabelExpression><![CDATA["%"]]></valueAxisLabelExpression> + <valueAxisFormat> + <axisFormat> + <labelFont> + <font size="14" isBold="false"/> + </labelFont> + <tickLabelFont/> + </axisFormat> + </valueAxisFormat> + </barPlot> + </barChart> + </band> + </summary> +</jasperReport> === added file 'resources/jrxml/sl_top10_new_cases-sl.jrxml' --- resources/jrxml/sl_top10_new_cases-sl.jrxml 1970-01-01 00:00:00 +0000 +++ resources/jrxml/sl_top10_new_cases-sl.jrxml 2010-09-17 16:16:32 +0000 @@ -0,0 +1,255 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="top10_new_cases" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="ireport.zoom" value="1.610510000000003"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="9"/> + <queryString> + <![CDATA[SELECT TOP 10 +_REPORT_MORBIDITY_NEW_CASES.ORGANISATIONUNITNAME, +_REPORT_MORBIDITY_NEW_CASES.DATAELEMENTNAME as DE_short, +de.name as DE_name, +_REPORT_MORBIDITY_NEW_CASES. REPORTING_MONTH_NAME , +_REPORT_MORBIDITY_NEW_CASES._011M , +_REPORT_MORBIDITY_NEW_CASES._1259M , +_REPORT_MORBIDITY_NEW_CASES._514Y , +_REPORT_MORBIDITY_NEW_CASES._15Y , +_REPORT_MORBIDITY_NEW_CASES.TOTAL + +FROM _REPORT_MORBIDITY_NEW_CASES, DATAELEMENT DE +where _REPORT_MORBIDITY_NEW_CASES.DATAELEMENTID=DE.DATAELEMENTID +ORDER BY TOTAL DESC]]> + </queryString> + <field name="ORGANISATIONUNITNAME" class="java.lang.String"/> + <field name="DE_SHORT" class="java.lang.String"/> + <field name="DE_NAME" class="java.lang.String"/> + <field name="REPORTING_MONTH_NAME" class="java.lang.String"/> + <field name="_011M" class="java.lang.Double"/> + <field name="_1259M" class="java.lang.Double"/> + <field name="_514Y" class="java.lang.Double"/> + <field name="_15Y" class="java.lang.Double"/> + <field name="TOTAL" class="java.lang.Double"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="71" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="555" height="26"/> + <textElement textAlignment="Center"> + <font size="20" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{ORGANISATIONUNITNAME}+" - "+ $F{REPORTING_MONTH_NAME}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="25" width="555" height="20"/> + <box bottomPadding="0"/> + <textElement textAlignment="Center"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[Morbidity - Top 10 new cases]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="29" splitType="Stretch"/> + </pageHeader> + <columnHeader> + <band height="20" splitType="Stretch"> + <staticText> + <reportElement mode="Opaque" x="0" y="0" width="141" height="20" backcolor="#CCCCCC"/> + <box leftPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Disease]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="141" y="0" width="81" height="20" backcolor="#CCCCCC"/> + <box> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[0-11m]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="222" y="0" width="81" height="20" backcolor="#CCCCCC"/> + <box> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[12-59m]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="303" y="0" width="81" height="20" backcolor="#CCCCCC"/> + <box> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[5-14y]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="465" y="0" width="81" height="20" backcolor="#CCCCCC"/> + <box> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement mode="Opaque" x="384" y="0" width="81" height="20" backcolor="#CCCCCC"/> + <box> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[15+y]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="32" splitType="Stretch"> + <textField> + <reportElement x="141" y="0" width="81" height="31"/> + <box bottomPadding="1" rightPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_011M}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="222" y="0" width="81" height="31"/> + <box bottomPadding="1" rightPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_1259M}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="303" y="0" width="81" height="31"/> + <box bottomPadding="1" rightPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_514Y}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="384" y="0" width="81" height="31"/> + <box bottomPadding="1" rightPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_15Y}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="465" y="0" width="81" height="31"/> + <box bottomPadding="1" rightPadding="2"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{TOTAL}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true"> + <reportElement x="0" y="0" width="141" height="31"/> + <box leftPadding="2" bottomPadding="1"> + <pen lineWidth="0.25"/> + <topPen lineWidth="0.25" lineStyle="Solid"/> + <leftPen lineWidth="0.25" lineStyle="Solid"/> + <bottomPen lineWidth="0.25" lineStyle="Solid"/> + <rightPen lineWidth="0.25" lineStyle="Solid"/> + </box> + <textElement verticalAlignment="Bottom"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{DE_NAME}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="14" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="14" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="539" splitType="Stretch"> + <pieChart> + <chart isShowLegend="false"> + <reportElement x="0" y="34" width="555" height="505"/> + <chartTitle position="Top"> + <font size="14" isBold="true"/> + <titleExpression><![CDATA[$F{ORGANISATIONUNITNAME}+" - "+ $F{REPORTING_MONTH_NAME}]]></titleExpression> + </chartTitle> + <chartSubtitle> + <font size="12" isBold="true"/> + <subtitleExpression><![CDATA["Top 10 new cases"]]></subtitleExpression> + </chartSubtitle> + <chartLegend/> + </chart> + <pieDataset> + <keyExpression><![CDATA[$F{DE_NAME}]]></keyExpression> + <valueExpression><![CDATA[$F{TOTAL}]]></valueExpression> + <sectionHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{TOTAL}.toString()]]></hyperlinkTooltipExpression> + </sectionHyperlink> + </pieDataset> + <piePlot isCircular="true"> + <plot/> + <itemLabel color="#000000" backgroundColor="#FFFFFF"/> + </piePlot> + </pieChart> + </band> + </summary> +</jasperReport>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
