dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #03623
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 1206: Modified report
------------------------------------------------------------
revno: 1206
committer: Lars Helge Oeverland larshelge@xxxxxxxxx
branch nick: trunk
timestamp: Fri 2009-12-11 00:11:16 +0100
message:
Modified report
added:
resources/jrxml/immunization.jrxml
modified:
resources/jrxml/feedback.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.
=== modified file 'resources/jrxml/feedback.jrxml'
--- resources/jrxml/feedback.jrxml 2009-12-10 16:59:09 +0000
+++ resources/jrxml/feedback.jrxml 2009-12-10 23:11:16 +0000
@@ -76,16 +76,16 @@
<imageExpression class="java.lang.String"><![CDATA["C:\\development\\jrxml\\sierra_leone_coat_of_arms.jpg"]]></imageExpression>
</image>
<staticText>
- <reportElement mode="Transparent" x="134" y="11" width="287" height="30" forecolor="#33CC00"/>
+ <reportElement mode="Transparent" x="127" y="11" width="301" height="42" forecolor="#42B83B"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="Cambria" size="25"/>
+ <font fontName="Tahoma" size="20" isBold="false"/>
</textElement>
<text><![CDATA[District Feedback Report]]></text>
</staticText>
<staticText>
<reportElement x="201" y="53" width="153" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="Cambria" size="10" isBold="false" isItalic="true" pdfFontName="Helvetica-Oblique"/>
+ <font fontName="Tahoma" size="10" isBold="false" isItalic="true" pdfFontName="Helvetica-Oblique"/>
</textElement>
<text><![CDATA[Sierra Leone Ministry of Health]]></text>
</staticText>
@@ -284,70 +284,70 @@
<textField>
<reportElement x="171" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{phudeliveryphucova_reporting_month}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="206" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{phudeliveryphucova_last12_months}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="241" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{anc_ipt_2_coverage_reporting_month}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="276" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{anc_ipt_2_coverage_last12_months}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="311" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{_lt_5diarrhoeaors_reporting_month}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="346" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{_lt_5diarrhoeaors_last12_months}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="381" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{fullyimmunizedcova_reporting_month}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="416" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{fullyimmunizedcova_last12_months}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="451" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{anc_llitn_coverage_reporting_month}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="486" y="0" width="35" height="20"/>
<textElement>
- <font fontName="Calibri"/>
+ <font fontName="Calibri" size="8"/>
</textElement>
<textFieldExpression class="java.lang.Double"><![CDATA[$F{anc_llitn_coverage_last12_months}]]></textFieldExpression>
</textField>
=== added file 'resources/jrxml/immunization.jrxml'
--- resources/jrxml/immunization.jrxml 1970-01-01 00:00:00 +0000
+++ resources/jrxml/immunization.jrxml 2009-12-10 23:11:16 +0000
@@ -0,0 +1,332 @@
+<?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="immunization" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
+ <queryString>
+ <![CDATA[select * from _report_immunizationtrends;]]>
+ </queryString>
+ <field name="periodid" class="java.lang.Integer">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="organisationunitid" class="java.lang.Integer">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="periodname" class="java.lang.String">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="organisationunitname" class="java.lang.String">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="reporting_month_name" class="java.lang.String">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="fullyimmunizedcova" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="penta3_coveragea" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="measles_vacc_cova" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="regression_fullyimmunizedcova" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="regression_penta3_coveragea" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <field name="regression_measles_vacc_cova" class="java.lang.Double">
+ <fieldDescription><![CDATA[]]></fieldDescription>
+ </field>
+ <background>
+ <band splitType="Stretch"/>
+ </background>
+ <title>
+ <band height="70" splitType="Stretch">
+ <image>
+ <reportElement x="50" y="0" width="83" height="62"/>
+ <imageExpression class="java.lang.String"><![CDATA["C:\\development\\jrxml\\sierra_leone_coat_of_arms.jpg"]]></imageExpression>
+ </image>
+ <staticText>
+ <reportElement x="151" y="0" width="253" height="46" forecolor="#354781"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font fontName="Tahoma" size="25"/>
+ </textElement>
+ <text><![CDATA[Immunization]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="201" y="50" width="153" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font fontName="Tahoma" size="10" isBold="false" isItalic="true" pdfFontName="Helvetica-Oblique"/>
+ </textElement>
+ <text><![CDATA[Sierra Leone Ministry of Health]]></text>
+ </staticText>
+ </band>
+ </title>
+ <pageHeader>
+ <band height="11" splitType="Stretch"/>
+ </pageHeader>
+ <columnHeader>
+ <band height="36" splitType="Stretch">
+ <staticText>
+ <reportElement x="50" y="10" width="100" height="20"/>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Month]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="151" y="10" width="100" height="20"/>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Organisation unit]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="251" y="10" width="80" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Fully immunized]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="331" y="10" width="80" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Penta 3]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="411" y="10" width="80" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Measles]]></text>
+ </staticText>
+ <line>
+ <reportElement x="51" y="30" width="440" height="1"/>
+ <graphicElement>
+ <pen lineWidth="0.25" lineColor="#666666"/>
+ </graphicElement>
+ </line>
+ </band>
+ </columnHeader>
+ <detail>
+ <band height="15" splitType="Stretch">
+ <textField>
+ <reportElement x="51" y="0" width="100" height="15"/>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.String"><![CDATA[$F{periodname}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="151" y="0" width="100" height="15"/>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.String"><![CDATA[$F{organisationunitname}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="251" y="0" width="80" height="15"/>
+ <textElement textAlignment="Center">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.Double"><![CDATA[$F{fullyimmunizedcova}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="331" y="0" width="80" height="15"/>
+ <textElement textAlignment="Center">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.Double"><![CDATA[$F{penta3_coveragea}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="411" y="0" width="80" height="15"/>
+ <textElement textAlignment="Center">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.Double"><![CDATA[$F{measles_vacc_cova}]]></textFieldExpression>
+ </textField>
+ </band>
+ </detail>
+ <columnFooter>
+ <band height="14" splitType="Stretch"/>
+ </columnFooter>
+ <pageFooter>
+ <band height="14" splitType="Stretch"/>
+ </pageFooter>
+ <summary>
+ <band height="472" splitType="Stretch">
+ <lineChart>
+ <chart isShowLegend="false">
+ <reportElement x="51" y="198" width="441" height="120"/>
+ <box>
+ <pen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <topPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <leftPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <bottomPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <rightPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ </box>
+ <chartTitle/>
+ <chartSubtitle/>
+ <chartLegend textColor="#000000" position="Right"/>
+ </chart>
+ <categoryDataset>
+ <categorySeries>
+ <seriesExpression><![CDATA["Penta 3"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{penta3_coveragea}]]></valueExpression>
+ </categorySeries>
+ <categorySeries>
+ <seriesExpression><![CDATA["Penta 3 Trend"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{regression_penta3_coveragea}]]></valueExpression>
+ </categorySeries>
+ </categoryDataset>
+ <linePlot isShowLines="true" isShowShapes="false">
+ <plot foregroundAlpha="0.95"/>
+ <categoryAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </categoryAxisFormat>
+ <valueAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </valueAxisFormat>
+ </linePlot>
+ </lineChart>
+ <lineChart>
+ <chart isShowLegend="false">
+ <reportElement x="51" y="352" width="441" height="120"/>
+ <box>
+ <pen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <topPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <leftPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <bottomPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <rightPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ </box>
+ <chartTitle/>
+ <chartSubtitle/>
+ <chartLegend textColor="#000000" position="Right"/>
+ </chart>
+ <categoryDataset>
+ <categorySeries>
+ <seriesExpression><![CDATA["Measles"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{measles_vacc_cova}]]></valueExpression>
+ </categorySeries>
+ <categorySeries>
+ <seriesExpression><![CDATA["Measles Trend"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{regression_measles_vacc_cova}]]></valueExpression>
+ </categorySeries>
+ </categoryDataset>
+ <linePlot isShowLines="true" isShowShapes="false">
+ <plot foregroundAlpha="0.95"/>
+ <categoryAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </categoryAxisFormat>
+ <valueAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </valueAxisFormat>
+ </linePlot>
+ </lineChart>
+ <lineChart>
+ <chart isShowLegend="false">
+ <reportElement x="51" y="45" width="441" height="120"/>
+ <box>
+ <pen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <topPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <leftPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <bottomPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ <rightPen lineWidth="0.25" lineColor="#CCCCCC"/>
+ </box>
+ <chartTitle/>
+ <chartSubtitle/>
+ <chartLegend textColor="#000000" position="Right"/>
+ </chart>
+ <categoryDataset>
+ <categorySeries>
+ <seriesExpression><![CDATA["Fully Immunized"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{fullyimmunizedcova}]]></valueExpression>
+ </categorySeries>
+ <categorySeries>
+ <seriesExpression><![CDATA["Fully Immunized Trend"]]></seriesExpression>
+ <categoryExpression><![CDATA[$F{periodname}]]></categoryExpression>
+ <valueExpression><![CDATA[$F{regression_fullyimmunizedcova}]]></valueExpression>
+ </categorySeries>
+ </categoryDataset>
+ <linePlot isShowLines="true" isShowShapes="false">
+ <plot foregroundAlpha="0.95"/>
+ <categoryAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </categoryAxisFormat>
+ <valueAxisFormat>
+ <axisFormat>
+ <labelFont>
+ <font size="8"/>
+ </labelFont>
+ <tickLabelFont>
+ <font size="8"/>
+ </tickLabelFont>
+ </axisFormat>
+ </valueAxisFormat>
+ </linePlot>
+ </lineChart>
+ <staticText>
+ <reportElement x="218" y="332" width="119" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Measles Trend Chart]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="218" y="178" width="119" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Penta 3 Trend Chart]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="218" y="25" width="119" height="20"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
+ </textElement>
+ <text><![CDATA[Fullt Immunized Trend Chart]]></text>
+ </staticText>
+ </band>
+ </summary>
+</jasperReport>
