picturereport.jrxml

Jasper Report 报表。用iReport的Nebeans插件制作。包括调用方法。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<parameter name="TITLE" class="java.lang.String" isForPrompting="false"/>
	<parameter name="FOLDER" class="java.lang.String" isForPrompting="false"/>
	<parameter name="MIN_ID" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="MAX_ID" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="BEGIN_DATE" class="java.util.Date" isForPrompting="false"/>
	<parameter name="TYPE" class="java.lang.Integer" isForPrompting="false"/>
	<queryString language="SQL">
		<![CDATA[SELECT
     PICTURES."TAKENDATE" AS PICTURES_TAKENDATE,
    $P{FOLDER} || PICTURES."FILENAME" AS PICTURES_FILENAME,
     PICTURES."DESCRIPTION" AS PICTURES_DESCRIPTION,
     PETS."NAME" AS PETS_NAME
FROM
     "APP"."PETS" PETS INNER JOIN "APP"."PICTURES" PICTURES ON PETS."ID" = PICTURES."PETID"
WHERE
petid >= $P{MIN_ID}
 AND petid <= $P{MAX_ID}
 AND TYPE=$P{TYPE}
 AND TAKENDATE >= $P{BEGIN_DATE}
ORDER BY
     PICTURES."TAKENDATE" ASC]]>
	</queryString>
	<field name="PICTURES_TAKENDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PICTURES_FILENAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PICTURES_DESCRIPTION" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PETS_NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="PETS_NAME">
		<groupExpression><![CDATA[$F{PETS_NAME}]]></groupExpression>
		<groupHeader>
			<band height="27">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="139" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement textAlignment="Right">
						<font size="18"/>
					</textElement>
					<text><![CDATA[PETS_NAME:]]></text>
				</staticText>
				<textField hyperlinkType="None">
					<reportElement mode="Opaque" x="139" y="0" width="416" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PETS_NAME}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="8">
				<line direction="BottomUp">
					<reportElement key="line" x="1" y="4" width="554" height="1"/>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band/>
	</background>
	<title>
		<band height="58">
			<line>
				<reportElement x="0" y="8" width="555" height="1"/>
			</line>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="51" width="555" height="1"/>
			</line>
			<textField hyperlinkType="None">
				<reportElement x="110" y="9" width="327" height="31"/>
				<textElement textAlignment="Center">
					<font size="22" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{TITLE}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band/>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="514">
			<staticText>
				<reportElement x="0" y="439" width="91" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[TAKENDATE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="91" y="439" width="464" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{PICTURES_TAKENDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="459" width="91" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[FILENAME: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="91" y="459" width="464" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PICTURES_FILENAME}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="479" width="91" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[DESCRIPTION: ]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" hyperlinkType="None">
				<reportElement x="91" y="479" width="464" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PICTURES_DESCRIPTION}]]></textFieldExpression>
			</textField>
			<image scaleImage="RetainShape" hyperlinkType="None">
				<reportElement x="0" y="14" width="540" height="405"/>
				<imageExpression class="java.lang.String"><![CDATA[$F{PICTURES_FILENAME}]]></imageExpression>
			</image>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="26">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="516" y="6" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="342" y="6" width="170" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false" hyperlinkType="None">
				<reportElement key="textField" x="1" y="6" width="209" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>