|
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/SKKepalaDaerah/ |
| [ 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="SKPemantauanOP_2" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="ad29d427-23e0-4640-a01d-61c8d61b9cc7">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="jalan_op" class="java.lang.String"/>
<parameter name="kd_znt" class="java.lang.String"/>
<queryString>
<![CDATA[select SUM(c.luas_bumi) as luas_bangunan
FROM
pbb.DAT_OP_BUMI C,
pbb.DAT_OBJEK_PAJAK A
WHERE a.kd_propinsi = c.kd_propinsi and
a.kd_dati2 = c.kd_dati2 and
a.kd_kecamatan = c.kd_kecamatan and
a.kd_kelurahan = c.kd_kelurahan and
a.kd_blok = c.kd_blok and
a.no_urut = c.no_urut and
a.kd_jns_op = c.kd_jns_op AND
a.jalan_op = $P{jalan_op} AND
c.KD_ZNT = $P{kd_znt};]]>
</queryString>
<field name="luas_bangunan" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<columnHeader>
<band height="20">
<textField>
<reportElement uuid="c7fc3376-8aca-4e68-bea7-d0e291f9e2cd" x="0" y="0" width="66" height="19"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{luas_bangunan}.doubleValue())]]></textFieldExpression>
</textField>
</band>
</columnHeader>
</jasperReport>