Jump to content

Report error on >600 pages


dunham

Recommended Posts

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)][/code]

screen_shot_2022-01-26_at_16_21_44.png.42b650b36543652ffd41709f49a1a53f.png

 

screen_shot_2022-01-26_at_16_29_38.png.37cca5d3f7397a38617feec2eefc42c0.png

screen_shot_2022-01-26_at_16_29_44.png.f6756ddd9d6fe024fd68698ca2dfc62f.png

<?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>[/code]

 

<?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,ibresa502dpara03from ibresawhere 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>[/code]

screen_shot_2022-01-26_at_16_29_44.png.b2fa59b2a8291ea95cd92f5c794d52b0.png

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...