| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195 |
- <?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="siskohatBulananSummary" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
- <property name="ireport.zoom" value="1.0"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <parameter name="startDate" class="java.util.Date">
- <defaultValueExpression><![CDATA[]]></defaultValueExpression>
- </parameter>
- <parameter name="endDate" class="java.util.Date">
- <defaultValueExpression><![CDATA[]]></defaultValueExpression>
- </parameter>
- <queryString>
- <![CDATA[SELECT * FROM MWTEMP.TEMPTABLE ORDER BY A03]]>
- </queryString>
- <field name="TEMPTABLE_PK" class="java.lang.Integer"/>
- <field name="CHANNEL_FK" class="java.lang.String"/>
- <field name="A01" class="java.lang.String"/>
- <field name="A02" class="java.lang.String"/>
- <field name="A03" class="java.lang.String"/>
- <field name="A04" class="java.lang.String"/>
- <field name="A05" class="java.lang.String"/>
- <field name="A06" class="java.lang.String"/>
- <field name="A07" class="java.lang.String"/>
- <field name="A08" class="java.lang.String"/>
- <field name="A09" class="java.lang.String"/>
- <field name="A10" class="java.lang.String"/>
- <field name="A11" class="java.lang.String"/>
- <field name="A12" class="java.lang.String"/>
- <field name="A13" class="java.lang.String"/>
- <field name="A14" class="java.lang.String"/>
- <field name="A15" class="java.lang.String"/>
- <field name="A16" class="java.lang.String"/>
- <field name="A17" class="java.lang.String"/>
- <field name="A18" class="java.lang.String"/>
- <field name="A19" class="java.lang.String"/>
- <field name="A20" class="java.lang.String"/>
- <field name="A21" class="java.lang.String"/>
- <field name="A22" class="java.lang.String"/>
- <field name="A23" class="java.lang.String"/>
- <field name="A24" class="java.lang.String"/>
- <field name="A25" class="java.lang.String"/>
- <field name="A26" class="java.lang.String"/>
- <field name="A27" class="java.lang.String"/>
- <field name="A28" class="java.lang.String"/>
- <field name="A29" class="java.lang.String"/>
- <field name="A30" class="java.lang.String"/>
- <field name="A31" class="java.lang.String"/>
- <field name="A32" class="java.lang.String"/>
- <field name="A33" class="java.lang.String"/>
- <field name="A34" class="java.lang.String"/>
- <field name="A35" class="java.lang.String"/>
- <field name="A36" class="java.lang.String"/>
- <field name="A37" class="java.lang.String"/>
- <field name="A38" class="java.lang.String"/>
- <field name="A39" class="java.lang.String"/>
- <field name="A40" class="java.lang.String"/>
- <field name="INSERTDATE" class="java.sql.Timestamp"/>
- <field name="DELETION_DATE" class="java.sql.Timestamp"/>
- <background>
- <band splitType="Stretch"/>
- </background>
- <pageHeader>
- <band height="123" splitType="Stretch">
- <staticText>
- <reportElement x="0" y="0" width="555" height="25"/>
- <textElement textAlignment="Center">
- <font fontName="SansSerif" size="14" isBold="true"/>
- </textElement>
- <text><![CDATA[Summary Hasil Rekonsiliasi Bulanan]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="25" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Tanggal Cetak]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="45" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[BPS]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="65" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Alamat]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="85" width="100" height="20"/>
- <box leftPadding="5"/>
- <textElement/>
- <text><![CDATA[Bulan]]></text>
- </staticText>
- <textField>
- <reportElement x="112" y="25" width="116" height="20"/>
- <box leftPadding="0"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("dd/MM/yy HH:mm:ss").format(new java.util.Date())]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="112" y="45" width="116" height="20"/>
- <textElement/>
- <text><![CDATA[200 - BTN KCS JAKARTA]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="25" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="45" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="65" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="100" y="85" width="12" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="112" y="65" width="116" height="20"/>
- <textElement/>
- <text><![CDATA[Jln. GajahMada No. 1]]></text>
- </staticText>
- <textField pattern="MMMMM yyyy" isBlankWhenNull="true">
- <reportElement x="112" y="85" width="100" height="20"/>
- <textElement/>
- <textFieldExpression class="java.util.Date"><![CDATA[$P{startDate}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="24" splitType="Stretch">
- <staticText>
- <reportElement x="100" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[Total Setoran Awal]]></text>
- </staticText>
- <staticText>
- <reportElement x="210" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[Total Pelunasan]]></text>
- </staticText>
- <staticText>
- <reportElement x="320" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[ Batal Setoran Awal]]></text>
- </staticText>
- <staticText>
- <reportElement x="430" y="0" width="110" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[Batal Pelunasan]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="0" width="100" height="24"/>
- <box>
- <bottomPen lineWidth="1.0" lineStyle="Dashed"/>
- </box>
- <textElement/>
- <text><![CDATA[Tanggal]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="25" splitType="Stretch">
- <textField pattern="dd/MM/yy">
- <reportElement x="0" y="0" width="100" height="25"/>
- <box topPadding="5" bottomPadding="0"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{A03}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <lastPageFooter>
- <band height="50"/>
- </lastPageFooter>
- </jasperReport>
|