Report error on >600 pages

Compiling a Report-(PDF) with >600 data items fails with below error.

Selecting <600 = no error. This tells me the report design is valid. How can I possibly debug this?

-- Jaspersoft 6.5.1 (server)

 

1. error message

2. how report looks as final PDF (1 page each record)

3. report design, 1 + 2

4. code of template 1 + 2
 

Exception: net.sf.dynamicreports.report.exception.DRException: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid :
 
1. The title section, the page and column headers and footers and the margins do not fit the page height.
 
 stack: [net.sf.dynamicreports.jasper.builder.JasperReportBuilder.toJasperReport(JasperReportBuilder.java:293), net.sf.dynamicreports.jasper.builder.JasperReportBuilder.toJasperPrint(JasperReportBuilder.java:324), net.sf.dynamicreports.jasper.builder.JasperReportBuilder.export(JasperReportBuilder.java:599), net.sf.dynamicreports.jasper.builder.JasperReportBuilder.toPdf(JasperReportBuilder.java:536), dynamicreports.Rep3.exportReportFile(Rep3.java:5356), dynamicreports.Rep3.makeReport(Rep3.java:4988), dynamicreports.Rep3.main(Rep3.java:5974)]

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
<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="rsub_1" language="groovy" pageWidth="800" pageHeight="595" orientation="Landscape" columnWidth="800" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="38e6d383-5c3f-43a0-9cbf-73d1a500edaf">
    <template><![CDATA[$P{customFontTemplate}]]></template>
    <scriptlet name="TRANSLATE" class="dynamicreports.Translate"/>
    <parameter name="customFontTemplate" class="java.lang.String" isForPrompting="false"/>
    <parameter name="resuid" class="java.lang.Integer"/>
    <parameter name="id_kunde" class="java.lang.Integer" isForPrompting="false">
        <defaultValueExpression><![CDATA[2]]></defaultValueExpression>
    </parameter>
    <parameter name="lng" class="java.lang.Integer" isForPrompting="false">
        <defaultValueExpression><![CDATA[1]]></defaultValueExpression>
    </parameter>
    <parameter name="mandant" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA["0"]]></defaultValueExpression>
    </parameter>
    <parameter name="datecrea" class="java.util.Date" isForPrompting="false"/>
    <parameter name="datepos" class="java.util.Date" isForPrompting="false"/>
    <parameter name="datefm" class="java.util.Date" isForPrompting="false"/>
    <parameter name="logofn" class="java.lang.String" isForPrompting="false"/>
    <parameter name="colorHeader1" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#C0CFE5"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader2" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#E7F2FD"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorZebra1" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#F6EFE9"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader1_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader2_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorZebra1_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="default_color_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="default_color_line" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#CCCCCC"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormat" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yy"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateTimeFormat" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yyyy HH:mm"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormatHeader" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yyyy"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormatText" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd MMMM yyyy"]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[SELECT *
  FROM ibresa
 where ibresa115crectyp = 'ACC11'
 and ibresa005nid = $P{resuid}
 and ibresa010nidx1 = $P{id_kunde}
 ORDER BY ibresa010nidx1]]>
    </queryString>
    <field name="IBRESA005NID" class="java.math.BigDecimal"/>
    <field name="IBRESA010NIDX1" class="java.math.BigDecimal"/>
    <field name="IBRESA015NIDX2" class="java.math.BigDecimal"/>
    <field name="IBRESA100CSESKEY" class="java.lang.String"/>
    <field name="IBRESA110CREPTYP" class="java.lang.String"/>
    <field name="IBRESA115CRECTYP" class="java.lang.String"/>
    <field name="IBRESA120NLNG" class="java.math.BigDecimal"/>
    <field name="IBRESA125NSTAT" class="java.math.BigDecimal"/>
    <field name="IBRESA130CSUBREPLST" class="java.lang.String"/>
    <field name="IBRESA131CSUBREPLST2" class="java.lang.String"/>
    <field name="IBRESA132CSUBREPLST3" class="java.lang.String"/>
    <field name="IBRESA135CMANDANT" class="java.lang.String"/>
    <field name="IBRESA137NDOCGRP" class="java.math.BigDecimal"/>
    <field name="IBRESA138NDOCTYP" class="java.math.BigDecimal"/>
    <field name="IBRESA140CUSERCRE" class="java.lang.String"/>
    <field name="IBRESA141CUSERMFY" class="java.lang.String"/>
    <field name="IBRESA142CUSERDEL" class="java.lang.String"/>
    <field name="IBRESA145NUSRCRE" class="java.math.BigDecimal"/>
    <field name="IBRESA150DCRE" class="java.sql.Timestamp"/>
    <field name="IBRESA151DMFY" class="java.sql.Timestamp"/>
    <field name="IBRESA152DDEL" class="java.sql.Timestamp"/>
    <field name="IBRESA155DREQFM" class="java.sql.Timestamp"/>
    <field name="IBRESA156DREQTO" class="java.sql.Timestamp"/>
    <field name="IBRESA157DREP" class="java.sql.Timestamp"/>
    <field name="IBRESA160NUSR" class="java.math.BigDecimal"/>
    <field name="IBRESA161NDEP" class="java.math.BigDecimal"/>
    <field name="IBRESA162NACC" class="java.math.BigDecimal"/>
    <field name="IBRESA163CYYYYMM" class="java.lang.String"/>
    <field name="IBRESA164NTRANID" class="java.math.BigDecimal"/>
    <field name="IBRESA166NSECMID" class="java.math.BigDecimal"/>
    <field name="IBRESA167NINS" class="java.math.BigDecimal"/>
    <field name="IBRESA168CCCYTK" class="java.lang.String"/>
    <field name="IBRESA169CCCYISO" class="java.lang.String"/>
    <field name="IBRESA170NIBOUT" class="java.math.BigDecimal"/>
    <field name="IBRESA175CREPCMD" class="java.lang.String"/>
    <field name="IBRESA176COUTFNM" class="java.lang.String"/>
    <field name="IBRESA180NINDLOGO" class="java.math.BigDecimal"/>
    <field name="IBRESA181NINDRESETPNR" class="java.math.BigDecimal"/>
    <field name="IBRESA182NINDARCMULTI" class="java.math.BigDecimal"/>
    <field name="IBRESA183NINDARCSINGL" class="java.math.BigDecimal"/>
    <field name="IBRESA190CORIENT" class="java.lang.String"/>
    <field name="IBRESA191CFONTNM" class="java.lang.String"/>
    <field name="IBRESA192CFONTSZ" class="java.lang.String"/>
    <field name="IBRESA193CWATMRK" class="java.lang.String"/>
    <field name="IBRESA200CPARA01" class="java.lang.String"/>
    <field name="IBRESA201CPARA02" class="java.lang.String"/>
    <field name="IBRESA202CPARA03" class="java.lang.String"/>
    <field name="IBRESA203CPARA04" class="java.lang.String"/>
    <field name="IBRESA204CPARA05" class="java.lang.String"/>
    <field name="IBRESA205CPARA06" class="java.lang.String"/>
    <field name="IBRESA206CPARA07" class="java.lang.String"/>
    <field name="IBRESA207CPARA08" class="java.lang.String"/>
    <field name="IBRESA208CPARA09" class="java.lang.String"/>
    <field name="IBRESA209CPARA10" class="java.lang.String"/>
    <field name="IBRESA210CPARA11" class="java.lang.String"/>
    <field name="IBRESA211CPARA12" class="java.lang.String"/>
    <field name="IBRESA212CPARA13" class="java.lang.String"/>
    <field name="IBRESA213CPARA14" class="java.lang.String"/>
    <field name="IBRESA214CPARA15" class="java.lang.String"/>
    <field name="IBRESA215CPARA16" class="java.lang.String"/>
    <field name="IBRESA216CPARA17" class="java.lang.String"/>
    <field name="IBRESA217CPARA18" class="java.lang.String"/>
    <field name="IBRESA218CPARA19" class="java.lang.String"/>
    <field name="IBRESA219CPARA20" class="java.lang.String"/>
    <field name="IBRESA300IPARA01" class="java.math.BigDecimal"/>
    <field name="IBRESA301IPARA02" class="java.math.BigDecimal"/>
    <field name="IBRESA302IPARA03" class="java.math.BigDecimal"/>
    <field name="IBRESA303IPARA04" class="java.math.BigDecimal"/>
    <field name="IBRESA304IPARA05" class="java.math.BigDecimal"/>
    <field name="IBRESA305IPARA06" class="java.math.BigDecimal"/>
    <field name="IBRESA306IPARA07" class="java.math.BigDecimal"/>
    <field name="IBRESA307IPARA08" class="java.math.BigDecimal"/>
    <field name="IBRESA308IPARA09" class="java.math.BigDecimal"/>
    <field name="IBRESA309IPARA10" class="java.math.BigDecimal"/>
    <field name="IBRESA310IPARA11" class="java.math.BigDecimal"/>
    <field name="IBRESA311IPARA12" class="java.math.BigDecimal"/>
    <field name="IBRESA312IPARA13" class="java.math.BigDecimal"/>
    <field name="IBRESA313IPARA14" class="java.math.BigDecimal"/>
    <field name="IBRESA314IPARA15" class="java.math.BigDecimal"/>
    <field name="IBRESA315IPARA16" class="java.math.BigDecimal"/>
    <field name="IBRESA316IPARA17" class="java.math.BigDecimal"/>
    <field name="IBRESA317IPARA18" class="java.math.BigDecimal"/>
    <field name="IBRESA318IPARA19" class="java.math.BigDecimal"/>
    <field name="IBRESA319IPARA20" class="java.math.BigDecimal"/>
    <field name="IBRESA400NPARA01" class="java.math.BigDecimal"/>
    <field name="IBRESA401NPARA02" class="java.math.BigDecimal"/>
    <field name="IBRESA402NPARA03" class="java.math.BigDecimal"/>
    <field name="IBRESA403NPARA04" class="java.math.BigDecimal"/>
    <field name="IBRESA404NPARA05" class="java.math.BigDecimal"/>
    <field name="IBRESA405NPARA06" class="java.math.BigDecimal"/>
    <field name="IBRESA406NPARA07" class="java.math.BigDecimal"/>
    <field name="IBRESA407NPARA08" class="java.math.BigDecimal"/>
    <field name="IBRESA408NPARA09" class="java.math.BigDecimal"/>
    <field name="IBRESA409NPARA10" class="java.math.BigDecimal"/>
    <field name="IBRESA410NPARA11" class="java.math.BigDecimal"/>
    <field name="IBRESA411NPARA12" class="java.math.BigDecimal"/>
    <field name="IBRESA412NPARA13" class="java.math.BigDecimal"/>
    <field name="IBRESA413NPARA14" class="java.math.BigDecimal"/>
    <field name="IBRESA414NPARA15" class="java.math.BigDecimal"/>
    <field name="IBRESA415NPARA16" class="java.math.BigDecimal"/>
    <field name="IBRESA416NPARA17" class="java.math.BigDecimal"/>
    <field name="IBRESA417NPARA18" class="java.math.BigDecimal"/>
    <field name="IBRESA418NPARA19" class="java.math.BigDecimal"/>
    <field name="IBRESA419NPARA20" class="java.math.BigDecimal"/>
    <field name="IBRESA500DPARA01" class="java.sql.Timestamp"/>
    <field name="IBRESA501DPARA02" class="java.sql.Timestamp"/>
    <field name="IBRESA502DPARA03" class="java.sql.Timestamp"/>
    <field name="IBRESA503DPARA04" class="java.sql.Timestamp"/>
    <field name="IBRESA504DPARA05" class="java.sql.Timestamp"/>
    <field name="IBRESA505DPARA06" class="java.sql.Timestamp"/>
    <field name="IBRESA506DPARA07" class="java.sql.Timestamp"/>
    <field name="IBRESA507DPARA08" class="java.sql.Timestamp"/>
    <field name="IBRESA508DPARA09" class="java.sql.Timestamp"/>
    <field name="IBRESA509DPARA10" class="java.sql.Timestamp"/>
    <field name="IBRESA510DPARA11" class="java.sql.Timestamp"/>
    <field name="IBRESA511DPARA12" class="java.sql.Timestamp"/>
    <field name="IBRESA512DPARA13" class="java.sql.Timestamp"/>
    <field name="IBRESA513DPARA14" class="java.sql.Timestamp"/>
    <field name="IBRESA514DPARA15" class="java.sql.Timestamp"/>
    <field name="IBRESA515DPARA16" class="java.sql.Timestamp"/>
    <field name="IBRESA516DPARA17" class="java.sql.Timestamp"/>
    <field name="IBRESA517DPARA18" class="java.sql.Timestamp"/>
    <field name="IBRESA518DPARA19" class="java.sql.Timestamp"/>
    <field name="IBRESA519DPARA20" class="java.sql.Timestamp"/>
    <variable name="isEvenRow" class="java.lang.Integer">
        <variableExpression><![CDATA[(
    $V{REPORT_COUNT}.intValue() % 2 == 0 ?
    1 :
    0
)]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <title>
        <band height="160" splitType="Stretch">
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="139" y="62" width="260" height="13" uuid="e22e0700-6b18-4d82-9899-0cefd32aed4e"/>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA202CPARA03}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="5" y="49" width="134" height="13" uuid="7bc9097e-3e6b-4173-8321-78c83f9821a5"/>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKontoinhaber")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Opaque" x="2" y="16" width="580" height="18" uuid="e1f89bc5-d39f-40ee-b92d-6656e3e3b314">
                    <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$P{colorHeader1}]]></propertyExpression>
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle" markup="none">
                    <font size="14" isBold="true"/>
                    <paragraph leftIndent="2"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKontoauszug")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="5" y="88" width="134" height="13" uuid="37baf072-726c-486d-b1ce-ce8b9c36ab50"/>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lDepotbank")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="405" y="62" width="102" height="13" uuid="fc7435c6-bfd7-425f-8586-d1611cf7e7e0"/>
                <textElement textAlignment="Right" markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKontoauszvon")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="5" y="62" width="134" height="13" uuid="ccb47470-9b32-4c85-9b20-61b135d9fc14"/>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKtoNrAnzeige")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="5" y="75" width="134" height="13" uuid="bf44a1e8-96ae-470f-88a4-75de7aeb38e5"/>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKontobez")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="405" y="49" width="102" height="13" uuid="6e54b0e2-3d5c-4ebd-b092-7c1a10631884"/>
                <textElement textAlignment="Right" markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lDatumerstellt")]]></textFieldExpression>
            </textField>
            <line>
                <reportElement x="2" y="10" width="796" height="1" uuid="922d9b82-5601-4899-9931-894b10d98911"/>
                <graphicElement>
                    <pen lineWidth="0.5" lineColor="#3A3430"/>
                </graphicElement>
            </line>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="139" y="49" width="260" height="13" uuid="377436ca-8b1b-49db-8049-63cf5a43c116"/>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA206CPARA07}]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="139" y="75" width="260" height="13" uuid="3587744c-5393-4fa9-9b65-c4d680bbaac5"/>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA214CPARA15}]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="139" y="88" width="260" height="13" uuid="be76d4a0-7e0a-45af-b9d6-49311f5e2c3a"/>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA207CPARA08}]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" x="507" y="62" width="73" height="13" uuid="4223684d-a521-451b-8f27-336a384f17cc"/>
                <textElement textAlignment="Right">
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{datefm}]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormatHeader}]]></patternExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" x="507" y="49" width="73" height="13" uuid="9e8acbd9-d445-45e1-a8d6-ea73435a77e3"/>
                <textElement textAlignment="Right">
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{datecrea}]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormatHeader}]]></patternExpression>
            </textField>
            <image hAlign="Right" vAlign="Top" onErrorType="Blank">
                <reportElement style="font" x="632" y="16" width="166" height="75" uuid="dc29fbe3-660b-42b8-aeae-6ea725ca50c4"/>
                <imageExpression><![CDATA[net.sf.jasperreports.renderers.BatikRenderer.getInstance(new java.io.File($P{logofn}))]]></imageExpression>
            </image>
            <textField>
                <reportElement style="font" x="5" y="101" width="134" height="13" uuid="4dd7134d-5c7f-4275-9e5d-c210f729686d"/>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lWhgKtotyp")]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="139" y="101" width="260" height="13" uuid="beb2af73-454b-4d71-b33a-9b6664d2b490"/>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA201CPARA02} + " / " + $F{IBRESA209CPARA10}]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" x="507" y="75" width="73" height="13" uuid="f8b2a814-376f-4ed6-bf12-df90f656257a"/>
                <textElement textAlignment="Right">
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{datepos}]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormatHeader}]]></patternExpression>
            </textField>
            <textField>
                <reportElement style="font" x="405" y="75" width="102" height="13" uuid="c38026bb-cd8f-49e5-bfb3-e2faccb645d6"/>
                <textElement textAlignment="Right" markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lKontoauszbis")]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="810" y="46" width="68" height="13" forecolor="#FFFFFF" uuid="4d7c1fde-f41e-42d0-8ef6-db9dc0462fcd"/>
                <textElement textAlignment="Right">
                    <font size="6"/>
                </textElement>
                <textFieldExpression><![CDATA["ndep_" + $F{IBRESA161NDEP} + "ndepE_"]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="810" y="33" width="68" height="13" forecolor="#FFFFFF" uuid="0f7e1f68-fafd-45d0-9620-d6eb2d2a9532"/>
                <textElement textAlignment="Right">
                    <font size="6"/>
                </textElement>
                <textFieldExpression><![CDATA["nusr_" + $F{IBRESA160NUSR} + "nusrE_"]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="340" y="127" width="200" height="13" isRemoveLineWhenBlank="true" uuid="b9827220-294a-444f-a110-e1718c762ba9">
                    <printWhenExpression><![CDATA[($F{IBRESA210CPARA11} != null)]]></printWhenExpression>
                </reportElement>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA213CPARA14}]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="140" y="127" width="200" height="13" isRemoveLineWhenBlank="true" uuid="05067086-5f63-4fd9-b5fe-b02f17d240d4">
                    <printWhenExpression><![CDATA[($F{IBRESA210CPARA11} != null)]]></printWhenExpression>
                </reportElement>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA212CPARA13}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" x="6" y="114" width="134" height="13" isRemoveLineWhenBlank="true" uuid="acf96b12-bfbf-48dd-b37b-c5569f1b5fd1">
                    <printWhenExpression><![CDATA[($F{IBRESA210CPARA11} != null)]]></printWhenExpression>
                </reportElement>
                <textElement markup="none">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lBeschreibung")]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="140" y="114" width="200" height="13" isRemoveLineWhenBlank="true" uuid="19940122-e3d8-4d65-8dca-966e930e0a50">
                    <printWhenExpression><![CDATA[($F{IBRESA210CPARA11} != null)]]></printWhenExpression>
                </reportElement>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA210CPARA11}]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" x="340" y="114" width="200" height="13" isRemoveLineWhenBlank="true" uuid="f35105db-2090-40eb-9bf3-13b7ef088659">
                    <printWhenExpression><![CDATA[($F{IBRESA210CPARA11} != null)]]></printWhenExpression>
                </reportElement>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA211CPARA12}]]></textFieldExpression>
            </textField>
        </band>
    </title>
