|
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/DaftarTunggakan/ |
| [ 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="HimpunanTunggakan" language="groovy" pageWidth="992" pageHeight="781" columnWidth="978" leftMargin="5" rightMargin="9" topMargin="34" bottomMargin="28" uuid="97fa8b89-f43d-414b-8872-b2bc1146380b">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="5"/>
<subDataset name="kecamatan" uuid="18e05243-1819-47ad-80a4-cd5459a2aa89">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_kecamatan
from pbb.ref_kecamatan
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan}]]>
</queryString>
<field name="nm_kecamatan" class="java.lang.String"/>
</subDataset>
<subDataset name="kelurahan" uuid="d02afd0d-caa9-4796-8cea-d2ae46e7307a">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_kelurahan
from pbb.ref_kelurahan
where kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan}
and kd_kelurahan = $P{kd_kelurahan}]]>
</queryString>
<field name="nm_kelurahan" class="java.lang.String"/>
</subDataset>
<subDataset name="propinsi" uuid="2e242b43-3fe0-4cd0-987e-891cb1e2ccfd">
<parameter name="kd_propinsi" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_propinsi
from pbb.ref_propinsi
where kd_propinsi = $P{kd_propinsi}]]>
</queryString>
<field name="nm_propinsi" class="java.lang.String"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="tahun_pajak" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="DEFA_VALUE" class="java.lang.Integer" isForPrompting="false">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT A.KD_PROPINSI, A.KD_DATI2, A.KD_KECAMATAN, A.KD_KELURAHAN,
coalesce((A.KD_PROPINSI||A.KD_DATI2||A.KD_KECAMATAN||A.KD_KELURAHAN),'') KODE_KEL,
B.NM_KELURAHAN, COUNT(A.PBB_YG_HARUS_DIBAYAR_SPPT) SPPT ,
SUM(A.PBB_YG_HARUS_DIBAYAR_SPPT) KETETAPAN
FROM pbb.SPPT A, pbb.REF_KELURAHAN B
WHERE A.THN_PAJAK_SPPT = $P{tahun_pajak} AND
A.KD_PROPINSI = $P{kd_propinsi} AND
A.KD_DATI2 = $P{kd_dati2} AND
A.KD_KECAMATAN= $P{kd_kecamatan} AND
A.KD_KELURAHAN= $P{kd_kelurahan} AND
B.KD_PROPINSI = A.KD_PROPINSI AND
B.KD_DATI2 = A.KD_DATI2 AND
B.KD_KECAMATAN = A.KD_KECAMATAN AND
B.KD_KELURAHAN = A.KD_KELURAHAN AND
A.TGL_JATUH_TEMPO_SPPT < now() AND
A.STATUS_PEMBAYARAN_SPPT = '0'
GROUP BY A.KD_PROPINSI, A.KD_DATI2, A.KD_KECAMATAN, A.KD_KELURAHAN, B.NM_KELURAHAN]]>
</queryString>
<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="kode_kel" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="sppt" class="java.lang.Long"/>
<field name="ketetapan" class="java.math.BigDecimal"/>
<variable name="sppt_1" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{sppt}]]></variableExpression>
</variable>
<variable name="ketetapan_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{ketetapan}]]></variableExpression>
</variable>
<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="118" splitType="Stretch">
<staticText>
<reportElement uuid="9ce58caf-72a1-42ed-84c7-f4d0d05a3da2" x="234" y="6" width="51" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Daftar :]]></text>
</staticText>
<staticText>
<reportElement uuid="72c25f5e-6cc6-43be-8b5f-473566c5568c" x="298" y="6" width="252" height="28"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Himpunan Tunggakan PBB
Menurut Golongan Buku Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="b609f074-bf2f-4ab7-b439-eccf4b4b84ca" x="298" y="34" width="87" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kecamatan : :]]></text>
</staticText>
<staticText>
<reportElement uuid="b609f074-bf2f-4ab7-b439-eccf4b4b84ca" x="298" y="50" width="87" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kab / Kota : :]]></text>
</staticText>
<staticText>
<reportElement uuid="b609f074-bf2f-4ab7-b439-eccf4b4b84ca" x="298" y="66" width="87" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Propinsi : :]]></text>
</staticText>
<staticText>
<reportElement uuid="1c1ed167-5225-4f97-b9e4-4d01b4f4f425" x="281" y="82" width="87" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun : :]]></text>
</staticText>
<textField>
<reportElement uuid="12665e3a-8459-44eb-b0af-ca7d0cbc27a6" x="368" y="82" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{tahun_pajak}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="777fc156-6630-44a1-868a-22f3dcd1a9ec" x="385" y="34" width="165" height="16"/>
<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="kecamatan" uuid="d7fc0ce6-e265-4337-a8f9-8eba3c98fc9e">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="16" width="165">
<textField>
<reportElement uuid="611cea66-e346-40a2-9c27-84d13880e00e" x="0" y="0" width="165" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="0d83236f-e72d-4a3f-9214-153b39274d50" x="385" y="50" width="165" height="16"/>
<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="kelurahan" uuid="62e6261d-7356-4901-ad1b-c9fc7a313cfb">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="16" width="165">
<textField>
<reportElement uuid="709d495a-024a-49b8-8851-c4ce8e4e67bf" x="0" y="0" width="165" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="c9b62f09-1b97-41a7-a6d4-9b7ab0ee8c6c" x="385" y="66" width="165" height="16"/>
<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="propinsi" uuid="56806261-3510-4cb0-9ede-ca5a36583b67">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="16" width="165">
<textField>
<reportElement uuid="1a0ea3e1-bda6-4bed-9d60-53240b422016" x="0" y="0" width="165" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_propinsi}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</title>
<pageHeader>
<band height="95" splitType="Stretch">
<staticText>
<reportElement uuid="ae8b5811-5888-4b6a-a499-6795543fad41" x="3" y="15" width="27" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[No]]></text>
</staticText>
<staticText>
<reportElement uuid="0b50634b-f5d4-4e0e-8332-f392b296f2cf" x="55" y="15" width="94" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Kelurahan]]></text>
</staticText>
<staticText>
<reportElement uuid="5a96bcae-a943-411e-b39c-561bfb49b9be" x="179" y="15" width="770" height="16"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tunggakan PBB / Golongan Buku Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="22f98d16-e2df-4861-b63a-6754c3fedd66" x="179" y="44" width="40" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="490e9368-8a4b-4454-bf98-1b9b1efd427c" x="225" y="44" width="75" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="68b2c06c-b60b-4cd6-8130-1a7d78161c22" x="319" y="44" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku I]]></text>
</staticText>
<staticText>
<reportElement uuid="588de1c0-f130-40e2-a07d-2a76d2425c8b" x="459" y="44" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku II]]></text>
</staticText>
<staticText>
<reportElement uuid="04de8a6b-c732-47c8-a9bb-9b1feb0d7459" x="577" y="44" width="107" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku III]]></text>
</staticText>
<staticText>
<reportElement uuid="25c2c580-579d-43c5-8652-0dd991d1efc9" x="709" y="44" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku IV]]></text>
</staticText>
<staticText>
<reportElement uuid="a38f1e93-8b6c-4801-a913-f8b3cb63fffb" x="849" y="44" width="100" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku V]]></text>
</staticText>
<staticText>
<reportElement uuid="dfb9e42f-1403-4502-9656-68edd35c236b" x="306" y="69" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="ff516591-ef9f-4a56-91e4-90cc05bf135d" x="355" y="69" width="80" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="dfb9e42f-1403-4502-9656-68edd35c236b" x="439" y="69" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="dfb9e42f-1403-4502-9656-68edd35c236b" x="567" y="69" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="dfb9e42f-1403-4502-9656-68edd35c236b" x="698" y="69" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="dfb9e42f-1403-4502-9656-68edd35c236b" x="827" y="69" width="43" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="ff516591-ef9f-4a56-91e4-90cc05bf135d" x="487" y="69" width="73" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="ff516591-ef9f-4a56-91e4-90cc05bf135d" x="617" y="69" width="75" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="ff516591-ef9f-4a56-91e4-90cc05bf135d" x="746" y="69" width="75" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<staticText>
<reportElement uuid="ff516591-ef9f-4a56-91e4-90cc05bf135d" x="884" y="69" width="74" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ketetapan]]></text>
</staticText>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="3" y="2" width="958" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="3" y="5" width="959" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="174" y="35" width="787" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="303" y="64" width="658" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="3" y="89" width="958" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="9d431b6c-1cc0-4f75-a5ea-a61d1d940291" x="3" y="92" width="959" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="29" y="5" width="1" height="84"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="174" y="5" width="1" height="84"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="3" y="3" width="1" height="86"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="221" y="35" width="1" height="54"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="303" y="35" width="1" height="54"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="436" y="35" width="1" height="55"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="352" y="64" width="1" height="25"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="483" y="64" width="1" height="25"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="612" y="64" width="1" height="25"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="563" y="35" width="1" height="55"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="743" y="64" width="1" height="25"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="874" y="64" width="1" height="25"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="695" y="35" width="1" height="55"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="824" y="35" width="1" height="55"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fa25db56-3493-4f6f-9b2d-ca5ac9115303" x="961" y="35" width="1" height="55"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="325da20b-3f04-42e1-a660-02283506dae4" x="961" y="2" width="1" height="34"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</pageHeader>
<detail>
<band height="44" splitType="Stretch">
<textField>
<reportElement uuid="67658914-3022-4def-80dc-b389234782c3" x="33" y="0" width="141" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="83b8b491-c4ec-4220-a607-f4b7c1bc9796" x="176" y="0" width="43" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{sppt}).replace(",", ".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9457f9eb-a4bd-44a8-bca1-c2a7a48e667a" x="221" y="0" width="79" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{ketetapan}).replace(",", ".")]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="900c1da6-09cd-46d8-8f53-787ed9d877c7" x="439" y="0" width="120" height="20"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "BukuII.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="47094034-de92-4197-b4fc-d0989ed71c66" x="567" y="0" width="125" height="20"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "BukuIII.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="f126a234-d9b0-4bb7-9a62-54430825d57c" x="698" y="0" width="123" height="20"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "BukuIV.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="8cd996bd-ccfb-4a96-a881-7698c5fb964c" x="827" y="0" width="131" height="20"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "BukuV.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="bdc4b726-7735-4be5-a521-1cf044d5c495" x="306" y="0" width="129" height="20"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "buku.jasper"]]></subreportExpression>
</subreport>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="174" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="221" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="303" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="436" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="563" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="695" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="824" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="961" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="29" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="3" y="-6" width="1" height="46"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="352" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="483" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="612" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="743" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="874" y="-6" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="3087a2a2-e882-4518-be92-3a8f92d67c5e" x="4" y="0" width="25" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height="52">
<subreport>
<reportElement uuid="cd459544-255c-48f2-b8ba-566a2f7c09a1" x="305" y="12" width="129" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ttbk.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="5f395e81-19ce-4c92-be9a-a5947c46de4e" x="175" y="12" width="42" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($V{sppt_1}).replace(",", ".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="e99375a4-7d20-4f3d-b151-aedf5e895b2f" x="2" y="47" width="959" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<subreport>
<reportElement uuid="a390214d-4c7a-48d5-92b2-6a51aee96658" x="438" y="12" width="120" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ttbk2.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="dc5a3f4b-49b4-42fa-abbe-e208182193cd" x="224" y="12" width="76" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($V{ketetapan_1}).replace(",", ".")]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="df9af68a-502c-4f9d-8d77-ea51f89c8ee5" x="827" y="12" width="131" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ttbk5.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="f9e61651-7b27-4e2e-b965-45c9e4f4ba48" x="697" y="12" width="123" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ttbk4.jasper"]]></subreportExpression>
</subreport>
<line>
<reportElement uuid="e99375a4-7d20-4f3d-b151-aedf5e895b2f" x="2" y="50" width="959" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="4e6fa0ab-fa0b-49c0-97fe-0462eb61435d" x="33" y="12" width="76" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah : ]]></text>
</staticText>
<line>
<reportElement uuid="e99375a4-7d20-4f3d-b151-aedf5e895b2f" x="2" y="0" width="964" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="e99375a4-7d20-4f3d-b151-aedf5e895b2f" x="2" y="2" width="964" height="1"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<subreport>
<reportElement uuid="e9177556-7653-4fdd-828f-c46c84881573" x="566" y="12" width="125" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$P{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$P{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$P{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ttbk3.jasper"]]></subreportExpression>
</subreport>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="436" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="962" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="303" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="695" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="221" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="824" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="3" y="1" width="1" height="46"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="174" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="563" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="29" y="1" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="483" y="2" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="612" y="2" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="743" y="2" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="352" y="2" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="fbb53565-82fd-4bd0-a1ea-2c0785d07a88" x="874" y="2" width="1" height="48"/>
<graphicElement>
<pen lineWidth="0.75" lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</summary>
</jasperReport>