|
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_3" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="72dabb3b-0243-46fe-b17e-a818160794e0">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="tahun_pajak" class="java.lang.String"/>
<parameter name="kls_tanah" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT coalesce(nilai_min_tanah,0)*1000 as nilai_min_tanah,coalesce(nilai_max_tanah,0)*1000 as nilai_max_tanah
FROM pbb.kelas_tanah
WHERE rpad(kd_kls_tanah,3) = rpad($P{kls_tanah},3) AND
(thn_awal_kls_tanah <= $P{tahun_pajak} AND
thn_akhir_kls_tanah >= $P{tahun_pajak});]]>
</queryString>
<field name="nilai_min_tanah" class="java.lang.Double"/>
<field name="nilai_max_tanah" class="java.lang.Double"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="12" splitType="Stretch">
<textField>
<reportElement uuid="c39d1485-3113-4b2d-824b-728c24fc6c3c" x="0" y="0" width="58" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{nilai_min_tanah}).replace(",", ".")]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="c0c95969-9b68-4ea3-a2b2-6d94eed8004e" x="53" y="0" width="45" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[s/d]]></text>
</staticText>
<textField>
<reportElement uuid="467406a3-1128-4dd0-8352-50e5c8bdc198" x="97" y="0" width="60" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{nilai_max_tanah}).replace(",", ".")]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>