Subreport makes main report broken.

Posted on November 29, 2017 at 5:37am

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>

iReport Designer
JasperReports® Library
gtepait's picture
gtepait
29
Joined: Nov 2 2017 - 9:42am
Last seen: 5 years 3 months ago

please someone help me. i am really desperate here, i am about to kill myself  :(

 

gtepait - 5 years 3 months ago
add comment

2 Answers:

Posted on November 30, 2017 at 2:05am

Not sure if this is the problem but please edit Subreport Expression as $P{SUBREPORT_DIR} +File.separator+"YourReportName.jasper" and check once.

Shazia's picture
Shazia
260
Joined: Aug 2 2017 - 6:08am
Last seen: 3 years 10 months ago
Posted on November 30, 2017 at 5:56pm

I found the problem. It's the value of my parameter SUBREPORT_DIR, it's wrong. 

gtepait's picture
gtepait
29
Joined: Nov 2 2017 - 9:42am
Last seen: 5 years 3 months ago
Feedback