<?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="AddressesReport"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="595"
		 pageHeight="842"
		 columnWidth="515"
		 columnSpacing="0"
		 leftMargin="40"
		 rightMargin="40"
		 topMargin="50"
		 bottomMargin="50"
		 whenNoDataType="AllSectionsNoDetail"
		 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.*" />
	<import value="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource" />

	<style 
		name="Arial_Normal"
		isDefault="true"
		fontName="Arial"
		fontSize="12"
		pdfFontName="Helvetica"
		pdfEncoding="Cp1252"
		isPdfEmbedded="false"
	/>
	<style 
		name="Arial_Normal_Small"
		isDefault="false"
		fontName="Arial"
		fontSize="9"
		pdfFontName="Helvetica"
		pdfEncoding="Cp1252"
		isPdfEmbedded="false"
	/>
	<style 
		name="Arial_Bold"
		isDefault="false"
		fontName="Arial"
		fontSize="12"
		isBold="true"
		pdfFontName="Helvetica-Bold"
		pdfEncoding="Cp1252"
		isPdfEmbedded="false"
	/>
	<style 
		name="Arial_Italic"
		isDefault="false"
		fontName="Arial"
		fontSize="12"
		isItalic="true"
		pdfFontName="Helvetica-Oblique"
		pdfEncoding="Cp1252"
		isPdfEmbedded="false"
	/>

	<parameter name="ReportTitle" isForPrompting="true" class="java.lang.String"/>
	<parameter name="CityFilter" isForPrompting="true" class="java.util.List"/>
	<queryString language="hql"><![CDATA[select address as address, document.id as documentId, document.total as documentTotal			from Address as address join address.documents as document			where city not in ($P{CityFilter})			order by address.city, address.lastName, address.firstName, address.id]]></queryString>

	<field name="id" class="java.lang.Long">
		<fieldDescription><![CDATA[address.id]]></fieldDescription>
	</field>
	<field name="firstName" class="java.lang.String">
		<fieldDescription><![CDATA[address.firstName]]></fieldDescription>
	</field>
	<field name="lastName" class="java.lang.String">
		<fieldDescription><![CDATA[address.lastName]]></fieldDescription>
	</field>
	<field name="street" class="java.lang.String">
		<fieldDescription><![CDATA[address.street]]></fieldDescription>
	</field>
	<field name="city" class="java.lang.String">
		<fieldDescription><![CDATA[address.city]]></fieldDescription>
	</field>
	<field name="documentId" class="java.lang.Long"/>
	<field name="documentTotal" class="java.lang.Double"/>

	<variable name="addressTotal" class="java.lang.Double" resetType="Group" resetGroup="AddressGroup" calculation="Sum">
		<variableExpression><![CDATA[$F{documentTotal}]]></variableExpression>
	</variable>

		<group  name="AddressGroup" >
			<groupExpression><![CDATA[			$F{id}		]]></groupExpression>
			<groupHeader>
			<band height="27"  isSplitAllowed="true" >
				<frame>					<reportElement						mode="Opaque"						x="0"						y="0"						width="515"						height="21"						backcolor="#E0E0E0"						key="frame"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement						x="5"						y="3"						width="160"						height="15"						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font fontName="妤蜂綋_GB2312"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{firstName} + " " + $F{lastName} + " (ID: " + $F{id} + ")"]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
					<reportElement						x="180"						y="3"						width="160"						height="15"						key="textField"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement textAlignment="Right">
						<font fontName="妤蜂綋_GB2312"/>
					</textElement>
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{city} + "," + $F{street}]]></textFieldExpression>
				</textField>
				</frame>			</band>
			</groupHeader>
			<groupFooter>
			<band height="27"  isSplitAllowed="true" >
				<line direction="TopDown">
					<reportElement						x="20"						y="0"						width="475"						height="1"						forecolor="#808080"						key="line"/>
					<graphicElement stretchType="NoStretch" pen="Thin"/>
				</line>
				<staticText>
					<reportElement						style="Arial_Normal_Small"						x="28"						y="8"						width="70"						height="15"						key="staticText"/>
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
					<textElement>
						<font fontName="妤蜂綋_GB2312" size="12"/>
					</textElement>
				<text><![CDATA[鍚堣