<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  -->
<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="subreport4_1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9b9e65bf-9755-453b-a5cd-d2835eb79647">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="tax2011"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<parameter name="shop" class="java.lang.Long"/>
	<queryString>
		<![CDATA[SELECT
     expenses.`edate` AS expenses_edate,
     expenses.`eamount` AS expenses_eamount,
     expenses.`supplier` AS expenses_supplier
FROM
     `expenses` expenses
where
     expenses.`supplier` = $P{shop}
order by
     edate]]>
	</queryString>
	<field name="expenses_edate" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="expenses_edate"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="expenses"/>
	</field>
	<field name="expenses_eamount" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.label" value="expenses_eamount"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="expenses"/>
	</field>
	<field name="expenses_supplier" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.label" value="expenses_supplier"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="expenses"/>
	</field>
	<variable name="total" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{expenses_eamount}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField pattern="dd/MM/yyyy">
				<reportElement x="32" y="1" width="100" height="18" uuid="eda825bb-3ec3-4b9d-92a5-a845dcba6fb8"/>
				<textFieldExpression><![CDATA[$F{expenses_edate}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="180" y="1" width="118" height="18" uuid="0ef8ac47-9a80-4c26-87ae-2161b64e0a44"/>
				<textFieldExpression><![CDATA[$F{expenses_eamount}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="351" y="1" width="100" height="18" uuid="0439fa4c-21ad-46d1-ac0b-41d296cb2253"/>
				<textFieldExpression><![CDATA[$F{expenses_supplier}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="24">
			<textField pattern="€##,##0.00">
				<reportElement isPrintRepeatedValues="false" x="180" y="4" width="118" height="20" isPrintInFirstWholeBand="true" uuid="7d7c5b8d-2966-4d4d-8d55-2a30d2989be4"/>
				<textFieldExpression><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
		</band>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
