<?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="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7bcf8608-7d23-4273-8b52-91e0da8fd7af">
	<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.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="tax2011"/>
	<style name="Title" forecolor="#FFFFFF" fontName="Arial" fontSize="26" isBold="true" pdfFontName="Helvetica-Bold"/>
	<style name="SubTitle" forecolor="#666666" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<queryString>
		<![CDATA[SELECT  edate, eamount,
	 count(*), sum(eamount) sumeam
FROM expenses
Group by edate]]>
	</queryString>
	<field name="edate" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="edate"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="expenses"/>
	</field>
	<field name="eamount" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.label" value="eamount"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="expenses"/>
	</field>
	<field name="count(*)" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.label" value="count(*)"/>
	</field>
	<field name="sumeam" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.label" value="sumeam"/>
	</field>
	<sortField name="edate"/>
	<group name="edate">
		<groupExpression><![CDATA[$F{eamount}]]></groupExpression>
		<groupHeader>
			<band height="30">
				<textField pattern="dd/MM/yyyy">
					<reportElement style="SubTitle" x="47" y="5" width="150" height="24" forecolor="#333333" uuid="9a876409-0586-40f5-b0e9-d316d1e4d5d9"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{edate}]]></textFieldExpression>
				</textField>
				<rectangle>
					<reportElement mode="Opaque" x="0" y="5" width="36" height="24" forecolor="#CCCCCC" backcolor="#CCCCCC" uuid="c3a673b8-887a-4279-902f-d3a0f9749d11"/>
				</rectangle>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="22">
				<line>
					<reportElement positionType="FixRelativeToBottom" x="6" y="9" width="555" height="1" uuid="4297f0c7-0651-481f-9754-8385e9c316fd"/>
					<graphicElement>
						<pen lineWidth="0.5" lineColor="#999999"/>
					</graphicElement>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="70" splitType="Stretch">
			<image>
				<reportElement x="-20" y="0" width="595" height="64" uuid="f636156c-0a7d-4e35-8eff-53d0075e7f47"/>
				<imageExpression><![CDATA["wood.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement style="SubTitle" x="340" y="30" width="200" height="22" forecolor="#FFFFFF" uuid="2e0044dd-f6fe-4faf-b0fe-8e6731b6d503"/>
				<textElement textAlignment="Right"/>
				<text><![CDATA[Wood SubTitle]]></text>
			</staticText>
			<staticText>
				<reportElement x="6" y="12" width="274" height="30" forecolor="#FFFFFF" uuid="59aa7c7b-c359-432d-9832-76384c07df88"/>
				<textElement>
					<font size="22" isBold="true"/>
				</textElement>
				<text><![CDATA[Group Data Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="48" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="35" width="555" height="1" uuid="3fd14665-f25b-438d-8320-f4b51540397b"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="340" y="20" width="100" height="14" uuid="1e81e69f-ceac-4bd7-bfa7-96fba1094616"/>
				<text><![CDATA[Count]]></text>
			</staticText>
			<staticText>
				<reportElement x="230" y="20" width="93" height="16" uuid="a5be07a0-5535-498b-b6ef-b7c5f272b57f"/>
				<text><![CDATA[Day Total]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="42" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="10" y="30" width="555" height="1" uuid="a78db2b9-66e1-41b1-afe1-369826086671"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement x="340" y="0" width="100" height="20" uuid="ab14f123-4bf0-480a-a1e4-bb75ecd83ad1"/>
				<textElement verticalAlignment="Top"/>
				<textFieldExpression><![CDATA[$F{count(*)}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="237" y="-1" width="100" height="21" uuid="eeddd891-7fa2-47a4-a846-2af3c4179159">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="626ee319-cac0-4066-8b28-8116e9a7e3a1"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{sumeam}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="12" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement style="Column header" x="433" y="0" width="80" height="20" uuid="5f070d8f-3790-4637-9376-2fa61d7995c9"/>
				<textElement textAlignment="Right">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement style="Column header" x="513" y="0" width="40" height="20" uuid="759e71c1-f87a-4818-aa8f-e734aa66e6ad"/>
				<textElement>
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement style="Column header" x="0" y="0" width="197" height="20" uuid="6135f3dd-b223-49e5-8017-96ca4de17041"/>
				<textElement>
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
