[Branch ~dhis2-devs-core/dhis2/trunk] Rev 1182: Added Jasper report. Based on the SL demo database and JasperReports 3.5.3

DHIS_2_Users · 9 December 2009 00:50

olatitle · 9 December 2009 08:03

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

···

2009/12/9 noreply@launchpad.net

revno: 1182

committer: Lars Helge Oeverland larshelge@gmail.com

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"?>

+

```
  <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>
```

+

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars · 9 December 2009 08:06

Yes and we can include it under downloads on dhis2.org.

···

On Wed, Dec 9, 2009 at 9:03 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

2009/12/9 noreply@launchpad.net

revno: 1182

committer: Lars Helge Oeverland larshelge@gmail.com

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.