<?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="report name" pageWidth="995" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="955" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <field name="deviceName" class="java.lang.String"/> <field name="alarmNumber" class="java.lang.Long"/> <field name="installDate" class="java.lang.String"/> <field name="outDate" class="java.lang.String"/> <field name="factory" class="java.lang.String"/> <field name="reportBeginDate" class="java.lang.String"/> <field name="reportEndDate" class="java.lang.String"/> <field name="alarmNumPercent" class="java.lang.String"/> <field name="latitude" class="java.lang.String"/> <field name="longtitude" class="java.lang.String"/> <field name="height" class="java.lang.String"/> <background> <band/> </background> <title> <band height="75"> <staticText> <reportElement x="370" y="0" width="218" height="43"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="20"/> </textElement> <text><![CDATA[报警记录报表]]></text> </staticText> <staticText> <reportElement x="718" y="55" width="58" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[记录日期:]]></text> </staticText> <textField hyperlinkType="None"> <reportElement x="776" y="55" width="55" height="20"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{reportBeginDate}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="845" y="55" width="64" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{reportEndDate}]]></textFieldExpression> </textField> <staticText> <reportElement x="831" y="55" width="14" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[~]]></text> </staticText> </band> </title> <pageHeader> <band height="48"> <staticText> <reportElement x="0" y="0" width="157" height="22"/> <textElement> <font fontName="微软雅黑" size="15"/> </textElement> <text><![CDATA[一、报警记录统计表]]></text> </staticText> </band> </pageHeader> <columnHeader> <band height="49"> <line> <reportElement x="11" y="44" width="820" height="1"/> </line> <staticText> <reportElement x="27" y="24" width="53" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[设备名]]></text> </staticText> <staticText> <reportElement x="627" y="24" width="85" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[报警次数]]></text> </staticText> <staticText> <reportElement x="503" y="24" width="85" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[安装日期]]></text> </staticText> <staticText> <reportElement x="144" y="24" width="53" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[经度]]></text> </staticText> <staticText> <reportElement x="317" y="24" width="53" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[高度]]></text> </staticText> <staticText> <reportElement x="235" y="24" width="53" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[纬度]]></text> </staticText> <staticText> <reportElement x="397" y="24" width="85" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[出厂日期]]></text> </staticText> <staticText> <reportElement x="746" y="24" width="85" height="19"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <text><![CDATA[工厂]]></text> </staticText> <line> <reportElement x="11" y="12" width="820" height="1"/> </line> </band> </columnHeader> <detail> <band height="45"> <line> <reportElement x="11" y="31" width="820" height="1"/> </line> <textField hyperlinkType="None"> <reportElement x="27" y="11" width="97" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12" isUnderline="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{deviceName}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="746" y="11" width="85" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.Long"><![CDATA[$F{alarmNumber}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="503" y="11" width="85" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{installDate}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="397" y="11" width="85" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{outDate}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="627" y="11" width="85" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{factory}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="235" y="11" width="53" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12" isUnderline="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{latitude}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="144" y="11" width="53" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12" isUnderline="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{longtitude}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="317" y="11" width="53" height="20"/> <textElement verticalAlignment="Middle"> <font fontName="微软雅黑" size="12" isUnderline="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{height}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="234"> <staticText> <reportElement x="0" y="0" width="144" height="25"/> <textElement> <font fontName="微软雅黑" size="15"/> </textElement> <text><![CDATA[二、报警记录图表]]></text> </staticText> <pie3DChart> <chart hyperlinkType="None"> <reportElement x="235" y="39" width="392" height="183"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <pieDataset> <keyExpression><![CDATA[$F{deviceName}]]></keyExpression> <valueExpression><![CDATA[$F{alarmNumber}]]></valueExpression> <labelExpression><![CDATA[$F{deviceName}+" "+$F{alarmNumPercent}]]></labelExpression> <sectionHyperlink hyperlinkType="None"/> </pieDataset> <pie3DPlot> <plot foregroundAlpha="0.5"/> </pie3DPlot> </pie3DChart> </band> </columnFooter> <pageFooter> <band height="29"/> </pageFooter> <summary> <band height="29"/> </summary> </jasperReport>