<?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="dependents" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="BlankPage" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d5e573d3-a32c-4715-930e-322744a096d7">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<style name="Row" mode="Transparent">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#E6DAC3"/>
		</conditionalStyle>
	</style>
	<parameter name="filterid" class="java.lang.String">
		<defaultValueExpression><![CDATA["1"]]></defaultValueExpression>
	</parameter>
	<parameter name="orgid" class="java.lang.String">
		<defaultValueExpression><![CDATA["0"]]></defaultValueExpression>
	</parameter>
	<parameter name="orgwhere" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="organd" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT vw_kins.entity_name, vw_kins.beneficiary, vw_kins.beneficiary_ps, vw_kins.full_names, vw_kins.entity_id, vw_kins.relation, vw_kins.kin_type_name

FROM vw_kins

WHERE vw_kins.beneficiary = true
$P!{organd}]]>
	</queryString>
	<field name="entity_name" class="java.lang.String"/>
	<field name="beneficiary" class="java.lang.Boolean"/>
	<field name="beneficiary_ps" class="java.lang.Float"/>
	<field name="full_names" class="java.lang.String"/>
	<field name="entity_id" class="java.lang.Integer"/>
	<field name="relation" class="java.lang.String"/>
	<field name="kin_type_name" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="33" splitType="Stretch">
			<staticText>
				<reportElement style="Title" x="0" y="0" width="555" height="33" uuid="cef4ccaa-7868-4a4d-9d42-0491eda88602"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Times New Roman" size="28" pdfFontName="Times-Roman"/>
				</textElement>
				<text><![CDATA[Dependents Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="16" splitType="Stretch">
			<staticText>
				<reportElement style="Column header" x="82" y="0" width="148" height="15" forecolor="#000000" uuid="14a2db7b-6aa3-4aad-b9d8-137f9c379b47"/>
				<textElement>
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<text><![CDATA[Employee Name]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="230" y="0" width="162" height="15" forecolor="#000000" uuid="a69450ab-3a54-4546-a9a2-9499334b1a95"/>
				<textElement>
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<text><![CDATA[Dependant Name]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="2" y="0" width="80" height="15" forecolor="#000000" uuid="95d969dc-97b6-47ae-91ea-caf49abb06ea"/>
				<textElement>
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<text><![CDATA[Entity ID]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="392" y="0" width="120" height="15" forecolor="#000000" uuid="4c035b1a-a916-4edc-943f-d755d738e29c"/>
				<textElement>
					<font fontName="Times New Roman" size="10"/>
				</textElement>
				<text><![CDATA[Dependent Relation]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="15" width="555" height="1" uuid="9a5e0c8c-4996-4531-9417-b2635e9902ab"/>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="16" uuid="401a29eb-fdb6-4580-ae0b-eebe3ca9bb84"/>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="82" y="0" width="148" height="15" uuid="841ac69f-5098-46c3-88d3-605206b45930"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{entity_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="230" y="0" width="162" height="15" uuid="6e986766-1498-415a-a376-afe92f66ad16"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{full_names}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="2" y="0" width="80" height="15" uuid="957cdcf0-30cd-421c-91be-e118a77ffa9f"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{entity_id}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="392" y="0" width="120" height="15" uuid="c53664f2-c732-426e-bba9-127f9b362683"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{relation}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="3" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="0bdae9bd-ef88-4c49-9d8d-c6fe3c033b48"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="533" y="0" width="40" height="20" forecolor="#736343" uuid="15b57eb4-16cf-4e64-856e-75a451e5ffad"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement style="Column header" x="453" y="0" width="80" height="20" forecolor="#736343" uuid="df63a7b2-4a19-4d6a-a30b-c7ee17db7d09"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
				</textField>
				<textField pattern="MMMMM dd, yyyy">
					<reportElement mode="Transparent" x="22" y="4" width="168" height="20" uuid="4c15ddfe-cbf3-44b2-92fc-a96b3e69a87c"/>
					<textElement>
						<font fontName="Times New Roman"/>
					</textElement>
					<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
