dunham Posted January 26, 2022 Share Posted January 26, 2022 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 message2. how report looks as final PDF (1 page each record)3. report design, 1 + 24. 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] <?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] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now