Jump to content
Changes to the Jaspersoft community edition download ×

Subreport makes main report broken.


gtepait

Recommended Posts

I am using ireport plugin in my netbeans. I have 4 subreports in my summary band. My subreports works fine when previewed individually, but when I try to put them in my summary and preview my main report, the report just closes. I pretty sure I passed my parameters correctly in my subreports. I do not know what's the problem, thank you in advance!

 

Here's my main report's 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="report name" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f3cd76f7-dc6c-41d2-9cbd-0b29fee307a4">    <property name="ireport.zoom" value="1.5000000000000016"/>    <property name="ireport.x" value="0"/>    <property name="ireport.y" value="0"/>    <style name="table">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table_TH" mode="Opaque" backcolor="#8FAECC">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table_CH" mode="Opaque" backcolor="#CFDAE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F5F8"/>        </conditionalStyle>    </style>    <style name="table 1">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 1_TH" mode="Opaque" backcolor="#ADD8E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 1_CH" mode="Opaque" backcolor="#BFEFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 2">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 2_TH" mode="Opaque" backcolor="#8599BE">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 2_CH" mode="Opaque" backcolor="#CFD7E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F5F8"/>        </conditionalStyle>    </style>    <style name="table 3">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 3_TH" mode="Opaque" backcolor="#8FAFCC">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 3_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 4">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 4_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 4_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 5">        <box>            <pen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 5_TH" mode="Opaque" backcolor="#8FAFCC">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 5_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 5_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 6">        <box>            <pen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 6_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 6_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 6_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 7">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 7_TH" mode="Opaque" backcolor="#F0F8FF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 7_CH" mode="Opaque" backcolor="#BFE1FF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 7_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#EFF7FF"/>        </conditionalStyle>    </style>    <style name="table 8">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 8_TH" mode="Opaque" backcolor="#F0F8FF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 8_CH" mode="Opaque" backcolor="#BFE1FF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 8_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 9">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 9_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 9_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 9_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 10">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 10_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 10_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 10_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 11">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 11_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 11_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 11_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 12">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 12_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 12_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 12_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 13">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 13_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 13_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 13_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>        <conditionalStyle>            <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>            <style backcolor="#F3F6F8"/>        </conditionalStyle>    </style>    <style name="table 14">        <box>            <topPen lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="table 14_TH" mode="Opaque" backcolor="#73B0E6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 14_CH" mode="Opaque" backcolor="#CFDBE6">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="table 14_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <topPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <subDataset name="Table" uuid="cfc9f733-d26b-4425-b171-3273c878d3f3">        <parameter name="yearReg" class="java.lang.Integer"/>        <queryString>   <![CDATA[select * from table1 where YearReg =  $P{yearReg}]]>        </queryString>        <field name="AppID" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Surname" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Firstname" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Middlename" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Birthday" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Occupation" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="HouseNumber" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Street" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="b_ID" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Address" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Age" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Gender" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Income" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Beneficiary" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="HealthCondition" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Ownership" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Remarks" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="DateReg" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="MonthReg" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="YearReg" class="java.lang.Integer">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="PWD" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="SeniorCitizen" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="ContactNo" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Attainment" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Citizenship" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <field name="Religion" class="java.lang.String">            <fieldDescription><![CDATA[]]></fieldDescription>        </field>        <group name="Surname">            <groupExpression><![CDATA[$F{Surname}]]></groupExpression>        </group>    </subDataset>    <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">        <defaultValueExpression><![CDATA["C:\Users\genesis\Documents\NetBeansProjects\Capstone(backup 2)\src\"]]></defaultValueExpression>    </parameter>    <parameter name="Year" class="java.lang.Integer"/>    <queryString>  <![CDATA[sELECT * FROM table1 where YearReg = $P{Year}]]>    </queryString>    <field name="AppID" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Surname" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Firstname" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Middlename" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Birthday" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Occupation" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="HouseNumber" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Street" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="b_ID" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Address" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Age" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Gender" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Income" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Beneficiary" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="HealthCondition" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Ownership" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Remarks" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="DateReg" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="MonthReg" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="YearReg" class="java.lang.Integer">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="PWD" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="SeniorCitizen" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="ContactNo" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Attainment" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Citizenship" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="Religion" class="java.lang.String">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <background>        <band splitType="Stretch"/>    </background>    <pageHeader>        <band height="91" splitType="Stretch">            <rectangle>                <reportElement x="0" y="70" width="555" height="20" forecolor="#CCCCCC" backcolor="#CCCCCC" uuid="7556ccae-277e-453b-a72d-b6ab10ddbb6e"/>            </rectangle>            <rectangle>                <reportElement mode="Opaque" x="0" y="0" width="555" height="70" backcolor="#0066CC" uuid="a596be1b-0865-41c1-91db-17dd870fcb52"/>                <graphicElement>                    <pen lineWidth="0.0"/>                </graphicElement>            </rectangle>            <image scaleImage="RetainShape">                <reportElement x="0" y="0" width="426" height="70" uuid="d3ea3f32-8aee-4491-a62e-7a58bed2388f"/>                <imageExpression><![CDATA["C:\Users\genesis\Pictures\13.jpg"]]></imageExpression>            </image>            <staticText>                <reportElement x="391" y="75" width="118" height="15" forecolor="#FF6900" uuid="c735fca5-c2de-420f-b011-a7d33a4cfa72"/>                <textElement>                    <font fontName="Adobe Caslon Pro Bold" size="14"/>                </textElement>                <text><![CDATA[Year-end Summary]]></text>            </staticText>        </band>    </pageHeader>    <columnHeader>        <band height="25" splitType="Stretch">            <line>                <reportElement x="0" y="0" width="555" height="1" uuid="15457d80-15d9-4cab-880c-17723e6df470"/>                <graphicElement>                    <pen lineWidth="2.0" lineStyle="Double"/>                </graphicElement>            </line>            <staticText>                <reportElement x="440" y="4" width="33" height="20" uuid="8f4dbaa5-106a-40ee-a68a-3c893c443979"/>                <textElement textAlignment="Right">                    <font fontName="Adobe Caslon Pro Bold"/>                </textElement>                <text><![CDATA[As of]]></text>            </staticText>            <textField>                <reportElement x="475" y="4" width="49" height="20" uuid="5d38f799-4cc5-45bd-a820-07ea9af82e1e"/>                <textElement textAlignment="Right" verticalAlignment="Top">                    <font fontName="Adobe Caslon Pro Bold" isBold="false"/>                </textElement>                <textFieldExpression><![CDATA[$P{Year}]]></textFieldExpression>            </textField>        </band>    </columnHeader>    <pageFooter>        <band height="28" splitType="Stretch">            <textField>                <reportElement x="426" y="8" width="80" height="20" uuid="98e13158-d30e-4e70-b80c-5411b619c952"/>                <textElement textAlignment="Right"/>                <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>            </textField>            <textField evaluationTime="Report">                <reportElement x="506" y="8" width="40" height="20" uuid="190a4cc0-b792-4b85-956e-27f92820ea08"/>                <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>            </textField>        </band>    </pageFooter>    <summary>        <band height="252">            <componentElement>                <reportElement key="table 14" style="table 14" x="0" y="4" width="360" height="140" uuid="21d39dcd-c39c-4873-acae-55f26a1994fd"/>                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">                    <datasetRun subDataset="Table" uuid="49d2bd60-296e-4dab-bb65-e018aff58f4b">                        <datasetParameter name="yearReg">                            <datasetParameterExpression><![CDATA[$P{Year}]]></datasetParameterExpression>                        </datasetParameter>                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:column width="90" uuid="04e26f37-9210-4350-9d80-be8856dcf6bd">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="90" height="30" uuid="13d973a7-2173-4a3c-a984-1a9b3516cb5b"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[surname]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="90" height="20" uuid="b9da9bb2-d6f7-4a73-a29a-776c338f5503"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Surname}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="90" uuid="9d86c04c-d670-4c06-82d5-81070873b561">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="90" height="30" uuid="e0cd64b7-996a-4225-9ec9-bf17865ead73"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[Firstname]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="90" height="20" uuid="028c17e6-cfab-4585-b79a-9dad3803a6f2"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Firstname}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="90" uuid="06241f15-e101-45ac-aea9-75d1754be6e3">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="90" height="30" uuid="a600e0c7-7ea1-4d90-ac07-83018ab85201"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[Middlename]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="90" height="20" uuid="d20e5497-f028-4f0b-a2c7-8b1075e4cf2a"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Middlename}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="90" uuid="a6917794-b828-4a0b-a324-f12496fbdd58">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="90" height="30" uuid="ae4f5884-5da8-415a-a181-ff2f01a54caf"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[Address]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="90" height="20" uuid="4ae2ec4f-841b-4573-bf97-f9402bf990dc"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Address}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="34" uuid="18129da1-8234-46ed-b5df-8270d46bebb5">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="33" height="30" uuid="673f7bcd-88bb-4262-8efa-db9c2e4bd62c"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[Age]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="33" height="20" uuid="6d8f2f55-329b-4bb0-b932-6b66701388cc"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Age}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="44" uuid="d62953f6-8d3f-45bc-a216-690b04729f0f">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="44" height="30" uuid="b8c06c17-a2a5-4037-b975-bdecf804b85d"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[Gender]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="44" height="20" uuid="c6ebf75f-5878-423d-9057-8a35b6851d5a"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Gender}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="44" uuid="cd714248-570e-40bd-85b6-ec4a92b12966">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="43" height="30" uuid="5a4d177c-0e88-434f-ba1e-25ef1cb38a14"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[bnfcry]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="43" height="20" uuid="79215df7-8a8c-49b6-bee2-aa720f392c8b"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{Beneficiary}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="41" uuid="64033463-2f97-4f0b-82ec-04c9ba57d9c7">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="40" height="30" uuid="4718bf25-88d8-4428-a2dc-f694c71d52df"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[PWD]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="40" height="20" uuid="0803ca15-6cb8-4e16-a9a9-50fab2dbcf2b"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{PWD}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="41" uuid="2d025f40-0110-46f2-b93d-ae701a90e701">                        <jr:tableHeader style="table 14_TH" height="30" rowSpan="1"/>                        <jr:tableFooter style="table 14_TH" height="30" rowSpan="1"/>                        <jr:columnHeader style="table 14_CH" height="30" rowSpan="1">                            <staticText>                                <reportElement x="0" y="0" width="40" height="30" uuid="c350e753-df51-425b-bb3a-f47a2d040c92"/>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font size="8" isBold="true"/>                                </textElement>                                <text><![CDATA[senior]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:columnFooter style="table 14_CH" height="30" rowSpan="1"/>                        <jr:detailCell style="table 14_TD" height="20" rowSpan="1">                            <textField>                                <reportElement x="0" y="0" width="40" height="20" uuid="5151a66e-0b5d-418a-afcf-2caa99010a9b"/>                                <textElement textAlignment="Center" verticalAlignment="Bottom">                                    <font size="8"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{SeniorCitizen}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                </jr:table>            </componentElement>            <subreport>                <reportElement positionType="Float" x="0" y="154" width="360" height="22" uuid="ce295159-e58d-4782-9ecf-edd7389fca1f"/>                <subreportParameter name="year">                    <subreportParameterExpression><![CDATA[$P{Year}]]></subreportParameterExpression>                </subreportParameter>                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Report_Yearly_Unfiltered_GrandTotal.jasper"]]></subreportExpression>            </subreport>            <subreport>                <reportElement positionType="Float" x="0" y="177" width="360" height="20" uuid="464a8d51-ed94-4757-9509-74d36fe98a63"/>                <subreportParameter name="year">                    <subreportParameterExpression><![CDATA[$P{Year}]]></subreportParameterExpression>                </subreportParameter>                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Report_Yearly_Unfiltered_TotalBnfcry.jasper"]]></subreportExpression>            </subreport>            <subreport>                <reportElement positionType="Float" x="0" y="198" width="360" height="24" uuid="5f768852-2f55-44ce-9753-53166b4dead1"/>                <subreportParameter name="year">                    <subreportParameterExpression><![CDATA[$P{Year}]]></subreportParameterExpression>                </subreportParameter>                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Report_Yearly_Unfiltered_TotalSeniors.jasper"]]></subreportExpression>            </subreport>            <subreport>                <reportElement positionType="Float" x="0" y="223" width="360" height="23" uuid="5ad20050-8f93-4074-a2c4-0d8ad10773fb"/>                <subreportParameter name="year">                    <subreportParameterExpression><![CDATA[$P{Year}]]></subreportParameterExpression>                </subreportParameter>                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Report_Yearly_Unfiltered_TotalPWD.jasper"]]></subreportExpression>            </subreport>        </band>    </summary></jasperReport>[/code]

 

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...