Page Break Problem in subreport

[2001 JI Open Discussion]

By: Mir - mirfaisal

Page Break Problem in subreport

2005-06-20 04:56

I am desiging a report which contains multiple subreports. Following is the code of one of my subreport. The report has six columns. the report filling type is horizontal due to the data Structure in my database. the report is basically generating a table like structure. But when this report breaks in to two pages the break of table is abnormal as it over prints some of the rows.

 

<?xml version="1.0"?>

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd" [

<!ENTITY reportFonts SYSTEM "./ReportFonts.ent">

]>

<jasperReport

name="WKPaperData6"

printOrder="Horizontal"

pageWidth="595"

pageHeight="842"

columnCount="6"

columnWidth="85"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="AllSectionsNoDetail"

isTitleNewPage="false"

isSummaryNewPage="false">

 

&reportFonts;

 

<parameter name="AUDTYPE" class="java.lang.String"></parameter>

<parameter name="AREACODE" class="java.lang.String"></parameter>

<parameter name="REGCODE" class="java.lang.String"></parameter>

<parameter name="ENTCODE" class="java.lang.String"></parameter>

<parameter name="ENGYEAR" class="java.lang.String"></parameter>

<parameter name="FINDNO" class="java.lang.String"></parameter>

<parameter name="FUNCAREA" class="java.lang.String"></parameter>

<parameter name="WRKPAPID" class="java.lang.String"></parameter>

 

 

<queryString><![CDATA[sELECT LINENUM, COLNO, VALU FROM AM1205 WHERE WRKTYPE = '0' AND WRKAREATYP = 'C' AND AUDTYPE = $P{AUDTYPE} AND AREACODE = $P{AREACODE} AND REGCODE = $P{REGCODE} AND ENTCODE = $P{ENTCODE} AND ENGYEAR = $P{ENGYEAR} AND FINDNO = $P{FINDNO} AND FUNCAREA = $P{FUNCAREA} AND WRKPAPID = $P{WRKPAPID} ORDER BY 1,2]]></queryString>

 

<field name="LINENUM" class="java.lang.String"/>

<field name="COLNO" class="java.lang.String"/>

<field name="VALU" class="java.lang.String"/>

 

<group name="LINEGROUP" minHeightToStartNewPage="60" >

<groupExpression>

$F{LINENUM}

</groupExpression>

</group>

 

<detail>

<band height="16" isSplitAllowed="true">

<elementGroup>

<rectangle>

<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="85" height="16" isPrintWhenDetailOverflows="true"/>

<graphicElement/>

</rectangle>

<textField isStretchWithOverflow="true">

<reportElement x="3" y="1" width="75" positionType="Float" stretchType="RelativeToTallestObject" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true"/>

<textElement textAlignment="Justified">

<font reportFont="Arial_Normal" size="11"/>

</textElement>

<textFieldExpression class="java.lang.String">

$F{VALU}

</textFieldExpression>

</textField>

</elementGroup>

</band>

</detail>

</jasperReport>