|
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/SalinanMasal/DHKP/ |
| [ 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="CetakMasalDHKP_totalstts" language="groovy" pageWidth="56" pageHeight="56" columnWidth="56" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="713847d5-e0f5-4881-b0d8-a842a8450227">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<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"/>
<parameter name="p_awal2" class="java.lang.Double"/>
<parameter name="p_akhir2" class="java.lang.Double"/>
<queryString>
<![CDATA[SELECT count(*)
FROM SPPT A, TEMP_sppt B
WHERE
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 A.THN_PAJAK_SPPT = $P{thn_pajak_sppt}
AND A.PBB_YG_HARUS_DIBAYAR_SPPT BETWEEN $P{p_awal2} AND $P{p_akhir2}
AND A.PBB_YG_HARUS_DIBAYAR_SPPT <> 0
AND A.STATUS_PEMBAYARAN_SPPT <> '2'
AND A.KD_PROPINSI = B.KD_PROPINSI
AND A.KD_DATI2 = B.KD_DATI2
AND A.KD_KECAMATAN = B.KD_KECAMATAN
AND A.KD_KELURAHAN = B.KD_KELURAHAN
AND A.KD_BLOK=B.KD_BLOK
AND A.NO_URUT=B.NO_URUT
AND A.KD_JNS_OP=B.KD_JNS_OP ;]]>
</queryString>
<field name="count" class="java.lang.Long"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="14" splitType="Stretch">
<textField>
<reportElement uuid="c298a61d-532a-4876-967d-d096910938b4" x="0" y="0" width="55" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{count}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
</jasperReport>