<?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="FestivalRegisterSubReport2" pageWidth="2482" pageHeight="555" orientation="Landscape" columnWidth="2482" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="7e031f34-4387-4b11-84f3-089363938bca">
	<property name="ireport.zoom" value="0.6830134553650705"/>
	<property name="ireport.x" value="925"/>
	<property name="ireport.y" value="0"/>
	<parameter name="LangCD" class="java.lang.String"/>
	<parameter name="EventCD" class="java.lang.String"/>
	<parameter name="Serial_Number" class="java.lang.String"/>
	<queryString>
		<![CDATA[select distinct FORCE_DEPLOY_CD,EVENT_CD,
LANG_CD,FORCE_TYPE,DEMANDED_COUNT,DEPLOYED_COUNT

from fr_tb_festival_force_deploy_t
where EVENT_CD = $P{EventCD}
and LANG_CD=$P{LangCD}
and
RECORD_STATUS='C']]>
	</queryString>
	<field name="FORCE_DEPLOY_CD" class="java.lang.Long">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="EVENT_CD" class="java.lang.Long">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="LANG_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="FORCE_TYPE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DEMANDED_COUNT" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DEPLOYED_COUNT" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<pageHeader>
		<band height="50">
			<textField>
				<reportElement uuid="9b5e66e1-0d8e-4261-ac78-3d9b971f7ac1" mode="Opaque" x="0" y="0" width="438" height="50" backcolor="#C0C0C0"/>
				<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" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "क्रम संख्या":"S. No."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="f6801f3b-beea-4659-ba56-d9f8d264c918" mode="Opaque" x="438" y="0" width="932" height="50" backcolor="#C0C0C0"/>
				<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"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "मांग पुलिस बल":"Demanded Police Force"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="0574c81f-baf4-46c0-8967-cb3f268c2cce" mode="Opaque" x="1370" y="0" width="1112" height="50" backcolor="#C0C0C0"/>
				<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"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "प्राप्त पुलिस बल":"Received Police Force"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="50">
			<textField>
				<reportElement uuid="fd43e657-a614-475d-a60f-1e2ff719863a" mode="Opaque" x="0" y="0" width="376" height="50" backcolor="#C0C0C0"/>
				<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"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="36ed4429-8883-4bc7-a184-c8095e920fca" mode="Opaque" x="438" y="0" width="524" height="50" backcolor="#C0C0C0"/>
				<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" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "प्रकार":"Type"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="750688b9-0360-438b-9c66-cab81ea3fbb4" mode="Opaque" x="962" y="0" width="408" height="50" backcolor="#C0C0C0"/>
				<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"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "संख्या":"Count"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="0fe433ae-fb84-461f-b562-299e100c2474" mode="Opaque" x="2173" y="0" width="309" height="50" backcolor="#C0C0C0"/>
				<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"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "संख्या":"Count"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="3a1ad922-e8ed-4bd0-b5aa-1e50dadb52b5" mode="Opaque" x="1370" y="0" width="803" height="50" backcolor="#C0C0C0"/>
				<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" isBold="true" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
					<paragraph leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LangCD}.equals( "6" )? "प्रकार":"Type"]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement uuid="9ba0f0ff-712a-4659-b594-1bea562d362f" mode="Opaque" x="0" y="0" width="438" height="50" forecolor="#000000" backcolor="#C0C0C0"/>
			</rectangle>
		</band>
	</columnHeader>
	<detail>
		<band height="50" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="31c25a16-cae9-4683-a9d9-3e5a77379e9c" positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="438" height="50" 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" rightIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{Serial_Number}+"."+$V{REPORT_COUNT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="abfe2343-c48c-49c0-9087-f88ec543e561" positionType="Float" stretchType="RelativeToTallestObject" x="438" y="0" width="524" height="50" 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{FORCE_TYPE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="7971091a-20d2-4fa4-82ce-802ca6f7285e" positionType="Float" stretchType="RelativeToTallestObject" x="962" y="0" width="408" height="50" 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 textAlignment="Right">
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10" rightIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DEMANDED_COUNT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="8b21b48f-ba0d-416b-a180-fa4da1dd4853" positionType="Float" stretchType="RelativeToTallestObject" x="1370" y="0" width="803" height="50" 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{FORCE_TYPE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement uuid="8752f8c7-e135-4921-8255-ead2c515370b" positionType="Float" stretchType="RelativeToTallestObject" x="2173" y="0" width="309" height="50" 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 textAlignment="Right">
					<font size="30" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph leftIndent="10" rightIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DEPLOYED_COUNT}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
