------------------------------------------------------------ revno: 1182 committer: Lars Helge Oeverland [email protected] branch nick: trunk timestamp: Wed 2009-12-09 01:47:37 +0100 message: Added Jasper report. Based on the SL demo database and JasperReports 3.5.3 added: resources/jrxml/ resources/jrxml/anctt.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 directory 'resources/jrxml' === added file 'resources/jrxml/anctt.jrxml' --- resources/jrxml/anctt.jrxml 1970-01-01 00:00:00 +0000 +++ resources/jrxml/anctt.jrxml 2009-12-09 00:47:37 +0000 @@ -0,0 +1,360 @@ +<?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="anctt" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <subDataset name="dataset1"/> + <queryString> + <![CDATA[select * from _report_anc_tt_multidimensional]]> + </queryString> + <field name="dataelementid" class="java.lang.Integer"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="periodid" class="java.lang.Integer"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="organisationunitid" class="java.lang.Integer"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="dataelementname" class="java.lang.String"> + <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="_1549_yrs_nonpreg_outreach" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="_1549_yrs_nonpreg_fixed" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="_1549_yrs_preg_fixed" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="outreach_1549_yrs_preg" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="total_1549_yrs_nonpreg" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="total_1549_yrs_preg" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="total_outreach" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="total_fixed" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <field name="total" class="java.lang.Double"> + <fieldDescription><![CDATA[]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="96" splitType="Stretch"> + <staticText> + <reportElement x="201" y="10" width="153" height="31" forecolor="#4F6E96"/> + <textElement textAlignment="Justified"> + <font fontName="SansSerif" size="20" isBold="false"/> + </textElement> + <text><![CDATA[ANC TT Report]]></text> + </staticText> + <staticText> + <reportElement x="201" y="52" width="153" height="20"/> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Sierra Leone Ministry of Health]]></text> + </staticText> + <image> + <reportElement x="38" y="10" width="83" height="62"/> + <imageExpression class="java.lang.String"><![CDATA["C:\\development\\jrxml\\sierra_leone_coat_of_arms.jpg"]]></imageExpression> + </image> + </band> + </title> + <pageHeader> + <band height="47" splitType="Stretch"> + <staticText> + <reportElement x="24" y="0" width="76" height="20"/> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Period:]]></text> + </staticText> + <textField> + <reportElement x="100" y="0" width="109" height="20"/> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="8"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{reporting_month_name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="24" y="20" width="76" height="20"/> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Organisation unit:]]></text> + </staticText> + <textField> + <reportElement x="100" y="20" width="109" height="20"/> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="8"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{organisationunitname}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="64" splitType="Stretch"> + <staticText> + <reportElement x="149" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Outreach]]></text> + </staticText> + <staticText> + <reportElement x="229" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Outreach]]></text> + </staticText> + <staticText> + <reportElement x="189" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Fixed]]></text> + </staticText> + <staticText> + <reportElement x="269" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Fixed]]></text> + </staticText> + <staticText> + <reportElement x="149" y="19" width="81" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Non-Pregnant]]></text> + </staticText> + <staticText> + <reportElement x="230" y="19" width="79" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Pregnant]]></text> + </staticText> + <line> + <reportElement x="24" y="59" width="485" height="1"/> + <graphicElement> + <pen lineWidth="0.25"/> + </graphicElement> + </line> + <staticText> + <reportElement x="309" y="19" width="200" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="309" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Non-Preg]]></text> + </staticText> + <staticText> + <reportElement x="349" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Pregnant]]></text> + </staticText> + <staticText> + <reportElement x="389" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Outreach]]></text> + </staticText> + <staticText> + <reportElement x="429" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Fixed]]></text> + </staticText> + <staticText> + <reportElement x="469" y="39" width="40" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[All]]></text> + </staticText> + <staticText> + <reportElement x="24" y="39" width="76" height="20"/> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="8" isBold="true"/> + </textElement> + <text><![CDATA[Data element]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="23" splitType="Stretch"> + <textField> + <reportElement x="24" y="0" width="76" height="20"/> + <textElement> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{dataelementname}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="149" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_1549_yrs_nonpreg_outreach}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="189" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_1549_yrs_nonpreg_fixed}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="229" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{outreach_1549_yrs_preg}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="309" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{total_1549_yrs_nonpreg}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="349" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{total_1549_yrs_preg}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="389" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{total_outreach}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="429" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{total_fixed}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="469" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{total}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="269" y="0" width="40" height="20"/> + <textElement textAlignment="Center"> + <font fontName="SansSerif" size="9"/> + </textElement> + <textFieldExpression class="java.lang.Double"><![CDATA[$F{_1549_yrs_preg_fixed}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="24" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="222" splitType="Stretch"> + <barChart> + <chart> + <reportElement x="77" y="49" width="400" height="173"/> + <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> + <font size="8"/> + </chartLegend> + </chart> + <categoryDataset> + <categorySeries> + <seriesExpression><![CDATA["Non-Pregnant"]]></seriesExpression> + <categoryExpression><![CDATA[$F{dataelementname}]]></categoryExpression> + <valueExpression><![CDATA[$F{total_1549_yrs_nonpreg}]]></valueExpression> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["Pregnant"]]></seriesExpression> + <categoryExpression><![CDATA[$F{dataelementname}]]></categoryExpression> + <valueExpression><![CDATA[$F{total_1549_yrs_preg}]]></valueExpression> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["Outreach"]]></seriesExpression> + <categoryExpression><![CDATA[$F{dataelementname}]]></categoryExpression> + <valueExpression><![CDATA[$F{total_outreach}]]></valueExpression> + </categorySeries> + <categorySeries> + <seriesExpression><![CDATA["Fixed"]]></seriesExpression> + <categoryExpression><![CDATA[$F{dataelementname}]]></categoryExpression> + <valueExpression><![CDATA[$F{total_fixed}]]></valueExpression> + </categorySeries> + </categoryDataset> + <barPlot> + <plot backgroundAlpha="1.0" foregroundAlpha="0.75"/> + <itemLabel color="#000000" backgroundColor="#FFFFFF"/> + <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> + </barPlot> + </barChart> + </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
