<?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="sales"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="595"
		 pageHeight="842"
		 columnWidth="535"
		 columnSpacing="0"
		 leftMargin="30"
		 rightMargin="30"
		 topMargin="20"
		 bottomMargin="20"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false"
		 whenResourceMissingType="Empty">
	<property name="ireport.scriptlethandling" value="2" />
	<import value="java.util.*" />
	<import value="net.sf.jasperreports.engine.*" />
	<import value="net.sf.jasperreports.engine.data.*" />
	<queryString><![CDATA[select a.*,b.ename,c.pname from DB2ADMIN.TEST_TRADEHIS a,DB2ADMIN.EPOD_LIST_DETAIL b,DB2ADMIN.TEST_PRODUCT c where b.elistid='testsales' and b.evalue=a.tsale and a.pno=c.pno  order by pno, tsale]]></queryString>
	<field name="TNO" class="java.lang.String"/>
	<field name="PNO" class="java.lang.String"/>
	<field name="TSALE" class="java.lang.String"/>
	<field name="TBUYER" class="java.lang.String"/>
	<field name="TNUM" class="java.lang.Integer"/>
	<field name="TPRICESUM" class="java.lang.Double"/>
	<field name="TDATE" class="java.util.Date"/>
	<field name="TPRICE" class="java.lang.Double"/>
	<field name="ENAME" class="java.lang.String"/>
	<field name="PNAME" class="java.lang.String"/>
		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="50"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						mode="Transparent"
						x="207"
						y="16"
						width="121"
						height="19"
						forecolor="#000000"
						backcolor="#FFFFFF"
						key="staticText-1"
						stretchType="NoStretch"
						positionType="FixRelativeToTop"
						isPrintRepeatedValues="true"
						isRemoveLineWhenBlank="false"
						isPrintInFirstWholeBand="false"
						isPrintWhenDetailOverflows="false"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single">
						<font fontName="瀹嬩綋" pdfFontName="Helvetica" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
					</textElement>
				<text><![CDATA[浜у搧閿