| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574 |
- <?xml version="1.0" encoding="UTF-8"?>
- <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="InquiryStatement" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
- <property name="ireport.zoom" value="1.771561000000022"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="126"/>
- <parameter name="reportFilter" class="java.lang.String">
- <defaultValueExpression><![CDATA["1=1"]]></defaultValueExpression>
- </parameter>
- <parameter name="periodeStart" class="java.sql.Timestamp"/>
- <parameter name="periodeEnd" class="java.sql.Timestamp"/>
- <parameter name="rekening" class="java.lang.String"/>
- <parameter name="billerName" class="java.lang.String" isForPrompting="false"/>
- <parameter name="pathImage" class="java.lang.String"/>
- <parameter name="printdate" class="java.sql.Timestamp" isForPrompting="false"/>
- <parameter name="schema" class="java.lang.String">
- <defaultValueExpression><![CDATA["P"]]></defaultValueExpression>
- </parameter>
- <parameter name="description" class="java.lang.String"/>
- <parameter name="saldoDate" class="java.util.Date"/>
- <parameter name="branchName" class="java.lang.String"/>
- <parameter name="printBy" class="java.lang.String" isForPrompting="false"/>
- <queryString>
- <![CDATA[SELECT uncode, branch, treff6, trdat6, cfna2, cfna3, trremk, trtktn, trtime, trdorc, amt, auxtrc, serial, trancd, stdbal, sname,
- CASE WHEN TRUSER != '' THEN 0 ELSE 1 END AS TRUSER
- FROM bw$P!{schema}dat.DDBHIS
- WHERE $P!{reportFilter}
- ORDER BY TRDATE, TRUSER, TRTIME ASC]]>
- </queryString>
- <field name="UNCODE" class="java.math.BigDecimal"/>
- <field name="BRANCH" class="java.math.BigDecimal"/>
- <field name="TREFF6" class="java.math.BigDecimal"/>
- <field name="TRDAT6" class="java.math.BigDecimal"/>
- <field name="CFNA2" class="java.lang.String"/>
- <field name="CFNA3" class="java.lang.String"/>
- <field name="TRREMK" class="java.lang.String"/>
- <field name="TRTKTN" class="java.lang.String"/>
- <field name="TRTIME" class="java.lang.String"/>
- <field name="TRDORC" class="java.lang.String"/>
- <field name="AMT" class="java.math.BigDecimal"/>
- <field name="AUXTRC" class="java.lang.String"/>
- <field name="SERIAL" class="java.math.BigDecimal"/>
- <field name="TRANCD" class="java.math.BigDecimal"/>
- <field name="STDBAL" class="java.math.BigDecimal"/>
- <field name="SNAME" class="java.lang.String"/>
- <field name="TRUSER" class="java.lang.Integer"/>
- <variable name="initialBalance" class="java.math.BigDecimal">
- <variableExpression><![CDATA[$V{initialBalance} == null ? $F{STDBAL} : $V{initialBalance}]]></variableExpression>
- <initialValueExpression><![CDATA[$F{STDBAL}]]></initialValueExpression>
- </variable>
- <variable name="totalDebitKredit" class="java.math.BigDecimal">
- <variableExpression><![CDATA[$F{TRDORC} == 'D' ? $V{totalDebitKredit}.subtract($F{AMT}) : ($F{TRDORC} == 'C' ? $V{totalDebitKredit}.add($F{AMT}) : $V{totalDebitKredit})]]></variableExpression>
- <initialValueExpression><![CDATA[BigDecimal.ZERO]]></initialValueExpression>
- </variable>
- <variable name="currentBalance" class="java.math.BigDecimal">
- <variableExpression><![CDATA[$V{initialBalance}.add($V{totalDebitKredit})]]></variableExpression>
- <initialValueExpression><![CDATA[$F{STDBAL}]]></initialValueExpression>
- </variable>
- <variable name="totalDebit" class="java.math.BigDecimal" calculation="Sum">
- <variableExpression><![CDATA[$F{TRDORC} == "D" ? $F{AMT} : 0]]></variableExpression>
- </variable>
- <variable name="totalCredit" class="java.math.BigDecimal" calculation="Sum">
- <variableExpression><![CDATA[$F{TRDORC} == "C" ? $F{AMT} : 0]]></variableExpression>
- </variable>
- <variable name="countDebit" class="java.lang.Integer" calculation="Sum">
- <variableExpression><![CDATA[$F{TRDORC} == "D" ? 1 : 0]]></variableExpression>
- <initialValueExpression><![CDATA[0]]></initialValueExpression>
- </variable>
- <variable name="countCredit" class="java.lang.Integer" calculation="Sum">
- <variableExpression><![CDATA[$F{TRDORC} == "C" ? 1 : 0]]></variableExpression>
- <initialValueExpression><![CDATA[0]]></initialValueExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band height="32" splitType="Stretch">
- <staticText>
- <reportElement x="0" y="0" width="802" height="32"/>
- <textElement>
- <font fontName="Arial Narrow" size="22" isBold="true"/>
- </textElement>
- <text><![CDATA[Report Rekening Koran]]></text>
- </staticText>
- </band>
- </title>
- <pageHeader>
- <band height="120" splitType="Stretch">
- <staticText>
- <reportElement x="344" y="0" width="35" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[Branch]]></text>
- </staticText>
- <staticText>
- <reportElement x="379" y="0" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="344" y="20" width="35" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[Periode]]></text>
- </staticText>
- <staticText>
- <reportElement x="379" y="20" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" pattern="dd-MMM-yyyy" isBlankWhenNull="true">
- <reportElement x="393" y="20" width="105" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{periodeStart}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="dd-MMM-yyyy" isBlankWhenNull="true">
- <reportElement x="515" y="20" width="113" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{periodeEnd}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="498" y="20" width="17" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[-]]></text>
- </staticText>
- <staticText>
- <reportElement x="321" y="40" width="58" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[No Rekening]]></text>
- </staticText>
- <staticText>
- <reportElement x="379" y="40" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="393" y="40" width="235" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$P{rekening}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="344" y="60" width="35" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[Name]]></text>
- </staticText>
- <staticText>
- <reportElement x="379" y="60" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="333" y="80" width="46" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[Address]]></text>
- </staticText>
- <staticText>
- <reportElement x="379" y="80" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="393" y="80" width="235" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{CFNA2}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="393" y="100" width="235" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{CFNA3}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="0" y="0" width="239" height="20"/>
- <textElement>
- <font fontName="Arial Narrow" isBold="true"/>
- </textElement>
- <text><![CDATA[PT. Bank Tabungan Negara(Persero), Tbk]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="58" width="69" height="20"/>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" isBold="true"/>
- </textElement>
- <text><![CDATA[Date Printed]]></text>
- </staticText>
- <image>
- <reportElement x="0" y="20" width="189" height="38"/>
- <imageExpression class="java.lang.String"><![CDATA[$P{pathImage}]]></imageExpression>
- </image>
- <staticText>
- <reportElement x="69" y="58" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" pattern="dd-MMM-yy HH:mm:ss" isBlankWhenNull="true">
- <reportElement x="83" y="58" width="126" height="20"/>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{printdate}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="393" y="0" width="235" height="20"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$P{branchName}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="393" y="60" width="235" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{SNAME}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="0" y="78" width="69" height="20"/>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" isBold="true"/>
- </textElement>
- <text><![CDATA[Printed By]]></text>
- </staticText>
- <staticText>
- <reportElement x="69" y="78" width="14" height="20"/>
- <textElement textAlignment="Center">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField>
- <reportElement x="83" y="78" width="126" height="20"/>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$P{printBy}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="66" splitType="Stretch">
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="69" height="35"/>
- <box leftPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[TRANS DATE]]></text>
- </staticText>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="69" y="0" width="64" height="35"/>
- <box leftPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[EFF DATE]]></text>
- </staticText>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="134" y="0" width="244" height="35"/>
- <box leftPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[TRANS DESCRIPTION]]></text>
- </staticText>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="442" y="0" width="101" height="35"/>
- <box leftPadding="0" rightPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[DEBIT]]></text>
- </staticText>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="543" y="0" width="102" height="35"/>
- <box leftPadding="0" rightPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[KREDIT]]></text>
- </staticText>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="645" y="0" width="157" height="35"/>
- <box leftPadding="0" rightPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[LEDGER BALANCE]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="134" y="35" width="245" height="31"/>
- <box topPadding="5" leftPadding="3"/>
- <textElement verticalAlignment="Top">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{TRREMK} == null ? $F{TRREMK} : $P{description}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
- <reportElement x="0" y="35" width="69" height="31">
- <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
- </reportElement>
- <box topPadding="5" leftPadding="3"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.util.Date"><![CDATA[$P{saldoDate}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
- <reportElement x="69" y="35" width="64" height="31">
- <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
- </reportElement>
- <box topPadding="5" leftPadding="3"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.util.Date"><![CDATA[$P{saldoDate}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement stretchType="RelativeToBandHeight" x="378" y="0" width="64" height="35"/>
- <box leftPadding="2">
- <pen lineStyle="Solid"/>
- <topPen lineWidth="1.0" lineStyle="Solid"/>
- <leftPen lineStyle="Solid"/>
- <bottomPen lineWidth="1.0" lineStyle="Solid"/>
- <rightPen lineStyle="Solid"/>
- </box>
- <textElement verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="9" isBold="true"/>
- </textElement>
- <text><![CDATA[POSTING TIME]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="645" y="35" width="157" height="31" isPrintWhenDetailOverflows="true"/>
- <box topPadding="5" rightPadding="5"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow" size="10"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{currentBalance}]]></textFieldExpression>
- </textField>
- </band>
- </columnHeader>
- <detail>
- <band height="31" splitType="Stretch">
- <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
- <reportElement x="0" y="0" width="69" height="31" isPrintWhenDetailOverflows="true"/>
- <box topPadding="5" leftPadding="3"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.util.Date"><![CDATA[new SimpleDateFormat("ddMMyy").parse($F{TRDAT6}.toString().length() == 5 ? "0"+$F{TRDAT6}.toString() : $F{TRDAT6}.toString())]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
- <reportElement x="69" y="0" width="64" height="31" isPrintWhenDetailOverflows="true"/>
- <box topPadding="5" leftPadding="3"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.util.Date"><![CDATA[new SimpleDateFormat("ddMMyy").parse($F{TREFF6}.toString().length() == 5 ? "0"+$F{TREFF6}.toString() : $F{TREFF6}.toString())]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="133" y="0" width="246" height="31" isPrintWhenDetailOverflows="true"/>
- <box topPadding="5" leftPadding="3"/>
- <textElement verticalAlignment="Top">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{TRREMK}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="442" y="0" width="101" height="31" isPrintWhenDetailOverflows="true">
- <printWhenExpression><![CDATA[$F{TRDORC} == "D"]]></printWhenExpression>
- </reportElement>
- <box topPadding="5" rightPadding="2"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMT}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="543" y="0" width="102" height="31" isPrintWhenDetailOverflows="true">
- <printWhenExpression><![CDATA[$F{TRDORC} == "C"]]></printWhenExpression>
- </reportElement>
- <box topPadding="5" rightPadding="2"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMT}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="645" y="0" width="157" height="31" isPrintWhenDetailOverflows="true"/>
- <box topPadding="5" rightPadding="5"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow" size="10"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{currentBalance}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="HH:mm:ss" isBlankWhenNull="true">
- <reportElement x="379" y="0" width="63" height="31"/>
- <box topPadding="5" leftPadding="3"/>
- <textElement verticalAlignment="Top">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{TRTIME}.length() == 5 ? new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse("0"+$F{TRTIME})) : $F{TRTIME}.length() < 6 ? new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse("00000"+$F{TRTIME})) : new SimpleDateFormat("HH:mm:ss").format(new SimpleDateFormat("HHmmss").parse($F{TRTIME}))]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <pageFooter>
- <band height="54" splitType="Stretch">
- <textField>
- <reportElement x="344" y="34" width="80" height="20"/>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
- </textField>
- <textField evaluationTime="Report">
- <reportElement x="424" y="34" width="40" height="20"/>
- <textElement>
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- </band>
- </pageFooter>
- <summary>
- <band height="60" splitType="Stretch">
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="442" y="0" width="101" height="20"/>
- <box topPadding="5" rightPadding="2">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="0.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="0.0"/>
- </box>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{totalDebit}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
- <reportElement x="543" y="0" width="102" height="20"/>
- <box topPadding="5" rightPadding="2">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="0.0"/>
- </box>
- <textElement textAlignment="Right">
- <font fontName="Arial Narrow"/>
- </textElement>
- <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{totalCredit}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="0" y="0" width="442" height="20"/>
- <box rightPadding="2">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font fontName="Arial Narrow" size="10" isBold="true"/>
- </textElement>
- <text><![CDATA[TOTAL DEBIT CREDIT]]></text>
- </staticText>
- <staticText>
- <reportElement x="645" y="0" width="157" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="20" width="134" height="20"/>
- <box topPadding="0" leftPadding="2"/>
- <textElement verticalAlignment="Middle"/>
- <text><![CDATA[Jumlah Transaksi Debit]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="40" width="134" height="20"/>
- <box topPadding="0" leftPadding="2"/>
- <textElement verticalAlignment="Middle"/>
- <text><![CDATA[Jumlah Transaksi Kredit]]></text>
- </staticText>
- <staticText>
- <reportElement x="134" y="20" width="14" height="20"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="134" y="40" width="14" height="20"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="Arial Narrow"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="148" y="20" width="100" height="20"/>
- <box leftPadding="2"/>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{countDebit}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement x="148" y="40" width="100" height="20"/>
- <box leftPadding="2"/>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{countCredit}]]></textFieldExpression>
- </textField>
- </band>
- </summary>
- </jasperReport>
|