?? ts_deptsummarymemberproject_08.jrxml
字號(hào):
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="TS_DeptSummaryMemberProject_08"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="612"
pageHeight="792"
columnWidth="576"
columnSpacing="0"
leftMargin="18"
rightMargin="18"
topMargin="18"
bottomMargin="18"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<parameter name="PPath" isForPrompting="true" class="java.lang.String">
<defaultValueExpression ><![CDATA["\\rms_logo.gif"]]></defaultValueExpression>
</parameter>
<parameter name="PSdate" isForPrompting="true" class="java.sql.Timestamp"/>
<parameter name="PEdate" isForPrompting="true" class="java.sql.Timestamp"/>
<parameter name="PResID" isForPrompting="true" class="java.lang.Integer"/>
<parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA[".\\"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[SELECT VDEPTMANAGER.RESOURCEID, VDEPTMANAGER.FIRSTNAME, VDEPTMANAGER.LASTNAME, VDEPTMANAGER.DEPARTMENTID, VDEPTMANAGER.DEPARTMENT, VDEPTMANAGER.DEPTROLEID FROM VDEPTMANAGER WHERE VDEPTMANAGER.DEPTROLEID=1 AND VDEPTMANAGER.RESOURCEID=$P{PResID} ORDER BY VDEPTMANAGER.DEPARTMENT]]></queryString>
<field name="resourceid" class="java.math.BigDecimal"/>
<field name="firstname" class="java.lang.String"/>
<field name="lastname" class="java.lang.String"/>
<field name="departmentid" class="java.math.BigDecimal"/>
<field name="department" class="java.lang.String"/>
<field name="deptroleid" class="java.math.BigDecimal"/>
<variable name="VFullName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{firstname}+' '+$F{lastname}]]></variableExpression>
</variable>
<group name="Department" isStartNewPage="true" isReprintHeaderOnEachPage="true" >
<groupExpression><![CDATA[$F{department}]]></groupExpression>
<groupHeader>
<band height="56" isSplitAllowed="true" >
<staticText>
<reportElement x="0" y="0" width="163" height="19" key="staticText-3"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Department Manager :]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="Department" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="121" y="0" width="100" height="18" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{VFullName}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="20" width="103" height="15" key="staticText-4"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Department Name:]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="103" y="20" width="435" height="18" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{department}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="38" width="70" height="15" key="staticText-12"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Period: From]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="dd-MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="69" y="38" width="82" height="15" key="textField-4"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{PSdate}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="152" y="38" width="17" height="15" key="staticText-13"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[to]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="dd-MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="170" y="38" width="82" height="15" key="textField-5"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{PEdate}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="161" isSplitAllowed="true" >
<staticText>
<reportElement x="134" y="120" width="308" height="40" key="staticText-1"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="13" isBold="true"/>
</textElement>
<text><![CDATA[Timesheet Report - Staff SummaryTotal by Team Member(Final)]]></text>
</staticText>
<image evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="0" y="0" width="327" height="98" key="image-1"/>
<box></box>
<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA[$P{PPath}]]></imageExpression>
</image>
<staticText>
<reportElement x="0" y="98" width="278" height="17" key="staticText-2"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="13" isBold="true"/>
</textElement>
<text><![CDATA[Resource Management System]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<subreport isUsingCache="true">
<reportElement x="0" y="0" width="197" height="12" key="subreport-1"/>
<subreportParameter name="PSdate">
<subreportParameterExpression><![CDATA[$P{PSdate}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PEdate">
<subreportParameterExpression><![CDATA[$P{PEdate}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PResID">
<subreportParameterExpression><![CDATA[$F{resourceid}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PDeptID">
<subreportParameterExpression><![CDATA[$F{departmentid}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "TS_DeptSummaryMemberSub_08.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="21" isSplitAllowed="true" >
<staticText>
<reportElement x="229" y="3" width="121" height="17" key="staticText-10"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" size="8"/>
</textElement>
<text><![CDATA[Confidential]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="yy/MM/dd h:mm:ss a" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="47" y="3" width="100" height="18" key="textField-1"/>
<box></box>
<textElement>
<font fontName="Verdana" size="8"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="1" y="3" width="46" height="14" key="staticText-11"/>
<box></box>
<textElement>
<font fontName="Verdana" size="8"/>
</textElement>
<text><![CDATA[Printed on]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="499" y="3" width="59" height="18" key="textField-2"/>
<box></box>
<textElement textAlignment="Right">
<font fontName="Verdana" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="558" y="3" width="16" height="18" key="textField-3"/>
<box></box>
<textElement textAlignment="Left">
<font fontName="Verdana" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -