|
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/DaftarTunggakan/ |
| [ 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="BukuI" language="groovy" pageWidth="130" pageHeight="56" columnWidth="128" leftMargin="0" rightMargin="2" topMargin="0" bottomMargin="0" uuid="b91d2250-b092-47ae-bbfd-548f2a532186">
<property name="ireport.zoom" value="4.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"/>
<queryString>
<![CDATA[SELECT count(pbb_yg_harus_dibayar_sppt), coalesce(sum(pbb_yg_harus_dibayar_sppt),'0') as sum
FROM pbb.SPPT
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
thn_pajak_sppt = $P{tahun_pajak} AND status_pembayaran_sppt = '0' AND
TGL_JATUH_TEMPO_SPPT < now() AND pbb_yg_harus_dibayar_sppt > 5000000]]>
</queryString>
<field name="count" class="java.lang.Long"/>
<field name="sum" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="15" splitType="Stretch">
<textField>
<reportElement uuid="0c6022f7-6f12-447e-a4e3-3ed78052e64c" x="0" y="0" width="39" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{count}).replace(",", ".")]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement uuid="921014bd-8a79-43ae-9642-d7855577749a" stretchType="RelativeToBandHeight" x="56" y="1" width="72" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{sum}).replace(",", ".")]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>