</jasperReport>

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
<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="rsub_1" language="groovy" pageWidth="800" pageHeight="595" orientation="Landscape" columnWidth="800" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="19c1353e-8ed1-4b13-b427-3d91b0b657c0">
    <template><![CDATA[$P{customFontTemplate}]]></template>
    <scriptlet name="TRANSLATE" class="dynamicreports.Translate"/>
    <parameter name="customFontTemplate" class="java.lang.String" isForPrompting="false"/>
    <parameter name="lng" class="java.lang.Integer" isForPrompting="false">
        <defaultValueExpression><![CDATA[1]]></defaultValueExpression>
    </parameter>
    <parameter name="mandant" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA["0"]]></defaultValueExpression>
    </parameter>
    <parameter name="resuid" class="java.lang.Integer"/>
    <parameter name="id_kunde" class="java.lang.Integer" isForPrompting="false">
        <defaultValueExpression><![CDATA[2]]></defaultValueExpression>
    </parameter>
    <parameter name="ccy" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA["CHF"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader1" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#C0CFE5"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader2" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#E7F2FD"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorZebra1" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#F6EFE9"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader1_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorHeader2_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="colorZebra1_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="default_color_text" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#000000"]]></defaultValueExpression>
    </parameter>
    <parameter name="default_color_line" class="java.lang.String">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["#CCCCCC"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormat" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yy"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateTimeFormat" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yyyy HH:mm"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormatHeader" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd.MM.yyyy"]]></defaultValueExpression>
    </parameter>
    <parameter name="DateFormatText" class="java.lang.String" isForPrompting="false">
        <parameterDescription><![CDATA[]]></parameterDescription>
        <defaultValueExpression><![CDATA["dd MMMM yyyy"]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[select ibresa005nid,
ibresa010nidx1,
ibresa015nidx2,
ibresa160nusr,
ibresa161ndep,
ibresa162nacc,
ibresa200cpara01,
ibresa201cpara02,
ibresa202cpara03,
ibresa203cpara04,
ibresa300ipara01,
ibresa400npara01,
ibresa401npara02,
ibresa402npara03,
ibresa403npara04,
ibresa500dpara01,
ibresa501dpara02,
ibresa502dpara03
from ibresa
where ibresa115crectyp = 'AMV01'
and ibresa005nid = $P{resuid}
and ibresa010nidx1 = $P{id_kunde}
order by ibresa015nidx2 ASC]]>
    </queryString>
    <field name="IBRESA005NID" class="java.math.BigDecimal"/>
    <field name="IBRESA010NIDX1" class="java.math.BigDecimal"/>
    <field name="IBRESA015NIDX2" class="java.math.BigDecimal"/>
    <field name="IBRESA160NUSR" class="java.math.BigDecimal"/>
    <field name="IBRESA161NDEP" class="java.math.BigDecimal"/>
    <field name="IBRESA162NACC" class="java.math.BigDecimal"/>
    <field name="IBRESA200CPARA01" class="java.lang.String"/>
    <field name="IBRESA201CPARA02" class="java.lang.String"/>
    <field name="IBRESA202CPARA03" class="java.lang.String"/>
    <field name="IBRESA203CPARA04" class="java.lang.String"/>
    <field name="IBRESA300IPARA01" class="java.math.BigDecimal"/>
    <field name="IBRESA400NPARA01" class="java.math.BigDecimal"/>
    <field name="IBRESA401NPARA02" class="java.math.BigDecimal"/>
    <field name="IBRESA402NPARA03" class="java.math.BigDecimal"/>
    <field name="IBRESA403NPARA04" class="java.math.BigDecimal"/>
    <field name="IBRESA500DPARA01" class="java.sql.Timestamp"/>
    <field name="IBRESA501DPARA02" class="java.sql.Timestamp"/>
    <field name="IBRESA502DPARA03" class="java.sql.Timestamp"/>
    <variable name="sumbelastung" class="java.lang.Double" calculation="Sum">
        <variableExpression><![CDATA[$F{IBRESA401NPARA02}]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <variable name="sumgutschrift" class="java.lang.Double" calculation="Sum">
        <variableExpression><![CDATA[$F{IBRESA402NPARA03}]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <variable name="subende" class="java.lang.Double">
        <variableExpression><![CDATA[$F{IBRESA403NPARA04}]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <variable name="isEvenRow" class="java.lang.Integer">
        <variableExpression><![CDATA[(
    $V{REPORT_COUNT}.intValue() % 2 == 0 ?
    1 :
    0
)]]></variableExpression>
        <initialValueExpression><![CDATA[0]]></initialValueExpression>
    </variable>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band splitType="Stretch"/>
    </title>
    <pageHeader>
        <band splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band height="50" splitType="Stretch">
            <line>
                <reportElement mode="Opaque" x="2" y="10" width="796" height="1" forecolor="#000000" uuid="80da1450-16e5-40b6-b342-1b2952775878"/>
                <graphicElement>
                    <pen lineWidth="0.5" lineColor="#3A3430"/>
                </graphicElement>
            </line>
            <rectangle>
                <reportElement mode="Opaque" x="2" y="16" width="796" height="30" uuid="06658ac8-3921-4c7c-9266-5fd2fadac952">
                    <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$P{colorHeader1}]]></propertyExpression>
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <graphicElement>
                    <pen lineWidth="0.0"/>
                </graphicElement>
            </rectangle>
            <textField>
                <reportElement style="font" mode="Transparent" x="5" y="31" width="55" height="13" uuid="de9b13d0-f8c5-4bab-a3b8-8cf2f66c5288">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lDatum")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="5" y="18" width="55" height="13" uuid="53b4e06d-529b-463e-b439-414118d0b95d">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lBuchungs")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="60" y="31" width="55" height="13" uuid="7fb0c04f-1c53-4727-9c1c-2578f3b15698">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lDatum")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="60" y="18" width="55" height="13" uuid="33fa060e-115b-4405-9f14-6631af9fb873">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lAbschluss")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="115" y="18" width="70" height="13" uuid="f936e246-1764-4882-9edb-54075ed3455a">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lTyp")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="185" y="18" width="96" height="13" uuid="7a12961c-0cd2-4db2-96cf-f59611c10a5d">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lBuchungstext")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="454" y="18" width="65" height="13" uuid="9fa7ea80-6c78-401b-8c7d-881bda7fa321">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lBuchungsNo")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="594" y="18" width="75" height="13" uuid="17c4ba14-12e4-40c2-ae70-e40e6cb870cf">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lGutschrift")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="519" y="18" width="75" height="13" uuid="55eefa9d-40a3-4dfc-bdbe-51f279006c01">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lBelastung")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="669" y="18" width="52" height="13" uuid="e195b812-822a-40a7-9984-ac0ea3e1021c">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lValuta")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="724" y="18" width="72" height="13" uuid="52949341-341b-4714-9c4f-c563109acb20">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lSaldo")]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="669" y="31" width="52" height="13" uuid="23e9b92b-ede0-4495-ad59-f05ce5db1c2a">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader1_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right">
                    <font size="9" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lDatum")]]></textFieldExpression>
            </textField>
        </band>
    </columnHeader>
    <detail>
        <band height="14" splitType="Stretch">
            <rectangle>
                <reportElement mode="Opaque" x="2" y="0" width="796" height="14" uuid="b18afea4-0dd1-4aaa-b6bc-c4ea5e128563">
                    <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$P{colorZebra1}]]></propertyExpression>
                    <printWhenExpression><![CDATA[new Boolean( $V{isEvenRow} == 1 )]]></printWhenExpression>
                </reportElement>
                <graphicElement>
                    <pen lineWidth="0.0"/>
                </graphicElement>
            </rectangle>
            <textField isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="115" y="0" width="70" height="13" uuid="2f90c152-ba05-496f-881a-588b20e42983">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA202CPARA03}]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="60" y="0" width="55" height="13" uuid="9a780c5a-fd24-4d98-b48b-1dfe6d6cc317">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA501DPARA02}]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormat}]]></patternExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="669" y="0" width="52" height="13" uuid="149f0e56-4300-435a-a5d0-cc8535c27efc">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $F{IBRESA502DPARA03} == 0 ?
    "" :
    $F{IBRESA502DPARA03}
)]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormat}]]></patternExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="519" y="0" width="75" height="13" uuid="5327bcc5-876c-4c80-bd03-39c79765c46e">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $F{IBRESA401NPARA02} < 0 ?
    $F{IBRESA401NPARA02} * -1 :
    $F{IBRESA401NPARA02} == 0 ?
    "" :
    $F{IBRESA401NPARA02}
)]]></textFieldExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="185" y="0" width="269" height="13" uuid="f3f42a5b-ecad-4768-bac0-2938cd8bdf56">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA203CPARA04}]]></textFieldExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="594" y="0" width="75" height="13" uuid="b6292c18-ccb6-4cad-a2d2-ff5968d743ad">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $F{IBRESA402NPARA03} == 0 ?
    "" :
    $F{IBRESA402NPARA03}
)]]></textFieldExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="721" y="0" width="75" height="13" uuid="214ccd01-b4cd-4ad8-a864-404fde2aae85">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA403NPARA04}]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="5" y="0" width="55" height="13" uuid="0ed89a87-d226-4b24-8b59-21ce48757294">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{IBRESA500DPARA01}]]></textFieldExpression>
                <patternExpression><![CDATA[$P{DateFormat}]]></patternExpression>
            </textField>
            <textField isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="454" y="0" width="65" height="13" uuid="f26288a0-a586-49a5-a12a-ba1bb82a3ca7">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$V{isEvenRow} == 1 ? $P{colorZebra1_text} : $P{default_color_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $F{IBRESA300IPARA01} == 0 ?
    "" :
    $F{IBRESA300IPARA01}
)]]></textFieldExpression>
            </textField>
        </band>
    </detail>
    <columnFooter>
        <band splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band splitType="Stretch"/>
    </pageFooter>
    <summary>
        <band height="68" splitType="Stretch">
            <textField>
                <reportElement style="font" mode="Opaque" x="2" y="23" width="796" height="14" uuid="e525a3ba-c877-4349-9eb0-4452541bb5d3">
                    <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$P{colorHeader2}]]></propertyExpression>
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader2_text}]]></propertyExpression>
                </reportElement>
                <textElement verticalAlignment="Middle">
                    <font size="9"/>
                    <paragraph leftIndent="2"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lTotal")]]></textFieldExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="706" y="23" width="90" height="14" uuid="af363d69-3df0-4172-8e89-0c36df0ad175">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader2_text}]]></propertyExpression>
                </reportElement>
                <textElement textAlignment="Right" verticalAlignment="Middle">
                    <font size="8"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $V{subende} < 0 ?
    $V{subende} * -1 :
    $V{subende}
)]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement style="font" mode="Transparent" x="115" y="24" width="148" height="13" uuid="12f9902c-1570-4710-8400-aaa880927ce0">
                    <propertyExpression name="net.sf.jasperreports.style.forecolor"><![CDATA[$P{colorHeader2_text}]]></propertyExpression>
                </reportElement>
                <textElement>
                    <font size="9"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $V{subende} < 0 ?
    $P{TRANSLATE_SCRIPTLET}.translate("lSaldozuLasten") :
    $P{TRANSLATE_SCRIPTLET}.translate("lSaldozuGunsten")
)]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="115" y="2" width="70" height="13" uuid="43d75ea2-ada7-44ed-a889-a4d0b2cc0216"/>
                <textElement>
                    <font size="8" isItalic="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$P{TRANSLATE_SCRIPTLET}.translate("lUmsatz")]]></textFieldExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="594" y="2" width="75" height="13" uuid="305a693e-cc5a-4ca4-91c1-6add8a89a2c1"/>
                <textElement textAlignment="Right">
                    <font size="8" isItalic="true"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $V{sumgutschrift} == 0 ?
    "" :
    $V{sumgutschrift}
)]]></textFieldExpression>
            </textField>
            <textField pattern="#,##0.00" isBlankWhenNull="true">
                <reportElement style="font" mode="Transparent" x="519" y="2" width="75" height="13" uuid="3fbcf9a9-5088-4199-bc6c-fa26a9fec72a"/>
                <textElement textAlignment="Right">
                    <font size="8" isItalic="true"/>
                </textElement>
                <textFieldExpression><![CDATA[(
    $V{sumbelastung} < 0 ?
    $V{sumbelastung} * -1 :
    $V{sumbelastung} == 0 ?
    "" :
    $V{sumbelastung}
)]]></textFieldExpression>
            </textField>
        </band>
    </summary>
</jasperReport>
dunham's picture
305
Joined: Oct 18 2013 - 6:57am
Last seen: 1 month 5 days ago

0 Answers:

No answers yet
Feedback