|
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/report/SimulasiPenetapan/ |
| [ 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="Sektor" language="groovy" pageWidth="1076" pageHeight="792" columnWidth="1048" leftMargin="14" rightMargin="14" topMargin="20" bottomMargin="28" uuid="cbb4ff5b-f99a-4b90-8c50-09957c1c35e7">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="dataset1" uuid="41e6b53d-c7fa-4118-8d1f-8d455ce171e4">
<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
COUNT(kd_propinsi) jml_op
FROM DAT_OBJEK_PAJAK
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="jml_op" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset2" uuid="e25d2a29-ce43-4a3d-933c-3a5536f01453">
<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"/>
<parameter name="thn_pajak_sppt" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT
COUNT(kd_propinsi) jml_sppt,
SUM(luas_bumi_sppt) luas_bumi,
SUM(luas_bng_sppt) luas_bng,
SUM(njop_bumi_sppt)/1000 njop_bumi,
SUM(njop_bng_sppt)/1000 njop_bng,
SUM(pbb_yg_harus_dibayar_sppt) jml_pbb
FROM SPPT_SIMULASI
WHERE kd_propinsi = $P{kd_propinsi}
AND kd_dati2 = $P{kd_dati2}
AND kd_kecamatan = $P{kd_kecamatan}
AND kd_kelurahan = $P{kd_kelurahan}
AND thn_pajak_sppt = $P{thn_pajak_sppt}
AND status_pembayaran_sppt != '2']]>
</queryString>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="luas_bumi" class="java.math.BigDecimal"/>
<field name="luas_bng" class="java.math.BigDecimal"/>
<field name="njop_bumi" class="java.math.BigDecimal"/>
<field name="njop_bng" class="java.math.BigDecimal"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset3" uuid="de840e11-60cf-408a-a45a-604c419cfc52">
<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="thn_pajak_sppt" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT
COUNT(kd_propinsi) jml_sppt,
SUM(luas_bumi_sppt) luas_bumi,
SUM(luas_bng_sppt) luas_bng,
SUM(njop_bumi_sppt)/1000 njop_bumi,
SUM(njop_bng_sppt)/1000 njop_bng,
SUM(pbb_yg_harus_dibayar_sppt) jml_pbb
FROM SPPT_SIMULASI
WHERE kd_propinsi = $P{kd_propinsi}
AND kd_dati2 = $P{kd_dati2}
AND kd_kecamatan = $P{kd_kecamatan}
AND thn_pajak_sppt = $P{thn_pajak_sppt}
AND status_pembayaran_sppt != '2']]>
</queryString>
<field name="jml_sppt" class="java.lang.Long"/>
<field name="luas_bumi" class="java.math.BigDecimal"/>
<field name="luas_bng" class="java.math.BigDecimal"/>
<field name="njop_bumi" class="java.math.BigDecimal"/>
<field name="njop_bng" class="java.math.BigDecimal"/>
<field name="jml_pbb" class="java.math.BigDecimal"/>
</subDataset>
<subDataset name="dataset4" uuid="e2085ca3-3949-459a-b221-d075c22e1bfb">
<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
COUNT(kd_propinsi) jml_op
FROM DAT_OBJEK_PAJAK
WHERE kd_propinsi = $P{kd_propinsi}
AND kd_dati2 = $P{kd_dati2}
AND kd_kecamatan = $P{kd_kecamatan}]]>
</queryString>
<field name="jml_op" class="java.lang.Long"/>
</subDataset>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="thn_pajak_sppt" class="java.lang.String"/>
<parameter name="DEFA_VALUE" class="java.lang.Integer">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT a.kd_propinsi, a.kd_dati2, a.kd_kecamatan, a.kd_kelurahan,
b.nm_propinsi, c.nm_dati2, d.nm_kecamatan, a.nm_kelurahan
FROM ref_kelurahan a, ref_propinsi b, ref_dati2 c, ref_kecamatan d
WHERE a.kd_propinsi = $P{kd_propinsi}
AND a.kd_dati2 = $P{kd_dati2}
AND b.kd_propinsi = a.kd_propinsi
AND c.kd_propinsi = a.kd_propinsi
AND c.kd_dati2 = a.kd_dati2
AND d.kd_propinsi = a.kd_propinsi
AND d.kd_dati2 = a.kd_dati2
AND d.kd_kecamatan = a.kd_kecamatan
ORDER BY a.kd_propinsi, a.kd_dati2, a.kd_kecamatan, a.kd_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="nm_propinsi" class="java.lang.String"/>
<field name="nm_dati2" class="java.lang.String"/>
<field name="nm_kecamatan" class="java.lang.String"/>
<field name="nm_kelurahan" class="java.lang.String"/>
<variable name="NO_URUT" class="java.lang.Integer" resetType="Group" resetGroup="GroupKecamatan" calculation="Count">
<variableExpression><![CDATA[$V{NO_URUT}]]></variableExpression>
</variable>
<group name="GroupKecamatan" isStartNewPage="true" isResetPageNumber="true" isReprintHeaderOnEachPage="true">
<groupExpression><![CDATA[$F{kd_kecamatan}]]></groupExpression>
<groupHeader>
<band height="180">
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="0" y="134" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="9" y="139" width="24" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NO.]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="473" y="139" width="41" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[BUMI]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="541" y="159" width="66" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NJOP(x000)]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="430" y="160" width="30" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LUAS]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="270" y="160" width="22" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[OP]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="72" y="139" width="104" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DESA / KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="886" y="139" width="111" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KETETAPAN PBB]]></text>
</staticText>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="1" y="175" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="263" y="154" width="589" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="707" y="139" width="57" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[BANGUNAN]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="662" y="160" width="30" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LUAS]]></text>
</staticText>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="1" y="178" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="352" y="159" width="32" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="780" y="159" width="66" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NJOP(x000)]]></text>
</staticText>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="0" y="131" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="ca8e9677-6a31-43cd-9b9e-3bd9add8367e" x="292" y="139" width="41" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JUMLAH]]></text>
</staticText>
<textField>
<reportElement uuid="99cfdef3-4e11-4b8c-911d-84c508026ee7" x="243" y="0" width="532" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["SIMULASI DAFTAR HIMPUNAN KETETAPAN PBB SEKTOR PEDESAAN DAN PERKOTAAN"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e19f236-6f75-4cca-be9a-bb5114ce3216" x="352" y="20" width="423" height="20"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["PROPINSI : "+$F{kd_propinsi}+" - "+$F{nm_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e19f236-6f75-4cca-be9a-bb5114ce3216" x="352" y="60" width="423" height="20"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["KECAMATAN : "+$F{kd_kecamatan}+" - "+$F{nm_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e19f236-6f75-4cca-be9a-bb5114ce3216" x="352" y="40" width="423" height="20"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["KOTA/KAB : "+$F{kd_dati2}+" - "+$F{nm_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e19f236-6f75-4cca-be9a-bb5114ce3216" x="352" y="80" width="423" height="20"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression><![CDATA["TAHUN : "+$P{thn_pajak_sppt}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="41">
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="1" y="3" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="986177a2-eebf-4c23-a75a-fa9e5e20fe0c" x="347" y="9" width="668" height="23"/>
<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="776050d9-13d2-46eb-a66f-3849f79b562d">
<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="thn_pajak_sppt">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="23" width="668">
<textField>
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="1" y="0" width="50" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt}==null?
0
:new DecimalFormat("#,##0").format($F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="61" y="0" width="60" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bumi}==null?
0
:new DecimalFormat("#,##0").format($F{luas_bumi}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="175" y="0" width="93" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi}==null?
0
:new DecimalFormat("#,##0").format($F{njop_bumi}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="293" y="0" width="61" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bng}==null?
0
:new DecimalFormat("#,##0").format($F{luas_bng}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="415" y="0" width="92" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}==null?
0
:new DecimalFormat("#,##0").format($F{njop_bng}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="539" y="0" width="122" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}==null?
0
:new DecimalFormat("#,##0").format($F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="0eb1a1f6-2ef6-41c9-a16b-766d4b58fd91" x="263" y="9" width="67" height="23"/>
<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="dataset4" uuid="357c05b9-7893-453e-a34b-d911a6084c6c">
<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="23" width="67">
<textField>
<reportElement uuid="7b4dac62-9f8d-475b-a2d0-6c16469859ae" x="0" y="0" width="66" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_op}==null?
0
:new DecimalFormat("#,##0").format($F{jml_op}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="1" y="35" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="95e4e535-306c-4a42-ba6e-a9c03109c9b4" x="1" y="38" width="1048" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="7bbeea25-2bfa-4bd4-bf91-475a4ea82240" x="9" y="9" width="170" height="20"/>
<textElement>
<font fontName="Courier New" size="12" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["JUMLAH"]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="35" splitType="Stretch">
<textField>
<reportElement uuid="7bbeea25-2bfa-4bd4-bf91-475a4ea82240" x="72" y="6" width="170" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_kelurahan}+" - "+$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="f846069f-f4dc-47a4-ac94-8e4616dc99b2" x="263" y="6" width="67" height="20"/>
<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="dd40884f-7021-471c-bd49-3d6eacd2cdbf">
<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="20" width="67">
<textField>
<reportElement uuid="f16fd8fa-b002-46bc-9468-4735d369e5cf" x="0" y="0" width="66" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_op}==null?
0
:new DecimalFormat("#,##0").format($F{jml_op}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="431ae820-57b9-4a88-9392-6f39a9080340" x="347" y="6" width="668" height="20"/>
<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="0ffa8f1e-7081-4a01-bcce-251e76f7b68e">
<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>
<datasetParameter name="thn_pajak_sppt">
<datasetParameterExpression><![CDATA[$P{thn_pajak_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="20" width="668">
<textField>
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="1" y="0" width="50" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jml_sppt}==null?
0
:new DecimalFormat("#,##0").format($F{jml_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="61" y="0" width="60" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bumi}==null?
0
:new DecimalFormat("#,##0").format($F{luas_bumi}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="175" y="0" width="93" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bumi}==null?
0
:new DecimalFormat("#,##0").format($F{njop_bumi}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="293" y="0" width="61" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{luas_bng}==null?
0
:new DecimalFormat("#,##0").format($F{luas_bng}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="415" y="0" width="92" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}==null?
0
:new DecimalFormat("#,##0").format($F{njop_bng}).replace(",",".")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="402a9da6-7bcf-4c3f-aa22-b938aa05f6a0" x="539" y="0" width="122" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{njop_bng}==null?
0
:new DecimalFormat("#,##0").format($F{jml_pbb}).replace(",",".")]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<textField>
<reportElement uuid="7bbeea25-2bfa-4bd4-bf91-475a4ea82240" x="9" y="6" width="24" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NO_URUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>