📄 complexworksheet.jrxml
字号:
<?xml version="1.0" encoding="GB2312" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="ComplexWorkSheet"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="680"
pageHeight="816"
columnWidth="624"
columnSpacing="0"
leftMargin="28"
rightMargin="28"
topMargin="28"
bottomMargin="28"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="GB2312" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<reportFont name="宋体" isDefault="false" fontName="宋体" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1250" isPdfEmbedded="false"/>
<parameter name="报修人" isForPrompting="false" class="java.lang.String"/>
<parameter name="填单人" isForPrompting="false" class="java.lang.String"/>
<parameter name="维修类别" isForPrompting="false" class="java.lang.String"/>
<parameter name="故障地点" isForPrompting="false" class="java.lang.String"/>
<parameter name="报修时间" isForPrompting="false" class="java.lang.String"/>
<parameter name="工作单编号" isForPrompting="false" class="java.lang.Long"/>
<parameter name="维修工作单类型名" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[“修理班维修工作单”或“外请人员维修工作单”]]></parameterDescription>
</parameter>
<parameter name="报修人类型名" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[“报修人”或“公司名”]]></parameterDescription>
</parameter>
<parameter name="用材总金额" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[这个参数还是从程序中传过来吧--要注意转成String类型]]></parameterDescription>
<defaultValueExpression ><![CDATA["0"]]></defaultValueExpression>
</parameter>
<field name="用材名称" class="java.lang.String"/>
<field name="用材单价" class="java.lang.String"/>
<field name="用材数量" class="java.lang.String"/>
<group name="MyGroup" isStartNewColumn="true" >
<groupExpression><![CDATA[null]]></groupExpression>
<groupHeader>
<band height="0" isSplitAllowed="true" >
</band>
</groupHeader>
<groupFooter>
<band height="43" isSplitAllowed="true" >
<staticText>
<reportElement mode="Transparent" x="1" y="2" width="64" height="18" forecolor="#000000" backcolor="#FFFFFF" key="staticText-30"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体"/>
</textElement>
<text><![CDATA[用材总金额]]></text>
</staticText>
<staticText>
<reportElement mode="Transparent" x="190" y="2" width="63" height="18" forecolor="#000000" backcolor="#FFFFFF" key="staticText-31"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体"/>
</textElement>
<text><![CDATA[维修用人工]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement mode="Transparent" x="70" y="2" width="114" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField-6"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{用材总金额}]]></textFieldExpression>
</textField>
<staticText>
<reportElement mode="Transparent" x="368" y="2" width="62" height="18" forecolor="#000000" backcolor="#FFFFFF" key="staticText-32"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体"/>
</textElement>
<text><![CDATA[人工费金额]]></text>
</staticText>
<line direction="TopDown">
<reportElement mode="Opaque" x="0" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-47" stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="559" y="1" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-48" stretchType="RelativeToBandHeight"/>
<graphicElement stretchType="RelativeToBandHeight" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="188" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-49"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="364" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-50"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="432" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-51"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="255" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-52"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="0" y="20" width="559" height="2" forecolor="#000000" backcolor="#FFFFFF" key="line-53"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="69" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" key="line-54"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<line direction="TopDown">
<reportElement mode="Opaque" x="0" y="0" width="559" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-60"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<staticText>
<reportElement mode="Transparent" x="0" y="25" width="364" height="16" forecolor="#000000" backcolor="#FFFFFF" key="staticText-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<text><![CDATA[注：1.此单当日16时前必须返回；2.因特殊原因未修或未完工，需科长签字。]]></text>
</staticText>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="178" isSplitAllowed="true" >
<staticText>
<reportElement mode="Transparent" x="397" y="27" width="70" height="20" forecolor="#000000" backcolor="#FFFFFF" key="staticText-2"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<text><![CDATA[编号：]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement mode="Transparent" x="468" y="27" width="90" height="20" forecolor="#000000" backcolor="#FFFFFF" key="textField-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<textFieldExpression class="java.lang.Long"><![CDATA[$P{工作单编号}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement mode="Transparent" x="72" y="60" width="115" height="18" forecolor="#000000" backcolor="#FFFFFF" key="报修人textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{报修人}]]></textFieldExpression>
</textField>
<staticText>
<reportElement mode="Transparent" x="366" y="60" width="65" height="18" forecolor="#000000" backcolor="#FFFFFF" key="检修人staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<text><![CDATA[检修人]]></text>
</staticText>
<staticText>
<reportElement mode="Transparent" x="191" y="60" width="65" height="18" forecolor="#000000" backcolor="#FFFFFF" key="填单人staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<text><![CDATA[填单人]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement mode="Transparent" x="258" y="60" width="105" height="18" forecolor="#000000" backcolor="#FFFFFF" key="填单人textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{填单人}]]></textFieldExpression>
</textField>
<staticText>
<reportElement mode="Transparent" x="191" y="82" width="65" height="16" forecolor="#000000" backcolor="#FFFFFF" key="维修类别staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font reportFont="宋体" pdfFontName="STSong-Light"/>
</textElement>
<text><![CDATA[维修类别]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement mode="Transparent"⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -