<?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="report1" language="groovy" pageWidth="595" pageHeight="360" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="451f0ec4-d16f-49f3-b7bc-5b9b5d34f544">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="New Dataset 1" uuid="20306801-7ae4-4f82-9535-832e8a9d23cb">
		<queryString language="SQL">
			<![CDATA[select c_username, sum(replace(c_total, '$ ', '')) as total from app_fd_hr_expense_claim group by c_username]]>
		</queryString>
		<field name="c_username" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="total" class="java.lang.Double"/>
		<group name="group1"/>
	</subDataset>
	<queryString>
		<![CDATA[select c_username, cast(replace(c_total, '$ ', '') as Decimal(65,2)) as total from app_fd_hr_expense_claim]]>
	</queryString>
	<field name="c_username" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="total" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="555" height="62" uuid="347dfcfd-57ea-41de-8f43-bcbd5b2e624c"/>
				<textElement textAlignment="Center">
					<font size="34"/>
				</textElement>
				<text><![CDATA[Expenses Claim Report]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="187">
			<bar3DChart>
				<chart>
					<reportElement x="0" y="0" width="555" height="187" uuid="6e40deb0-e28f-4275-934d-302a7e88da03"/>
					<chartTitle/>
					<chartSubtitle/>
					<chartLegend/>
				</chart>
				<categoryDataset>
					<dataset>
						<datasetRun subDataset="New Dataset 1" uuid="67167009-5056-4404-b3de-d2976a481150"/>
					</dataset>
					<categorySeries>
						<seriesExpression><![CDATA["User"]]></seriesExpression>
						<categoryExpression><![CDATA[$F{c_username}]]></categoryExpression>
						<valueExpression><![CDATA[$F{total}]]></valueExpression>
					</categorySeries>
				</categoryDataset>
				<bar3DPlot>
					<plot/>
					<itemLabel/>
					<categoryAxisFormat>
						<axisFormat/>
					</categoryAxisFormat>
					<valueAxisFormat>
						<axisFormat/>
					</valueAxisFormat>
				</bar3DPlot>
			</bar3DChart>
		</band>
	</columnHeader>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
</jasperReport>
