📄 managersub.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="ManagerSub"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="595"
columnSpacing="0"
leftMargin="0"
rightMargin="0"
topMargin="0"
bottomMargin="0"
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="PProjectID" isForPrompting="false" class="java.math.BigDecimal"/>
<queryString><![CDATA[SELECT Distinct VPROJMANAGER.MFIRSTNAME, VPROJMANAGER.MLASTNAME, VPROJMANAGER.PPROJECTID FROM VPROJMANAGER WHERE VPROJMANAGER.PPROJECTID=$P{PProjectID}]]></queryString>
<field name="mfirstname" class="java.lang.String"/>
<field name="mlastname" class="java.lang.String"/>
<field name="pprojectid" class="java.math.BigDecimal"/>
<variable name="VPMName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{mfirstname}+" "+$F{mlastname}]]></variableExpression>
</variable>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="19" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="0" y="0" width="141" height="18" key="textField" isPrintRepeatedValues="false"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{VPMName}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -