petreport.jrxml

来自「Jasper Report 报表。用iReport的Nebeans插件制作。包括」· JRXML 代码 · 共 493 行 · 第 1/2 页

<?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="MIN_ID" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="MAX_ID" class="java.lang.Integer" isForPrompting="false"/>
	<queryString language="SQL">
		<![CDATA[SELECT
     PETS."ID" AS ID,
     PETS."NAME" AS NAME,
     PETS."SEX" AS SEX,
     PETS."BIRTHDATE" AS BIRTHDATE,
     PETS."ADOPTIONDATE" AS ADOPTIONDATE,
     PETS."BREED" AS BREED,
     PETS."COLOR" AS COLOR,
     PETS."BREEDERNAME" AS BREEDERNAME,
     PETS."FAVORITEFOOD" AS FAVORITEFOOD,
     PETS."FAVORITETOY" AS FAVORITETOY,
     PETS."LICENSETAGNUMBER" AS LICENSETAGNUMBER,
     PETS."RABIESTAGNUMBER" AS RABIESTAGNUMBER,
     PETS."MICROCHIPID" AS MICROCHIPID,
     PETS."FOODBRAND" AS FOODBRAND,
     PETS."PORTIONSIZE" AS PORTIONSIZE,
     PETS."SERVINGTIMES" AS SERVINGTIMES,
     PETS."SNACKS" AS SNACKS,
     PETS."DIETARYEXCLUSIONS" AS DIETARYEXCLUSIONS,
     PETS."FILEFOLDER" AS FILEFOLDER,
     PETS."PICFILENAME" AS PICFILENAME,
     PETS."PETTYPE" AS PETTYPE
FROM
     "APP"."PETS" PETS
     WHERE
          id >= $P{MIN_ID}
 AND id <= $P{MAX_ID}
ORDER BY
     PETS."ID" ASC]]>
	</queryString>
	<field name="ID" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SEX" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BIRTHDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ADOPTIONDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BREED" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="COLOR" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="BREEDERNAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FAVORITEFOOD" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FAVORITETOY" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="LICENSETAGNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="RABIESTAGNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="MICROCHIPID" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FOODBRAND" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PORTIONSIZE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SERVINGTIMES" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SNACKS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DIETARYEXCLUSIONS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FILEFOLDER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PICFILENAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PETTYPE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="PETTYPE" isStartNewPage="true">
		<groupExpression><![CDATA[$F{PETTYPE}]]></groupExpression>
		<groupHeader>
			<band height="27">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="102" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement textAlignment="Right">
						<font size="18"/>
					</textElement>
					<text><![CDATA[PET TYPE: ]]></text>
				</staticText>
				<textField hyperlinkType="None">
					<reportElement mode="Opaque" x="102" y="0" width="453" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PETTYPE}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="8">
				<line direction="BottomUp">
					<reportElement key="line" x="1" y="4" width="554" height="4"/>
				</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>
			<staticText>
				<reportElement x="65" y="13" width="424" height="35"/>
				<textElement textAlignment="Center">
					<font size="22" isBold="true"/>
				</textElement>
				<text><![CDATA[Pet's Basic Data Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band/>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="658" isSplitAllowed="false">
			<staticText>
				<reportElement x="0" y="254" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[ID: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="257" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="274" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[NAME: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="277" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="294" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[SEX: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="297" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEX}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="314" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[BIRTH DATE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="317" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{BIRTHDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="334" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[ADOPTION DATE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="337" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{ADOPTIONDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="354" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[BREED: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="155" y="357" width="400" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BREED}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="374" width="155" height="23"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="12"/>
				</textElement>
				<text><![CDATA[COLOR: ]]></text>
			</staticText>