dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #07525
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 2157: Added Olas new reports for the new demo database
------------------------------------------------------------
revno: 2157
committer: Lars <larshelg@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>
