main.jrxml

<?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="main" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="38750424-97fa-45ab-809c-433bb9be4e70">
    <property name="ireport.zoom" value="1.771561000000001"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <queryString>
        <![CDATA[select 1.4 as "RECORD", 'A' as "GROUP"
from dual
  union all
select 5.0, 'A'
from dual
  union all
select 5.2, 'A'
from dual
  union all
select 13.1, 'B'
from dual
  union all
select 2.0, 'B'
from dual
  union all
select 3.7, 'B'
from dual]]>
    </queryString>
    <field name="RECORD" class="java.math.BigDecimal"/>
    <field name="GROUP" class="java.lang.String"/>
    <variable name="returnSimple" class="java.math.BigDecimal" calculation="System">
        <initialValueExpression><![CDATA[]]></initialValueExpression>
    </variable>
    <variable name="returnSum" class="java.math.BigDecimal" resetType="Group" resetGroup="group" calculation="System">
        <initialValueExpression><![CDATA[]]></initialValueExpression>
    </variable>
    <variable name="returnAvg" class="java.math.BigDecimal" resetType="Group" resetGroup="group" calculation="System">
        <initialValueExpression><![CDATA[]]></initialValueExpression>
    </variable>
    <variable name="returnLowest" class="java.math.BigDecimal" resetType="Group" resetGroup="group" calculation="System">
        <initialValueExpression><![CDATA[]]></initialValueExpression>
    </variable>
    <variable name="returnStdDeviation" class="java.math.BigDecimal" resetType="Group" resetGroup="group" calculation="System">
        <initialValueExpression><![CDATA[]]></initialValueExpression>
    </variable>
    <group name="group">
        <groupExpression><![CDATA[$F{GROUP}]]></groupExpression>
        <groupFooter>
            <band height="39">
                <staticText>
                    <reportElement x="0" y="0" width="92" height="20" uuid="4d6dc8e7-5a6c-4df5-ae2d-13ed7dd68cb0"/>
                    <text><![CDATA[Summary of group ]]></text>
                </staticText>
                <textField>
                    <reportElement x="92" y="0" width="100" height="20" uuid="fe96f6c6-8af7-4097-b16f-313cbbdbb0b9"/>
                    <textFieldExpression><![CDATA[$F{GROUP}]]></textFieldExpression>
                </textField>
                <staticText>
                    <reportElement x="202" y="0" width="39" height="20" uuid="5ee8f0d7-0af7-4f85-a688-f7659174a997"/>
                    <text><![CDATA[Sum]]></text>
                </staticText>
                <staticText>
                    <reportElement x="295" y="0" width="47" height="20" uuid="d2c80b77-3f65-4f98-927e-30b4d04a3709"/>
                    <text><![CDATA[Average]]></text>
                </staticText>
                <staticText>
                    <reportElement x="385" y="0" width="48" height="20" uuid="46d192bb-1d47-49a7-ad50-27be94036609"/>
                    <text><![CDATA[Lowest]]></text>
                </staticText>
                <textField>
                    <reportElement x="241" y="0" width="54" height="20" uuid="603d3f64-fd3a-4786-9146-e49892351733"/>
                    <textFieldExpression><![CDATA[$V{returnSum}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="342" y="0" width="43" height="20" uuid="db6615e0-3719-48db-82f5-2e3a9838297f"/>
                    <textFieldExpression><![CDATA[$V{returnAvg}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="433" y="0" width="38" height="20" uuid="8413bc12-2142-41d2-bd81-6614b3b35536"/>
                    <textFieldExpression><![CDATA[$V{returnLowest}]]></textFieldExpression>
                </textField>
                <staticText>
                    <reportElement x="471" y="0" width="43" height="20" uuid="ca5407c2-81f1-488a-89c6-25497a3fbe63"/>
                    <text><![CDATA[StdDev]]></text>
                </staticText>
                <textField>
                    <reportElement x="514" y="0" width="41" height="20" uuid="7bb9b818-5e23-4b47-bf6f-e82bf72e4172"/>
                    <textFieldExpression><![CDATA[$V{returnStdDeviation}]]></textFieldExpression>
                </textField>
            </band>
        </groupFooter>
    </group>
    <detail>
        <band height="20">
            <staticText>
                <reportElement x="31" y="0" width="86" height="20" uuid="836e7ef6-f20d-4694-a4e1-e5b52c3ffa49"/>
                <text><![CDATA[Record passed]]></text>
            </staticText>
            <textField>
                <reportElement x="117" y="0" width="100" height="20" uuid="e49ca546-258a-4d0d-9a98-2da7f5ec5993"/>
                <textFieldExpression><![CDATA[$F{RECORD}]]></textFieldExpression>
            </textField>
            <subreport>
                <reportElement x="241" y="0" width="69" height="20" uuid="681cf1c5-c052-4d7e-87a1-67e7e599a226"/>
                <subreportParameter name="id">
                    <subreportParameterExpression><![CDATA[$F{RECORD}]]></subreportParameterExpression>
                </subreportParameter>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <returnValue subreportVariable="return" toVariable="returnSimple"/>
                <returnValue subreportVariable="return" toVariable="returnSum" calculation="Sum"/>
                <returnValue subreportVariable="return" toVariable="returnAvg" calculation="Average"/>
                <returnValue subreportVariable="return" toVariable="returnLowest" calculation="Lowest"/>
                <returnValue subreportVariable="return" toVariable="returnStdDeviation" calculation="StandardDeviation"/>
                <subreportExpression><![CDATA["subreport.jasper"]]></subreportExpression>
            </subreport>
            <staticText>
                <reportElement x="355" y="0" width="100" height="20" uuid="c9b1dfac-fcf1-45ca-b6f9-388a4dc9e15e"/>
                <text><![CDATA[Subreport returned]]></text>
            </staticText>
            <textField evaluationTime="Band" pattern="">
                <reportElement x="455" y="0" width="100" height="20" uuid="40e51015-c47e-4ad7-b92c-5ff89f2df46f"/>
                <textFieldExpression><![CDATA[$V{returnSimple}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
</jasperReport>