|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bhumie/upload/../report/LaporanPembayaran/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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="detil_perBank" language="groovy" pageWidth="595" pageHeight="842" columnWidth="581" leftMargin="7" rightMargin="7" topMargin="36" bottomMargin="7" uuid="56c43b37-5528-4378-a442-26f08c499363">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="4a1d9c5f-641f-4061-bb66-9230af129def">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ptgl_akhir" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ptahun" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select
satu.jml_sppt1,
satu.jml_pbb1,
dua.jml_sppt2,
dua.jml_pbb2,
tiga.jml_sppt3,
tiga.jml_pbb3
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb1,1 id from pbb.sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan= $P{Pkd_kecamatan}
and a.kd_kelurahan= $P{Pkd_kelurahan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt != '2'
) satu
inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(a.jml_sppt_yg_dibayar),0) jml_pbb2,1 id from pbb.pembayaran_sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan = $P{Pkd_kecamatan}
and a.kd_kelurahan = $P{Pkd_kelurahan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and a.tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)dua
on satu.id = dua.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb3,1 id from pbb.sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan= $P{Pkd_kecamatan}
and a.kd_kelurahan= $P{Pkd_kelurahan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt = '0'
)tiga on satu.id = tiga.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<variable name="variable1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
</variable>
</subDataset>
<subDataset name="dataset2" uuid="5fdaeb70-41f5-4928-9ca2-c1407a41cc2d">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<parameter name="Ptahun" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select
satu.jml_sppt1,
satu.jml_pbb1,
dua.jml_sppt2,
dua.jml_pbb2,
tiga.jml_sppt3,
tiga.jml_pbb3
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb1,1 id from pbb.sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan= $P{Pkd_kecamatan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt != '2'
) satu
inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(a.jml_sppt_yg_dibayar),0) jml_pbb2,1 id from pbb.pembayaran_sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan = $P{Pkd_kecamatan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and a.tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)dua
on satu.id = dua.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb3,1 id from pbb.sppt a
where a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan= $P{Pkd_kecamatan}
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt = '0'
)tiga on satu.id = tiga.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<variable name="sum_sppt1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt1}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb1}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt2" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt2}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb2" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb2}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt3" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt3}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb3" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{jml_pbb3}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt4" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb4" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt5" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb5" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt6" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb6" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt7" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb7" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt_tot" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb_tot" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_sppt_tung" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<variable name="sum_pbb_tung" class="java.lang.Integer" calculation="Sum">
<variableExpression><![CDATA[]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
</subDataset>
<subDataset name="dataset3" uuid="275a1365-6a5a-44fa-8f54-df05b4690f64">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<parameter name="Ptahun" class="java.lang.String"/>
<queryString>
<![CDATA[select
satu.jml_sppt1,
satu.jml_pbb1,
dua.jml_sppt2,
dua.jml_pbb2,
tiga.jml_sppt3,
tiga.jml_pbb3
from (
Select coalesce(COUNT(*),0) jml_sppt1, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb1,1 id from pbb.sppt a
where a.kd_propinsi = '11'
and a.kd_dati2 = '04'
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt != '2'
) satu
inner join (
Select coalesce(COUNT(*),0) jml_sppt2, coalesce(sum(a.jml_sppt_yg_dibayar),0) jml_pbb2,1 id from pbb.pembayaran_sppt a
where a.kd_propinsi = '11'
and a.kd_dati2 = '04'
and a.thn_pajak_sppt = $P{Ptahun}
and a.tgl_pembayaran_sppt >= to_date($P{Ptgl_awal}, 'DD-MM-YYYY') and a.tgl_pembayaran_sppt <= to_date($P{Ptgl_akhir}, 'DD-MM-YYYY')
)dua
on satu.id = dua.id inner join (
Select coalesce(COUNT(*),0) jml_sppt3, coalesce(sum(a.pbb_yg_harus_dibayar_sppt),0) jml_pbb3,1 id from pbb.sppt a
where a.kd_propinsi = '11'
and a.kd_dati2 = '04'
and a.thn_pajak_sppt = $P{Ptahun}
and a.status_pembayaran_sppt = '0'
)tiga on satu.id = tiga.id]]>
</queryString>
<field name="jml_sppt1" class="java.lang.Long"/>
<field name="jml_pbb1" class="java.math.BigDecimal"/>
<field name="jml_sppt2" class="java.lang.Long"/>
<field name="jml_pbb2" class="java.math.BigDecimal"/>
<field name="jml_sppt3" class="java.lang.Long"/>
<field name="jml_pbb3" class="java.math.BigDecimal"/>
<variable name="variable1" class="java.lang.String" calculation="Sum">
<variableExpression><![CDATA[$F{jml_sppt1}]]></variableExpression>
</variable>
</subDataset>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<parameter name="Ptahun" class="java.lang.String"/>
<queryString>
<![CDATA[select
h.KD_PROPINSI||'.'||h.KD_DATI2||'.'||h.KD_KECAMATAN||'-'||i.NM_KECAMATAN KODE,
h.KD_PROPINSI, h.KD_DATI2, h.KD_KECAMATAN, h.KD_KELURAHAN, h.KD_KELURAHAN||'-'||h.NM_KELURAHAN as ALIA
from
pbb.REF_KELURAHAN h,pbb.REF_KECAMATAN i
where h.KD_KECAMATAN = i.KD_KECAMATAN AND h.KD_DATI2 = i.KD_DATI2 AND h.KD_PROPINSI = i.KD_PROPINSI
order by h.KD_PROPINSI, h.KD_DATI2, h.KD_KECAMATAN, h.KD_KELURAHAN]]>
</queryString>
<field name="kode" class="java.lang.String"/>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="alia" class="java.lang.String"/>
<group name="nmKelurahan">
<groupExpression><![CDATA[$F{kode}]]></groupExpression>
<groupHeader>
<band height="26">
<textField>
<reportElement uuid="36a969a0-d369-4442-9000-d8ef23f63b3e" x="4" y="5" width="167" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kode}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="4f693655-94ad-486d-a7e9-ea2f1519bc7c" x="3" y="22" width="576" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</groupHeader>
<groupFooter>
<band height="36">
<staticText>
<reportElement uuid="dc629eb9-f8ed-4f40-94ea-1c6200d7b20a" x="4" y="6" width="154" height="26"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[ J U M L A H :]]></text>
</staticText>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="3" width="576" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="33" width="576" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="29deabaa-8f38-405c-b7ae-f4b38308cfd2" x="3" y="35" width="576" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="6175368d-9fe3-428e-af99-199b5e980124" x="167" y="5" width="413" height="28"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset2" uuid="7156e156-08fa-4ad5-a30c-9916d156d067">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptahun">
<datasetParameterExpression><![CDATA[$P{Ptahun}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="28" width="413">
<textField>
<reportElement uuid="4f88ffe3-a558-42ce-8081-dc8a278d1513" x="319" y="1" width="89" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d359814c-b025-4340-8133-6c8858c9fdf1" x="280" y="2" width="31" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="27835dae-879c-4790-a233-f43aa9d2e24d" x="175" y="1" width="98" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a5e30e22-abd4-4939-a799-5dbc840a3eb4" x="134" y="1" width="35" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ab9d12e7-ae23-4e78-858c-6e925b1277ad" x="36" y="2" width="93" height="24"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d28d252a-c810-42c8-8cf6-222837d32436" x="0" y="1" width="31" height="25"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="162" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="201" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="298" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="338" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="444" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="483" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="579" y="5" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="40" splitType="Stretch">
<staticText>
<reportElement uuid="0ebfee46-f922-40ec-b66a-7a13e5ff5baf" x="4" y="0" width="565" height="15"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[EVALUASI PENERIMAAN PBB TAHUN]]></text>
</staticText>
<staticText>
<reportElement uuid="3a558dd5-ccad-4b9f-a8d3-5fcad68c6e37" x="241" y="14" width="160" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[KABUPATEN ACEH TENGAH]]></text>
</staticText>
<textField>
<reportElement uuid="3f9c5319-9e98-4d07-bc5b-e8e40253df2f" x="396" y="0" width="100" height="15"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ptahun}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="66" splitType="Stretch">
<staticText>
<reportElement uuid="e2d2d7c8-51c4-4cfe-a4cd-22bf73ecf384" x="4" y="24" width="57" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[WILAYAH]]></text>
</staticText>
<textField>
<reportElement uuid="c6e00bd9-230e-4a74-b935-5dbd17ba7c4c" x="167" y="22" width="132" height="23"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<textFieldExpression><![CDATA["POKOK KETETAPAN TAHUN " + $P{Ptahun}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="304" y="22" width="133" height="25"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["REALISASI POKOK KETETAPAN TAHUN " + $P{Ptahun}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b3b2b4b5-3306-4e49-8be0-d694022eb108" x="448" y="22" width="133" height="23"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["SISA POKOK KETETAPAN TAHUN " + $P{Ptahun}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="167" y="48" width="32" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="162" y="26" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="162" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="299" y="26" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="442" y="25" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="579" y="27" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="19" width="577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="62" width="577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="64" width="577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="172" y="44" width="409" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="207" y="48" width="90" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="347" y="48" width="90" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="304" y="48" width="32" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="486" y="48" width="90" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b93b8dc9-6445-4b89-b669-4d8a394d5961" x="448" y="48" width="32" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="299" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="338" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="203" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="483" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="579" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="08f5bd92-22f7-4814-8b1a-6fabdb45e023" x="442" y="47" width="1" height="12"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="678421c0-d3c3-4c4f-a2ea-4eac294a0840" x="482" y="1" width="34" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="78c9cccc-9e4c-4f91-b113-74d0405fd325" x="501" y="1" width="25" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[dari]]></text>
</staticText>
<textField evaluationTime="Report">
<reportElement uuid="df69814d-9487-472f-b806-9760e722c2b3" x="530" y="1" width="36" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="102cac89-1e01-4398-8c32-02c60f65fd38" x="421" y="1" width="61" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Halaman : ]]></text>
</staticText>
<line>
<reportElement uuid="4a44d8c4-6fbc-4020-ad61-19a58b792873" x="4" y="17" width="577" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="102cac89-1e01-4398-8c32-02c60f65fd38" x="4" y="1" width="44" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TANGGAL]]></text>
</staticText>
<textField>
<reportElement uuid="fab851b4-aa27-422e-b6f4-e8dbffb146ad" x="53" y="1" width="73" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ptgl_awal}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="102cac89-1e01-4398-8c32-02c60f65fd38" x="125" y="1" width="19" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[S/D]]></text>
</staticText>
<textField>
<reportElement uuid="3ddf09d6-5a40-4200-bce0-87828355e134" x="147" y="1" width="100" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ptgl_akhir}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<detail>
<band height="29" splitType="Stretch">
<textField>
<reportElement uuid="de1c5adc-e19f-4119-a248-1fde90583f9f" x="4" y="2" width="154" height="26"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alia}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="f8d0c47a-9beb-4633-afae-8ca898bdd3f3" x="167" y="0" width="412" height="29"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset1" uuid="bab27885-8fba-4aa4-b5d3-0953f66ff016">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Pkd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptahun">
<datasetParameterExpression><![CDATA[$P{Ptahun}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="29" width="412">
<textField>
<reportElement uuid="ecb66b2e-aea6-45d7-898c-3bd26b260759" x="0" y="1" width="32" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe0901c8-ca21-4d83-b1ba-85a2131656b2" x="36" y="2" width="93" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bdfe784f-e938-46e2-a213-c4c1f204b531" x="134" y="2" width="35" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0ffdb3b2-8578-4b92-bf3b-9c1c3cda7a3d" x="175" y="2" width="98" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3717453c-e236-40fa-aa59-e4b82590daa1" x="280" y="2" width="31" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="418024fb-b568-414a-b35c-97f7f300534e" x="319" y="2" width="89" height="26"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="162" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="201" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="298" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="338" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="444" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="483" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ea96773d-2454-4fe0-a4a3-9875702a4167" x="579" y="0" width="1" height="29"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</detail>
<summary>
<band height="48">
<staticText>
<reportElement uuid="d90b25e0-6f54-49fd-8507-a14bd0ac7bf6" x="3" y="3" width="155" height="28"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[J U M L A H T O T A L :]]></text>
</staticText>
<line>
<reportElement uuid="f45c64b1-8d63-44b8-8aa9-21e489eb29a0" x="3" y="32" width="573" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f45c64b1-8d63-44b8-8aa9-21e489eb29a0" x="3" y="34" width="573" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="486b0ebd-5727-40f4-8158-70932e6e4f6e" x="163" y="0" width="417" height="31"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset3" uuid="0c64322e-059c-430a-a780-fd6881aad153">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_awal">
<datasetParameterExpression><![CDATA[$P{Ptgl_awal}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptgl_akhir">
<datasetParameterExpression><![CDATA[$P{Ptgl_akhir}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ptahun">
<datasetParameterExpression><![CDATA[$P{Ptahun}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="31" width="417">
<textField>
<reportElement uuid="c62496bc-3b91-48dd-a9db-9191d9b7189e" x="323" y="3" width="89" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bbbbe47a-06af-4eec-a5fa-f922e806ee6b" x="285" y="3" width="31" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt3}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0225f37b-e6f0-481d-9bc8-0184e580fd6c" x="179" y="3" width="98" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b619d5d8-a795-4c1c-b16e-f160e15e06b7" x="138" y="3" width="35" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt2}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5d81b50d-aeaa-4e91-b9e6-8a531abbe772" x="40" y="3" width="93" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_pbb1}).replace(",",".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="175" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="38" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="b619d5d8-a795-4c1c-b16e-f160e15e06b7" x="1" y="3" width="35" height="27"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt1}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="298" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="445" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="484" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="579" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
<line>
<reportElement uuid="56f28eb3-a78c-4b26-a547-7e31460da56d" x="162" y="0" width="1" height="31"/>
<graphicElement>
<pen lineWidth="0.75"/>
</graphicElement>
</line>
</band>
</summary>
</jasperReport>