gtepait Posted November 29, 2017 Share Posted November 29, 2017 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 More sharing options...
gtepait Posted November 29, 2017 Author Share Posted November 29, 2017 please someone help me. i am really desperate here, i am about to kill myself :( Link to comment Share on other sites More sharing options...
Shazia Posted November 30, 2017 Share Posted November 30, 2017 Not sure if this is the problem but please edit Subreport Expression as $P{SUBREPORT_DIR} +File.separator+"YourReportName.jasper" and check once. Link to comment Share on other sites More sharing options...
gtepait Posted December 1, 2017 Author Share Posted December 1, 2017 I found the problem. It's the value of my parameter SUBREPORT_DIR, it's wrong. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now