?? ts_projsummarymember_03.jrxml
字號:
<?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_ProjSummaryMember_03"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="612"
pageHeight="792"
columnWidth="576"
columnSpacing="0"
leftMargin="18"
rightMargin="18"
topMargin="54"
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="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>
<parameter name="PPath" isForPrompting="true" class="java.lang.String">
<defaultValueExpression ><![CDATA["\\rms_logo.gif"]]></defaultValueExpression>
</parameter>
<parameter name="PBillable" isForPrompting="true" class="java.lang.String"/>
<parameter name="PProID" isForPrompting="true" class="java.math.BigDecimal"/>
<queryString><![CDATA[SELECT VPROJMANAGER.PROJECTCODE, VPROJMANAGER.PROJECTNAME, VPROJMANAGER.FROMDATE, VPROJMANAGER.TODATE, VPROJMANAGER.PPROJECTID, VPROJMANAGER.MRESOURCEID, VPROJMANAGER.ENDDATE, VPROJMANAGER.STARTDATE, VPROJMANAGER.MFIRSTNAME, VPROJMANAGER.MLASTNAME FROM VPROJMANAGER WHERE VPROJMANAGER.STARTDATE<=$P{PEdate}AND VPROJMANAGER.ENDDATE>=$P{PSdate}AND VPROJMANAGER.MRESOURCEID=$P{PResID}AND (VPROJMANAGER.PPROJECTID=$P{PProID} or $P{PProID} is null or $P{PProID}=0)ORDER BY VPROJMANAGER.MFIRSTNAME, VPROJMANAGER.MLASTNAME,VPROJMANAGER.PROJECTCODE]]></queryString>
<field name="PROJECTCODE" class="java.lang.String"/>
<field name="PROJECTNAME" class="java.lang.String"/>
<field name="FROMDATE" class="java.sql.Timestamp"/>
<field name="TODATE" class="java.sql.Timestamp"/>
<field name="PPROJECTID" class="java.math.BigDecimal"/>
<field name="MRESOURCEID" class="java.math.BigDecimal"/>
<field name="ENDDATE" class="java.sql.Timestamp"/>
<field name="STARTDATE" class="java.sql.Timestamp"/>
<field name="MFIRSTNAME" class="java.lang.String"/>
<field name="MLASTNAME" class="java.lang.String"/>
<variable name="VEmpName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{MFIRSTNAME}+" "+$F{MLASTNAME}]]></variableExpression>
</variable>
<variable name="VPageNumber" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA["Page " + $V{PAGE_NUMBER} + " of " + $V{PAGE_NUMBER} + ""]]></variableExpression>
</variable>
<variable name="VBillText" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $P{PBillable}.equals( "T" ) ? "Billable" : ( $P{PBillable}.equals( "F" ) ? "Non-billable" : "All" ) )]]></variableExpression>
</variable>
<group name="ProManager" isStartNewPage="true" isReprintHeaderOnEachPage="true" >
<groupExpression><![CDATA[$V{VEmpName}]]></groupExpression>
<groupHeader>
<band height="67" isSplitAllowed="true" >
<staticText>
<reportElement x="151" y="51" width="79" height="16" key="staticText-4"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Project Name]]></text>
</staticText>
<elementGroup><!-- Start: 1 !-->
<staticText>
<reportElement x="0" y="0" width="98" height="16" key="staticText-10"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Project Manager: (Netstar):]]></text>
</staticText>
</elementGroup><!-- End 1 !-->
<elementGroup><!-- Start: 2 !-->
<staticText>
<reportElement x="0" y="24" width="70" height="15" key="staticText-8"/>
<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="24" width="82" height="15" key="textField"/>
<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="24" width="17" height="15" key="staticText-9"/>
<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="24" width="82" height="15" key="textField"/>
<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>
</elementGroup><!-- End 2 !-->
<staticText>
<reportElement x="0" y="51" width="79" height="16" key="staticText-30"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Project NO]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="ProManager" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="98" y="0" width="296" 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{VEmpName}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="261" y="51" width="79" height="16" key="staticText-31"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Team Member]]></text>
</staticText>
<staticText>
<reportElement x="497" y="51" width="79" height="16" key="staticText-32"/>
<box></box>
<textElement textAlignment="Right">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Hours]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="ProjectCode" >
<groupExpression><![CDATA[$F{PPROJECTID}]]></groupExpression>
<groupHeader>
<band height="26" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="0" y="7" width="100" height="18" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROJECTCODE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="151" y="7" width="100" height="18" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROJECTNAME}]]></textFieldExpression>
</textField>
<subreport isUsingCache="true">
<reportElement x="261" y="7" width="315" height="17" key="subreport-1"/>
<subreportParameter name="PSdate">
<subreportParameterExpression><![CDATA[$P{PSdate}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PEdate">
<subreportParameterExpression><![CDATA[$P{PEdate}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PProjID">
<subreportParameterExpression><![CDATA[$F{PPROJECTID}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="PBillable">
<subreportParameterExpression><![CDATA[$P{PBillable}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "TeamMemberSub.jasper"]]></subreportExpression>
</subreport>
</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="196" isSplitAllowed="true" >
<staticText>
<reportElement x="103" y="128" width="370" height="34" forecolor="#000000" key="staticText-1"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="13" isBold="true"/>
</textElement>
<text><![CDATA[Timesheet Report - Project SummaryTotal by Activities (Final)]]></text>
</staticText>
<staticText>
<reportElement x="1" y="104" width="239" height="19" forecolor="#000000" key="staticText-5"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="13" isBold="true"/>
</textElement>
<text><![CDATA[Resource Management System]]></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>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Page" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="220" y="162" width="136" height="18" key="textField"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="13" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{VBillText}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="0" isSplitAllowed="true" >
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="28" isSplitAllowed="true" >
<staticText>
<reportElement x="231" y="10" width="121" height="17" key="staticText-28"/>
<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="49" y="9" width="100" height="18" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" size="8"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="3" y="9" width="46" height="14" key="staticText-29"/>
<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="501" y="9" width="59" height="18" key="textField-1"/>
<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="560" y="9" width="16" height="18" key="textField-2"/>
<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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -