dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #03554
Re: [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1182: Added Jasper report. Based on the SL demo database and JasperReports 3.5.3
2009/12/9 <noreply@xxxxxxxxxxxxx>
> ------------------------------------------------------------
> revno: 1182
> committer: Lars Helge Oeverland larshelge@xxxxxxxxx
> 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
>
>
Cool, could this design file be available for download on the online demo
itself, as a document?
Then the users could first run the report in the demo and download the
design if they would like to have a look at it.
I guess we should do the same for the BIRT reports for SL.
Ola
------------
>
> --
> lp:dhis2
> https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk<https://code.launchpad.net/%7Edhis2-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<https://code.launchpad.net/%7Edhis2-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<https://launchpad.net/%7Edhis2-devs>
> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help : https://help.launchpad.net/ListHelp
>
>
Follow ups
References
