<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --> <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="task" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="baf55988-0610-49d8-946e-683c7bdbd023"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter"/> <queryString language="SQL"> <![CDATA[SELECT s.userName,COUNT(t.createdBy) count from task_header t INNER JOIN sys_user s on t.createdBy=s.loginName and created >date_sub(curdate(), INTERVAL 30 DAY) GROUP BY s.userName ORDER BY count desc]]> </queryString> <field name="userName" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="userName"/> <property name="com.jaspersoft.studio.field.tree.path" value="sys_user"/> </field> <field name="count" class="java.lang.Long"> <property name="com.jaspersoft.studio.field.label" value="count"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <staticText> <reportElement x="207" y="30" width="140" height="30" uuid="a0a599c3-7454-46d2-83ac-9ebddabddbe6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="20"/> </textElement> <text><![CDATA[任务执行次数]]></text> </staticText> </band> </title> <pageHeader> <band height="30" splitType="Stretch"> <staticText> <reportElement x="160" y="0" width="100" height="30" uuid="3fc9dcd1-959b-4520-8333-9f2ce2047ef1"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <text><![CDATA[日期:]]></text> </staticText> <textField pattern="MMMMM dd, yyyy"> <reportElement x="260" y="0" width="100" height="30" uuid="ad4b28fb-a670-49f3-be63-d7413f000efb"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="45" splitType="Stretch"> <staticText> <reportElement x="180" y="10" width="100" height="30" uuid="ce9fe089-7e3a-4c11-8f2b-68d6739baa75"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[操作人员]]></text> </staticText> <staticText> <reportElement x="280" y="10" width="100" height="30" uuid="6771fd49-0265-4033-bdb4-e1df20730ad2"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[次数]]></text> </staticText> </band> </columnHeader> <detail> <band height="30" splitType="Stretch"> <textField> <reportElement x="180" y="0" width="100" height="30" uuid="08384a0d-8f3f-466b-bfad-9853ba264241"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{userName}]]></textFieldExpression> </textField> <textField> <reportElement x="280" y="0" width="100" height="30" uuid="615d7de2-4187-44e4-b936-d8c6cf5e7dc0"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{count}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="3" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="31" splitType="Stretch"> <textField> <reportElement x="470" y="-3" width="100" height="30" uuid="7f9bd68b-4857-4ebe-afca-a60a3a9ac1d8"/> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>