Subreports Overlap each other

Posted on October 8, 2018 at 6:19am
0

I have a question regarding the subreports. Requirement is to have 3 subreports one below another.

when subreports run ,if 2nd sub reprt has more details it overlap oneach...this my code
 

<?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="PayR1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3fda54b9-ddbd-4deb-b45a-6b3c6397edbb">
    <property name="ireport.zoom" value="1.5"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="257"/>
    <style name="Sans_Normal" isDefault="true" fontName="DejaVu Sans" fontSize="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
    <style name="Sans_Bold" fontName="DejaVu Sans" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
    <style name="Sans_Italic" fontName="DejaVu Sans" fontSize="12" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false"/>
    <style name="Title" fontName="Arial" fontSize="26" isBold="true" pdfFontName="Helvetica-Bold"/>
    <style name="SubTitle" forecolor="#666666" fontName="Arial" fontSize="18"/>
    <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
    <style name="Detail" fontName="Arial" fontSize="12"/>
    <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA["C:\\PHMotors System\\Jasper Report\\"]]></defaultValueExpression>
    </parameter>
    <parameter name="JOB_ID" class="java.lang.Integer"/>
    <queryString>
        <![CDATA[SELECT * FROM vehiclepartsadded WHERE jobid = $P{JOB_ID}]]>
    </queryString>
    <field name="id" class="java.lang.Integer">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="jobId" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="vehicleNo" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="ownerName" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="brandName" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="model" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="partCode" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="partName" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="partBrand" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="qty" class="java.lang.Integer">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="price" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="date" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="109" splitType="Stretch">
            <rectangle>
                <reportElement x="0" y="72" width="555" height="35" uuid="9de690ec-7d49-4ce9-9ee1-57c912e91238"/>
                <graphicElement>
                    <pen lineWidth="0.75" lineStyle="Double"/>
                </graphicElement>
            </rectangle>
            <staticText>
                <reportElement style="Title" x="-2" y="3" width="263" height="33" uuid="c0683b94-ab86-4930-b2c1-17527395b0cc"/>
                <textElement verticalAlignment="Middle"/>
                <text><![CDATA[PH MOTORS]]></text>
            </staticText>
            <staticText>
                <reportElement style="SubTitle" x="98" y="36" width="174" height="22" uuid="c6c394d7-a02e-42b8-8eb7-35fdda6f936a"/>
                <text><![CDATA[Leaf Green SubTitle]]></text>
            </staticText>
            <staticText>
                <reportElement style="Column header" x="11" y="82" width="76" height="15" uuid="c7bb8bfd-045b-45cd-a74b-4e3b3b4d26e2"/>
                <text><![CDATA[VEHICLE NO]]></text>
            </staticText>
            <textField>
                <reportElement style="Detail" x="116" y="82" width="76" height="15" uuid="1e724c47-4175-4669-a151-d015741f825e"/>
                <textFieldExpression><![CDATA[$F{vehicleNo}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement style="Column header" x="237" y="82" width="68" height="15" uuid="c5a075ff-ea79-44f3-abc0-67aa82ca7d68"/>
                <text><![CDATA[BRAND NAME]]></text>
            </staticText>
            <textField>
                <reportElement style="Detail" x="305" y="82" width="68" height="15" uuid="fc38a64b-d0e9-4045-9a56-dbc47b252440"/>
                <textFieldExpression><![CDATA[$F{brandName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="Detail" x="479" y="82" width="71" height="15" uuid="8339f9af-9b2a-4212-aaa5-96f757d5eb94"/>
                <textFieldExpression><![CDATA[$F{model}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement style="Column header" x="408" y="82" width="71" height="15" uuid="c8bf2c8d-d321-4e5e-8ca3-a7b89f5cb061"/>
                <text><![CDATA[MODEL]]></text>
            </staticText>
        </band>
    </title>
    <pageHeader>
        <band splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band height="11" splitType="Stretch">
            <line>
                <reportElement positionType="FixRelativeToBottom" x="0" y="6" width="555" height="1" uuid="45446c75-aa26-4d6a-8c53-9fb48c24796b"/>
                <graphicElement>
                    <pen lineWidth="0.5" lineColor="#999999"/>
                </graphicElement>
            </line>
        </band>
    </columnHeader>
    <columnFooter>
        <band height="34" splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band height="648" splitType="Stretch">
            <textField>
                <reportElement style="Column header" x="433" y="0" width="80" height="20" uuid="96887b13-bf5e-4db6-86c1-0eef41017539"/>
                <textElement textAlignment="Right">
                    <font size="10" isBold="false"/>
                </textElement>
                <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
            </textField>
            <textField evaluationTime="Report">
                <reportElement style="Column header" x="513" y="0" width="40" height="20" uuid="b55da68d-855b-4e66-b3b6-e2f18af717da"/>
                <textElement>
                    <font size="10" isBold="false"/>
                </textElement>
                <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
            <textField pattern="EEEEE dd MMMMM yyyy">
                <reportElement style="Column header" x="0" y="0" width="197" height="20" uuid="0416869c-6608-4f9a-8767-e2448e8f84a2"/>
                <textElement>
                    <font size="10" isBold="false"/>
                </textElement>
                <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
            </textField>
            <subreport>
                <reportElement positionType="Float" x="35" y="41" width="200" height="37" uuid="1a5b0b8a-52e9-44e2-9ea2-4553db7b93a8"/>
                <subreportParameter name="SUBREPORT_DIR">
                    <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                </subreportParameter>
                <subreportParameter name="JOB_ID">
                    <subreportParameterExpression><![CDATA[$P{JOB_ID}]]></subreportParameterExpression>
                </subreportParameter>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "PayR1_subreport4.jasper"]]></subreportExpression>
            </subreport>
            <subreport>
                <reportElement x="35" y="102" width="200" height="39" uuid="da1557e3-9929-4c49-97fc-0a134d00f11c"/>
                <subreportParameter name="JOB_ID"/>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <subreportExpression><![CDATA["C:\\PHMotors System\\Jasper Report\\PayR1_subreport2.jasper"]]></subreportExpression>
            </subreport>
            <subreport>
                <reportElement x="35" y="169" width="197" height="40" uuid="56e5c22e-c678-4797-9169-f459ed603382"/>
                <subreportParameter name="SUBREPORT_DIR">
                    <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                </subreportParameter>
                <subreportParameter name="JOB_ID">
                    <subreportParameterExpression><![CDATA[$P{JOB_ID}]]></subreportParameterExpression>
                </subreportParameter>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "PayR1_subreport3.jasper"]]></subreportExpression>
            </subreport>
        </band>
    </pageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

 

 

i called datas from 3 tables of database for  3 subreports

anybody can help me
 

iReport Designer
kazunkatthidiya01's picture
kazunkatthidiya01
4
Joined: Oct 8 2018 - 6:08am
Last seen: 8 months 6 days ago

i 

kazunkatthidiya01 - 8 months 1 week ago
add comment

3 Answers:

1
Posted on October 8, 2018 at 10:33am

I noticed your other 2 subreports Position Type is set to "Fix Relative to Top" 
Set all three to "Float", should solve your problem.

So when you select the sub report, in the properties windows, select "Appearance" tab, then under location > position Type.

joseng62's picture
joseng62
600
Joined: Dec 5 2014 - 2:43am
Last seen: 2 weeks 4 days ago
0
Posted on October 8, 2018 at 11:39pm

i sett all to "Float" when do it no print 2nd and 3rd sub reports...no print more pages(only print 1 page ).but 1st subreports is print correctly.no go more pages

kazunkatthidiya01's picture
kazunkatthidiya01
4
Joined: Oct 8 2018 - 6:08am
Last seen: 8 months 6 days ago
0
Posted on October 12, 2018 at 8:24am

Hi kazun.....

There could be a couple of reasons for this. 
• Some of your subreport might not be getting any data, to test, make sure you set the report's proprerty "When No Data Type" = All Sections with Detail, ensure you have some hard code text fields in the subreports, so you can just test if this the case. 

• So when you work on the subreport jrxml and you safe, remember to compile in jasperstudio so the .jasper is updated. 

• Also I did not ask, but I am assuming that you are getting the issues in jasperstudio and have not yet deployed to JaserServer, as with jasperserver you need to make some setup before they will work.

• Could be the last page Footer causing this. So either use in Summary or create a dummmyGroup and make use of dummyGroup Header or Footer Section.

Hope this helps

joseng62's picture
joseng62
600
Joined: Dec 5 2014 - 2:43am
Last seen: 2 weeks 4 days ago
Feedback