<?xml version="1.0" encoding="UTF-8"?>


<jasperReport
		xmlns="http://jasperreports.sourceforge.net/jasperreports"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
		name="OrdersReport" pageWidth="500" pageHeight="842" columnWidth="500" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<style name="Sans_Normal" isDefault="true" fontName="DejaVu Sans" fontSize="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
	<style name="Sans_Bold" isDefault="false" fontName="DejaVu Sans" fontSize="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
	<style name="Sans_Italic" isDefault="false" fontName="DejaVu Sans" fontSize="8" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false"/>
	<parameter name="CustomerID" class="java.lang.String"/>
	<queryString language="xPath"><![CDATA[/Northwind/Orders[CustomerID='$P{CustomerID}']]]></queryString>
	<field name="Id" class="java.lang.String">
		<fieldDescription><![CDATA[OrderID]]></fieldDescription>
	</field>
	<field name="OrderDate" class="java.util.Date">
		<fieldDescription><![CDATA[OrderDate]]></fieldDescription>
	</field>
	<field name="ShipCity" class="java.lang.String">
		<fieldDescription><![CDATA[ShipCity]]></fieldDescription>
	</field>
	<field name="Freight" class="java.lang.Float">
		<fieldDescription><![CDATA[Freight]]></fieldDescription>
	</field>
	<variable name="TotalFreight" class="java.lang.Float" calculation="Sum">
		<variableExpression><![CDATA[$F{Freight}]]></variableExpression>
	</variable>
	<pageHeader>
		<band height="14">
			<frame>
				<reportElement x="0" y="2" width="356" height="10" forecolor="#ccffff" backcolor="#ccffff" mode="Opaque"/>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="48" height="10" backcolor="#ccffff" style="Sans_Bold"/>
					<textElement textAlignment="Right"/>
					<text><![CDATA[ID]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="54" y="0" width="87" height="10" backcolor="#ccffff" style="Sans_Bold"/>
					<textElement textAlignment="Center"/>
					<text><![CDATA[Order Date]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="146" y="0" width="108" height="10" backcolor="#ccffff" style="Sans_Bold"/>
					<text><![CDATA[Ship City]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="259" y="0" width="92" height="10" backcolor="#ccffff" style="Sans_Bold"/>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Freight]]></text>
				</staticText>
			</frame>
		</band>
	</pageHeader>
	<detail>
		<band height="14">
			<textField>
				<reportElement x="0" y="2" width="51" height="10"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Id}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="yyyy, MMM dd">
				<reportElement positionType="Float" x="54" y="2" width="87" height="10"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{OrderDate}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" x="146" y="2" width="108" height="10"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ShipCity}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="¤ #,##0.00">
				<reportElement positionType="Float" x="259" y="2" width="92" height="10"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{Freight}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="14">
			<frame>
				<reportElement x="0" y="2" width="356" height="10" forecolor="#33cccc" backcolor="#33cccc" mode="Opaque"/>
				<staticText>
					<reportElement mode="Opaque" x="160" y="0" width="67" height="10" backcolor="#33cccc" style="Sans_Bold"/>
					<textElement textAlignment="Right"/>
					<text><![CDATA[Total :]]></text>
				</staticText>
				<textField>
					<reportElement mode="Opaque" x="259" y="0" width="92" height="10" backcolor="#33cccc" style="Sans_Bold"/>
					<textElement textAlignment="Right"/>
					<textFieldExpression class="java.lang.Float"><![CDATA[$V{TotalFreight}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="227" y="0" width="27" height="10" backcolor="#33cccc" style="Sans_Bold"/>
					<textElement textAlignment="Right"/>
					<textFieldExpression class="java.lang.Integer"><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</summary>
</jasperReport>
