|
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/DataReferensi/ |
| [ 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="SKZntSismiop_2" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="1e3ddd81-c151-44f0-8515-43682de85a85">
<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="tahun_pajak" class="java.lang.String"/>
<parameter name="kd_znt" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select (pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric)*1000)).vlc_kd_kelas,(pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric)*1000)).vlc_thn_awal_kls,(pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric)*1000)).vln_njop_perm2
from
(SELECT '1',thn_nir_znt,nir
FROM pbb.dat_nir
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 kd_znt = $P{kd_znt} and thn_nir_znt = $P{tahun_pajak}) as temp]]>
</queryString>
<field name="vlc_kd_kelas" class="java.lang.String"/>
<field name="vlc_thn_awal_kls" class="java.lang.String"/>
<field name="vln_njop_perm2" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="12" splitType="Stretch">
<textField>
<reportElement uuid="51805827-ca13-4011-aeb9-32a66bda8bf1" x="4" y="0" width="35" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{vlc_kd_kelas}]]></textFieldExpression>
</textField>
<textField pattern="###0.00">
<reportElement uuid="4df22d80-969c-40bb-b616-4cd55ba929bd" x="219" y="0" width="75" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{vln_njop_perm2}).replace(",", ".")]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="d76769cc-1a1a-4fbc-82d8-1076abfea18a" x="42" y="0" width="126" height="12"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kls_tanah">
<subreportParameterExpression><![CDATA[$F{vlc_kd_kelas}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["SKZntSismiop_3.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
</jasperReport>