<?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="HarijanUtpidanDependentReport" pageWidth="2304" pageHeight="802" columnWidth="2304" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="562acf99-17d1-4ce9-916b-cd6c071b69dc">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="497"/>
	<property name="ireport.y" value="0"/>
	<parameter name="SCSTCASECD" class="java.lang.String"/>
	<parameter name="LangCD" class="java.lang.String"/>
	<queryString>
		<![CDATA[select  a.SC_ST_DEPENDENT_CD,a.SC_ST_CASE_CD,
 a.DEAD_VICTIM_NAME,
 GROUP_CONCAT(DEPENDENT_NAME) as 'dependent name',
 a.DEPENDENT_NAME,a.DEPENDENT_ADDRESS,
 RELATION_CD,AID_AMOUNT_GIVEN,mct.RELATION_TYPE
 from fr_tb_sc_st_cases_dependent_dtl_t a
left Join m_relation_type mct on mct.RELATION_TYPE_CD=a.RELATION_CD and a.Lang_CD=mct.Lang_CD
inner Join fr_tb_sc_st_cases_to_swd_t b on b.SC_ST_CASE_CD=a.SC_ST_CASE_CD and a.Lang_CD=b.Lang_CD
where a.Lang_CD =  $P{LangCD}
and a.SC_ST_CASE_CD like $P{SCSTCASECD}
and  a.RECORD_STATUS = 'C'
GROUP BY SC_ST_CASE_CD]]>
	</queryString>
	<field name="SC_ST_DEPENDENT_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SC_ST_CASE_CD" class="java.lang.Long">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DEAD_VICTIM_NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="dependent name" class="java.lang.String"/>
	<field name="DEPENDENT_NAME" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DEPENDENT_ADDRESS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="RELATION_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="AID_AMOUNT_GIVEN" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="RELATION_TYPE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<pageHeader>
		<band height="222" splitType="Stretch">
			<textField>
				<reportElement uuid="5a7e1d56-1b89-48a9-88be-90067a954328" positionType="FixRelativeToBottom" mode="Opaque" x="46" y="26" width="374" height="50" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement>
					<font size="30" isBold="false" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" ) ? "मृत्यु हो गई व्यक्ति के आश्रितों को आर्थिक मदद मिलती है की मांग:- ": "Dependents of died person seeking economic helps:- "]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="1eddd8eb-2ccd-46f5-a628-8c9585b92093" x="0" y="26" width="46" height="84"/>
				<textElement>
					<font size="30" isBold="false"/>
				</textElement>
				<text><![CDATA[11.]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="02b150e5-a11d-44e2-9cc0-6f4e2dd638ae" x="0" y="138" width="46" height="84"/>
				<textElement>
					<font size="30" isBold="false"/>
				</textElement>
				<text><![CDATA[12.]]></text>
			</staticText>
			<textField>
				<reportElement uuid="1d262ff6-5f83-45fa-bab9-6e0d5452fba6" positionType="FixRelativeToBottom" mode="Opaque" x="46" y="138" width="1994" height="84" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement>
					<font size="30" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" ) ? "पीडित के साथ पूरा पता और संबंध के साथ मर गया / प्रभावित पीड़ितों के आश्रित नाम :- ": "Died / Affected victims dependent's name with complete address and relation with the victim:- "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6d72b59b-5360-4e38-952f-a1d7e1d9ca45" positionType="FixRelativeToBottom" mode="Opaque" x="588" y="26" width="374" height="50" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement>
					<font size="30" isBold="false" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dependent name}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="120" splitType="Stretch">
			<textField>
				<reportElement uuid="050d14d9-f130-41dd-8dec-cdd7b2ccf845" positionType="FixRelativeToBottom" mode="Opaque" x="146" y="0" width="673" height="120" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font size="30" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "नाम":"Name"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="48be3fb7-c497-4e83-938c-046b9edd927d" positionType="FixRelativeToBottom" mode="Opaque" x="819" y="0" width="869" height="120" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font size="30" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "पता":"Address"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="505246a7-7c9e-419a-a754-8934fa8b30bc" positionType="FixRelativeToBottom" mode="Opaque" x="1688" y="0" width="550" height="120" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font size="30" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "शिकार के साथ संबंध":"Relationship with the victim"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b9d8ea6d-43d7-48e1-bc87-bd7a567ab82c" positionType="FixRelativeToBottom" mode="Opaque" x="46" y="0" width="100" height="120" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font size="30" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "क्रम संख्या":"S. No."]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="100" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="c34e3f00-e13e-4e64-b088-933a9bd433c8" stretchType="RelativeToTallestObject" x="46" y="0" width="100" height="100" isPrintWhenDetailOverflows="true"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="9f468079-4f7b-45f5-91d2-3de5ed60ddf7" stretchType="RelativeToTallestObject" x="819" y="0" width="869" height="100" isPrintWhenDetailOverflows="true"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DEPENDENT_ADDRESS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="ed25f664-b537-4f4f-827d-8e40d48aded6" stretchType="RelativeToTallestObject" x="146" y="0" width="673" height="100" isPrintWhenDetailOverflows="true"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DEAD_VICTIM_NAME}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="815c63e8-b2a4-4df1-93e8-cf3bfbc9d88d" stretchType="RelativeToTallestObject" x="1688" y="0" width="550" height="100" isPrintWhenDetailOverflows="true"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DEAD_VICTIM_NAME}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
