<?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="water_pipeline_template" language="groovy" pageWidth="899" pageHeight="900" columnWidth="859" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="11"/>
<style name="Crosstab Data Text"/>
<field name="BData_DMA" class="java.lang.String"/>
<field name="LeakRate" class="java.lang.String"/>
<field name="LeakFlag" class="java.lang.String"/>
<field name="reportBeginDate" class="java.lang.String"/>
<field name="reportEndDate" class="java.lang.String"/>
<field name="SaleWater" class="java.lang.String"/>
<field name="SupplyWater" class="java.lang.String"/>
<field name="SaleDiffWater" class="java.lang.String"/>
<background>
<band/>
</background>
<title>
<band height="84">
<staticText>
<reportElement x="244" y="0" width="233" height="34"/>
<textElement>
<font fontName="仿宋" size="24" isBold="true"/>
</textElement>
<text><![CDATA[给水管线统计报表]]></text>
</staticText>
<staticText>
<reportElement x="416" y="62" width="78" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="微软雅黑" size="15"/>
</textElement>
<text><![CDATA[记录日期：]]></text>
</staticText>
<textField>
<reportElement x="608" y="62" width="93" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="微软雅黑" size="15"/>
</textElement>
<textFieldExpression><![CDATA[$F{reportEndDate}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="504" y="62" width="90" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="微软雅黑" size="15"/>
</textElement>
<textFieldExpression><![CDATA[$F{reportBeginDate}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="594" y="62" width="14" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="微软雅黑" size="12"/>
</textElement>
<text><![CDATA[~]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="54">
<staticText>
<reportElement x="142" y="16" width="222" height="21"/>
<textElement>
<font fontName="仿宋" size="18" isBold="true"/>
</textElement>
<text><![CDATA[一.漏损评估分析统计表]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="73">
<staticText>
<reportElement x="145" y="25" width="73" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[分区名称]]></text>
</staticText>
<staticText>
<reportElement x="527" y="25" width="97" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[产销差率(%)]]></text>
</staticText>
<staticText>
<reportElement x="628" y="25" width="76" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[漏损率(%)]]></text>
</staticText>
<line>
<reportElement x="146" y="13" width="554" height="1"/>
</line>
<line>
<reportElement x="146" y="62" width="554" height="1"/>
</line>
<staticText>
<reportElement x="223" y="25" width="99" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[日售水量(m3)]]></text>
</staticText>
<staticText>
<reportElement x="325" y="25" width="99" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[日供水量(m3)]]></text>
</staticText>
<staticText>
<reportElement x="429" y="25" width="93" height="28"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="仿宋" size="14" isBold="true"/>
</textElement>
<text><![CDATA[产销差量(m3)]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="64">
<textField>
<reportElement x="144" y="7" width="90" height="32"/>
<textElement verticalAlignment="Middle">
<font fontName="微软雅黑" size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{BData_DMA}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="535" y="16" width="77" height="32"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{LeakFlag}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="625" y="16" width="81" height="32"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{LeakRate}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="240" y="15" width="78" height="32"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{SaleWater}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="339" y="15" width="78" height="32"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{SupplyWater}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="445" y="15" width="79" height="32"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{SaleDiffWater}]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height="302">
<staticText>
<reportElement x="141" y="26" width="222" height="21"/>
<textElement>
<font fontName="仿宋" size="18" isBold="true"/>
</textElement>
<text><![CDATA[二.漏损评估图表]]></text>
</staticText>
<bar3DChart>
<chart isShowLegend="true">
<reportElement x="142" y="60" width="449" height="232"/>
<chartTitle/>
<chartSubtitle/>
<chartLegend/>
</chart>
<categoryDataset>
<categorySeries>
<seriesExpression><![CDATA["漏损率(%)"]]></seriesExpression>
<categoryExpression><![CDATA[$F{BData_DMA}]]></categoryExpression>
<valueExpression><![CDATA[Double.valueOf($F{LeakRate})]]></valueExpression>
<labelExpression><![CDATA[$F{LeakRate}+"%"]]></labelExpression>
</categorySeries>
<categorySeries>
<seriesExpression><![CDATA["产销差量(%)"]]></seriesExpression>
<categoryExpression><![CDATA[$F{BData_DMA}]]></categoryExpression>
<valueExpression><![CDATA[Double.valueOf($F{LeakFlag})]]></valueExpression>
<labelExpression><![CDATA[$F{LeakFlag}+"%"]]></labelExpression>
</categorySeries>
</categoryDataset>
<bar3DPlot isShowLabels="true">
<plot/>
<categoryAxisFormat>
<axisFormat/>
</categoryAxisFormat>
<valueAxisFormat>
<axisFormat/>
</valueAxisFormat>
</bar3DPlot>
</bar3DChart>
</band>
</summary>
</jasperReport>
