<?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="AssetAllocation" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ab9201b9-389c-482e-9f75-7bdd382ebb0d">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="FundType" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="Year" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[Select * from assetallocation where FundType = $P{FundType} and Year = $P{Year}]]>
	</queryString>
	<field name="accountname" class="java.lang.String"/>
	<field name="fundtype" class="java.lang.String"/>
	<field name="balance" class="java.math.BigDecimal"/>
	<field name="accountid" class="java.lang.String"/>
	<field name="fundname" class="java.lang.String"/>
	<field name="year" class="java.lang.String"/>
	<field name="allocation" class="java.lang.Integer"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="42" splitType="Stretch">
			<staticText>
				<reportElement uuid="b9ebd50f-cf79-40e5-a770-7998aa4b293e" x="30" y="12" width="172" height="20"/>
				<textElement>
					<font size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[Asset Allocation Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="15" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="32" splitType="Stretch">
			<staticText>
				<reportElement uuid="867149e8-dde4-4f17-a357-21b4a2b6b9e1" x="0" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[accountname]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="9e803b25-1f75-494b-824a-8d300d04dffb" x="79" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[fundtype]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="b6cf8f05-74f7-484a-8be8-49b67d8944b1" x="158" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[balance]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="e1189108-f409-4783-8e16-686a104f0361" x="237" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[accountid]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="e625d923-7456-4e9f-854a-c381dac0572c" x="316" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[fundname]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="94bce451-c8d4-47d1-be3c-85d25fbb5d2f" x="395" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[year]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5b8b4ff1-44c4-4bb2-be89-df556e028587" x="474" y="0" width="79" height="20"/>
				<textElement/>
				<text><![CDATA[allocation]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="35" splitType="Stretch">
			<textField>
				<reportElement uuid="5b58a1c6-f567-4d04-ab38-4b338121e44e" x="0" y="0" width="79" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{accountname}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6613605e-4f22-450b-9178-47571ac9bdbf" x="79" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{fundtype}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="c70bf489-be9f-4250-bdc5-0a3692da4591" x="158" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{balance}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="d17e1c6b-54dd-4c6f-b9cd-5a370c4bc863" x="237" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{accountid}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="741ca2a2-1e91-48d4-ad4d-776898ee4061" x="316" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{fundname}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="ee765ac3-d123-478e-bdcd-ae4ebb207007" x="395" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{year}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="82ff23f9-7f08-4ae0-97e3-4d9ffb94d0f0" x="474" y="0" width="79" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{allocation}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="14" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="11" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="171" splitType="Stretch">
			<pie3DChart>
				<chart>
					<reportElement uuid="ecb2d108-2788-41f6-b3c1-edc4b356c36d" x="126" y="17" width="224" height="144"/>
					<chartTitle/>
					<chartSubtitle/>
					<chartLegend/>
				</chart>
				<pieDataset>
					<keyExpression><![CDATA[$F{fundname}]]></keyExpression>
					<valueExpression><![CDATA[$F{balance}]]></valueExpression>
				</pieDataset>
				<pie3DPlot>
					<plot/>
					<itemLabel/>
				</pie3DPlot>
			</pie3DChart>
		</band>
	</summary>
</jasperReport>
