medicationreport.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="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"/>
	<queryString language="SQL">
		<![CDATA[SELECT
     
    PETS."NAME"  AS NAME,
     MEDICATIONS."MEDICATION" AS MEDICINE,
     MEDICATIONS."DOSAGE" AS DOSAGE,   
 MEDICATIONS."SPACCOUNT" AS VET,
     MEDICATIONS."TAKINGDATE" AS MTAKINGDATE,
MEDICATIONS."NOTES" AS NOTES
    
     
FROM
     "APP"."PETS" PETS INNER JOIN "APP"."MEDICATIONS" MEDICATIONS ON PETS."ID" = MEDICATIONS."PETID"
WHERE
     petid >=INTEGER( $P{MIN_ID})
 AND petid <= $P{MAX_ID}
 AND takingdate >= $P{BEGIN_DATE}
ORDER BY
     MEDICATIONS."TAKINGDATE" ASC]]>
	</queryString>
	<field name="MEDICINE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DOSAGE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="VET" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="MTAKINGDATE" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="NOTES" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="NAME" minHeightToStartNewPage="1">
		<groupExpression><![CDATA[$F{NAME}]]></groupExpression>
		<groupHeader>
			<band height="27">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="75" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="18"/>
					</textElement>
					<text><![CDATA[NAME: ]]></text>
				</staticText>
				<textField hyperlinkType="None">
					<reportElement mode="Opaque" x="75" y="0" width="480" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{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" isSplitAllowed="false">
			<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="115" y="9" width="329" height="42"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="26" isBold="true"/>
				</textElement>
				<text><![CDATA[Pet's Medication Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band/>
	</pageHeader>
	<columnHeader>
		<band/>
	</columnHeader>
	<detail>
		<band height="114">
			<staticText>
				<reportElement x="0" y="13" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[MEDICINE: ]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" hyperlinkType="None">
				<reportElement x="75" y="13" width="480" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MEDICINE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="33" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[DOSAGE: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="75" y="33" width="480" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DOSAGE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="53" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[VET: ]]></text>
			</staticText>
			<textField hyperlinkType="None">
				<reportElement x="75" y="53" width="480" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{VET}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="73" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[DATE: ]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy" hyperlinkType="None">
				<reportElement x="75" y="73" width="480" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{MTAKINGDATE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="93" width="75" height="20"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<text><![CDATA[NOTES: ]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true" hyperlinkType="None">
				<reportElement x="75" y="93" width="480" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOTES}]]></textFieldExpression>
			</textField>
		</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>