|
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/CetakKeluaran/Pengurangan/ |
| [ 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="Keberatan" language="groovy" pageWidth="612" pageHeight="1984" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="c5c620e5-e168-4792-b94f-384fdd575d84">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan_awal" class="java.lang.String"/>
<parameter name="bundel_pelayanan_awal" class="java.lang.String"/>
<parameter name="no_urut_pelayanan_awal" class="java.lang.String"/>
<parameter name="kd_propinsi_awal" class="java.lang.String"/>
<parameter name="kd_dati2_awal" class="java.lang.String"/>
<parameter name="kd_kecamatan_awal" class="java.lang.String"/>
<parameter name="kd_kelurahan_awal" class="java.lang.String"/>
<parameter name="kd_blok_awal" class="java.lang.String"/>
<parameter name="no_urut_awal" class="java.lang.String"/>
<parameter name="kd_jns_op_awal" class="java.lang.String"/>
<parameter name="thn_pelayanan_akhir" class="java.lang.String"/>
<parameter name="bundel_pelayanan_akhir" class="java.lang.String"/>
<parameter name="no_urut_pelayanan_akhir" class="java.lang.String"/>
<parameter name="kd_propinsi_akhir" class="java.lang.String"/>
<parameter name="kd_dati2_akhir" class="java.lang.String"/>
<parameter name="kd_kecamatan_akhir" class="java.lang.String"/>
<parameter name="kd_kelurahan_akhir" class="java.lang.String"/>
<parameter name="kd_blok_akhir" class="java.lang.String"/>
<parameter name="no_urut_akhir" class="java.lang.String"/>
<parameter name="kd_jns_op_akhir" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT L.THN_PELAYANAN,
L.BUNDEL_PELAYANAN, L.NO_URUT_PELAYANAN, L.KD_PROPINSI_PEMOHON, L.KD_DATI2_PEMOHON,
L.KD_KECAMATAN_PEMOHON, L.KD_KELURAHAN_PEMOHON, L.KD_BLOK_PEMOHON,
L.NO_URUT_PEMOHON, L.KD_JNS_OP_PEMOHON, L.KD_KANWIL, L.KD_KANTOR
FROM pbb.LOG_KELUARAN_PST L
WHERE L.KD_KANWIL = $P{kd_kanwil}
AND L.KD_KANTOR = $P{kd_kantor}
AND L.THN_PELAYANAN||L.BUNDEL_PELAYANAN||L.NO_URUT_PELAYANAN||
L.KD_PROPINSI_PEMOHON||L.KD_DATI2_PEMOHON||L.KD_KECAMATAN_PEMOHON|| L.KD_KELURAHAN_PEMOHON||L.KD_BLOK_PEMOHON||L.NO_URUT_PEMOHON||
L.KD_JNS_OP_PEMOHON BETWEEN
$P{thn_pelayanan_awal}||$P{bundel_pelayanan_awal}||$P{no_urut_pelayanan_awal}||$P{kd_propinsi_awal}||$P{kd_dati2_awal}||$P{kd_kecamatan_awal}||$P{kd_kelurahan_awal}||$P{kd_blok_awal}||$P{no_urut_awal}||$P{kd_jns_op_awal} AND
$P{thn_pelayanan_akhir}||$P{bundel_pelayanan_akhir}||$P{no_urut_pelayanan_akhir}||$P{kd_propinsi_akhir}||$P{kd_dati2_akhir}||$P{kd_kecamatan_akhir}||$P{kd_kelurahan_akhir}||$P{kd_blok_akhir}||$P{no_urut_akhir}||$P{kd_jns_op_akhir}]]>
</queryString>
<field name="thn_pelayanan" class="java.lang.String"/>
<field name="bundel_pelayanan" class="java.lang.String"/>
<field name="no_urut_pelayanan" class="java.lang.String"/>
<field name="kd_propinsi_pemohon" class="java.lang.String"/>
<field name="kd_dati2_pemohon" class="java.lang.String"/>
<field name="kd_kecamatan_pemohon" class="java.lang.String"/>
<field name="kd_kelurahan_pemohon" class="java.lang.String"/>
<field name="kd_blok_pemohon" class="java.lang.String"/>
<field name="no_urut_pemohon" class="java.lang.String"/>
<field name="kd_jns_op_pemohon" class="java.lang.String"/>
<field name="kd_kanwil" class="java.lang.String"/>
<field name="kd_kantor" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="1261">
<staticText>
<reportElement uuid="61612668-3813-4bf3-b8e0-9b884ad355e0" x="127" y="80" width="103" height="13"/>
<textElement>
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[KEPUTUSAN KEPALA]]></text>
</staticText>
<line>
<reportElement uuid="927efe3a-0e49-4105-b2f2-5616e41c4767" mode="Transparent" x="3" y="58" width="566" height="1"/>
</line>
<subreport>
<reportElement uuid="2a37fea5-0f30-4e67-b894-94b476eebc1b" x="0" y="1" width="572" height="19"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="0378f75b-bdf8-4fcc-90a4-4e7cc4ef3650" x="230" y="80" width="203" height="13"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_kop2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="59a3ac45-0749-415e-9bdb-fce96c080193" x="0" y="20" width="572" height="17"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan3.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="fceeb5b5-2c0f-49dc-9ae1-7b6d2cdfff35" x="0" y="39" width="572" height="17"/>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$P{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$P{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_kantor.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="a4c1db1f-7c1f-42d7-b7b3-89c0c77d9978" x="0" y="93" width="572" height="1168"/>
<subreportParameter name="thn_pelayanan">
<subreportParameterExpression><![CDATA[$F{thn_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="bundel_pelayanan">
<subreportParameterExpression><![CDATA[$F{bundel_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut_pelayanan">
<subreportParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="SUBREPORT_DIR">
<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_isi.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
</jasperReport>