<?xml version="1.0" encoding="UTF-8"?>
<!-- Created using JasperAssistant (http://www.jasperassistant.com) -->
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport name="ProductReport" columnCount="2" pageWidth="325" pageHeight="842" columnWidth="160" columnSpacing="5" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="8" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
	<parameter name="City" class="java.lang.String"/>
	<field name="id" class="java.lang.Integer">
	</field>
	<field name="name" class="java.lang.String">
	</field>
	<field name="quantity" class="java.lang.Float">
	</field>
	<field name="price" class="java.lang.Float">
	</field>
	<variable name="QuantityProductSum" class="java.lang.Float" resetType="Group" resetGroup="ProductGroup" calculation="Sum">
		<variableExpression><![CDATA[$F{quantity}]]></variableExpression>
	</variable>
	<variable name="PriceProductSum" class="java.lang.Float" resetType="Group" resetGroup="ProductGroup" calculation="Sum">
		<variableExpression><![CDATA[$F{price}]]></variableExpression>
	</variable>
	<variable name="QuantitySum" class="java.lang.Float" calculation="Sum">
		<variableExpression><![CDATA[$F{quantity}]]></variableExpression>
	</variable>
	<variable name="PriceSum" class="java.lang.Float" calculation="Sum">
		<variableExpression><![CDATA[$F{price}]]></variableExpression>
	</variable>
	<variable name="ProductCount" class="java.lang.Integer" resetType="Group" resetGroup="ProductGroup" calculation="System">
		<initialValueExpression><![CDATA[($V{ProductCount} != null)?(new Integer($V{ProductCount}.intValue() + 1)):(new Integer(1))]]></initialValueExpression>
	</variable>
	<group name="ProductGroup">
		<groupExpression><![CDATA[$F{id}]]></groupExpression>
		<groupHeader>
		<band height="14">
			<textField>
				<reportElement x="0" y="2" width="15" height="10"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{id}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" x="20" y="2" width="80" height="10"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" evaluationTime="Group" evaluationGroup="ProductGroup" pattern="#0">
				<reportElement positionType="Float" x="105" y="2" width="20" height="10"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Float"><![CDATA[$V{QuantityProductSum}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" evaluationTime="Group" evaluationGroup="ProductGroup" pattern="#0.00">
				<reportElement positionType="Float" x="130" y="2" width="30" height="10"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Float"><![CDATA[$V{PriceProductSum}]]></textFieldExpression>
			</textField>
		</band>
		</groupHeader>
		<groupFooter>
		<band>
		</band>
		</groupFooter>
	</group>
	<title>
		<band height="14">
			<staticText>
				<reportElement x="0" y="2" width="60" height="10"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<text><![CDATA[Title]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="2" width="325" height="10"/>
				<textElement textAlignment="Center">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Products ordered by people in " + $P{City}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="14">
			<rectangle>
				<reportElement mode="Transparent" x="0" y="2" width="325" height="10" forecolor="#808000"/>
				<graphicElement pen="Thin"/>
			</rectangle>
			<staticText>
				<reportElement x="0" y="2" width="60" height="10" forecolor="#808000"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<text><![CDATA[Page Header]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="14">
			<rectangle>
				<reportElement x="0" y="2" width="160" height="10" forecolor="#ffff99" backcolor="#ffff99"/>
				<graphicElement/>
			</rectangle>
			<staticText>
				<reportElement mode="Opaque" x="0" y="2" width="20" height="10" backcolor="#ffff99"/>
				<textElement textAlignment="Center">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[ID]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="20" y="2" width="85" height="10" backcolor="#ffff99"/>
				<textElement>
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[Name]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="105" y="2" width="20" height="10" backcolor="#ffff99"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[Qty]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="125" y="2" width="35" height="10" backcolor="#ffff99"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[Price]]></text>
			</staticText>
		</band>
	</columnHeader>
	<columnFooter>
		<band height="14">
			<line>
				<reportElement x="0" y="1" width="160" height="1"/>
				<graphicElement pen="Thin"/>
			</line>
			<staticText>
				<reportElement x="0" y="2" width="60" height="10"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<text><![CDATA[Column Footer]]></text>
			</staticText>
			<staticText>
				<reportElement x="70" y="2" width="30" height="10"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[Total :]]></text>
			</staticText>
			<textField pattern="#0">
				<reportElement x="105" y="2" width="20" height="10"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$V{QuantitySum}]]></textFieldExpression>
			</textField>
			<textField pattern="#0.00">
				<reportElement x="130" y="2" width="30" height="10"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$V{PriceSum}]]></textFieldExpression>
			</textField>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="14">
			<rectangle>
				<reportElement mode="Transparent" x="0" y="2" width="325" height="10" forecolor="#808000"/>
				<graphicElement pen="Thin"/>
			</rectangle>
			<staticText>
				<reportElement x="0" y="2" width="60" height="10" forecolor="#808000"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<text><![CDATA[Page Footer]]></text>
			</staticText>
			<textField>
				<reportElement x="150" y="2" width="100" height="10" forecolor="#808000"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Italic"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="250" y="2" width="50" height="10" forecolor="#808000"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="14">
			<rectangle>
				<reportElement x="0" y="2" width="325" height="10" forecolor="#808000" backcolor="#808000"/>
				<graphicElement pen="Thin"/>
			</rectangle>
			<staticText>
				<reportElement mode="Opaque" x="0" y="2" width="230" height="10" backcolor="#808000"/>
				<textElement>
					<font reportFont="Arial_Italic"/>
				</textElement>
				<text><![CDATA[Summary]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="230" y="2" width="55" height="10" backcolor="#808000"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<text><![CDATA[Count :]]></text>
			</staticText>
			<textField pattern="#0">
				<reportElement mode="Opaque" x="285" y="2" width="40" height="10" backcolor="#808000"/>
				<textElement textAlignment="Right">
					<font reportFont="Arial_Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{ProductCount}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
