<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="report04_kartu_piutang" pageWidth="935" pageHeight="1275" columnWidth="935" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="date_from" class="java.util.Date"/>
	<parameter name="date_end" class="java.util.Date"/>
	<parameter name="username" class="java.lang.String"/>
	<queryString>
		<![CDATA[call spfreport44_rekap_saldo_piutang($P{date_from},$P{date_end})]]>
	</queryString>
	<field name="ftcompany_name" class="java.lang.String"/>
	<field name="ftcustomer_code" class="java.lang.String"/>
	<field name="ftcustomer_name" class="java.lang.String"/>
	<field name="fcdebit" class="java.math.BigDecimal"/>
	<field name="fccredit" class="java.math.BigDecimal"/>
	<field name="fcsaldo" class="java.math.BigDecimal"/>
	<field name="fcsaldo_akhir" class="java.math.BigDecimal"/>
	<sortField name="ftcustomer_code"/>
	<variable name="urut" class="java.lang.Integer" resetType="Group" resetGroup="g_customer_code" calculation="Count">
		<variableExpression><![CDATA[new java.lang.Integer(0)]]></variableExpression>
		<initialValueExpression><![CDATA[new java.lang.Integer(1)]]></initialValueExpression>
	</variable>
	<group name="g_customer_code"/>
	<background>
		<band/>
	</background>
	<title>
		<band/>
	</title>
	<pageHeader>
		<band height="73">
			<staticText>
				<reportElement key="staticText-1" x="292" y="4" width="360" height="18"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[REKAP SALDO PIUTANG]]></text>
			</staticText>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="1" y="4" width="284" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftcompany_name}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" x="1" y="28" width="92" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<text><![CDATA[Periode transaksi :]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-1" x="99" y="28" width="92" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_from}]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MMM-yyyy" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-2" x="216" y="28" width="100" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{date_end}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-4" x="191" y="28" width="25" height="18"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="11"/>
				</textElement>
				<text><![CDATA[s/d]]></text>
			</staticText>
			<line>
				<reportElement key="line-1" x="1" y="48" width="930" height="1"/>
			</line>
			<line>
				<reportElement key="line-2" x="0" y="68" width="928" height="1"/>
			</line>
			<staticText>
				<reportElement key="staticText-5" x="4" y="51" width="24" height="16"/>
				<textElement>
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-6" x="30" y="51" width="286" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Customer]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-13" x="476" y="51" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Debet]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-14" x="626" y="51" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Kredit]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-15" x="776" y="51" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Saldo Akhir]]></text>
			</staticText>
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-3" x="730" y="4" width="100" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-4" x="830" y="4" width="100" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-16" x="326" y="51" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Saldo Awal]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="22">
			<textField>
				<reportElement x="4" y="4" width="24" height="16"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{urut}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="30" y="4" width="69" height="16"/>
				<textElement textAlignment="Center">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftcustomer_code}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="99" y="4" width="217" height="16"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ftcustomer_name}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="476" y="4" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{fcdebit}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="626" y="4" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{fccredit}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="326" y="4" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{fcsaldo}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="776" y="4" width="150" height="16"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{fcsaldo_akhir}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="28">
			<textField isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-7" x="638" y="6" width="100" height="18"/>
				<textElement>
					<font fontName="Arial" size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{username}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="EEE, d MMM yyyy HH:mm:ss" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField-8" x="741" y="6" width="187" height="18"/>
				<textElement textAlignment="Right">
					<font fontName="Arial" size="11" isItalic="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
