<?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="GoondaActionTakenActnSectionfromPS" pageWidth="2860" pageHeight="555" orientation="Landscape" columnWidth="2860" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="2402d140-a1fd-4e5e-b115-9ebfaeae4512">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="LangCD" class="java.lang.String"/>
	<parameter name="GOONDA_CRIMINAL_HISTORY" class="java.lang.String"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[$P{SUBREPORT_DIR}]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select a.CRIMINAL_HISTORY_ACT_SECTION_CD,
 a.ACT_CD,a.SECTION_CD,a.GOONDA_PERSON_CD
 ,b.ACT_LONG,c.SECTION
 from fr_tb_goonda_criminal_history_dtl_t a
 inner join fr_tb_goonda_criminal_history_t cht on cht.GOONDA_CRIMINAL_HISTORY_CD = a.GOONDA_CRIMINAL_HISTORY_CD and a.LANG_CD and cht.LANG_CD
 ,m_act b,m_section c
 where a.ACT_CD=b.ACT_CD and a.LANG_CD = b.LANG_CD
 and a.SECTION_CD = c.SECTION_CODE
 and a.LANG_CD=c.LANG_CD  and a.IS_DELETED = '0'
 and a.RECORD_STATUS = 'C' and
 cht.IS_PS_LEVEL = '1'
  and a.Lang_CD =  $P{LangCD}
 and a.GOONDA_CRIMINAL_HISTORY_CD like $P{GOONDA_CRIMINAL_HISTORY}]]>
	</queryString>
	<field name="CRIMINAL_HISTORY_ACT_SECTION_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ACT_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SECTION_CD" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="GOONDA_PERSON_CD" class="java.lang.Long">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ACT_LONG" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="SECTION" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<columnHeader>
		<band height="61" splitType="Stretch">
			<textField>
				<reportElement uuid="98259cc6-c3df-447f-8095-6fe6cc1e5fc4" positionType="FixRelativeToBottom" mode="Opaque" x="0" y="1" width="1809" height="60" 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" )? "अधिनियम":"Act"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="96974f65-ed82-4f5d-8cd5-e376b5f69b73" positionType="FixRelativeToBottom" mode="Opaque" x="1809" y="1" width="1091" height="60" 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" )? "धारा":"Section"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="61" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement uuid="788fbb6d-46b7-46c9-9276-c031e9f4bbdb" mode="Transparent" x="1809" y="0" width="1091" height="60" forecolor="#000000" 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="Left" verticalAlignment="Top" rotation="None" markup="none">
					<font fontName="SansSerif" size="30" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph lineSpacing="Single" leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SECTION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement uuid="a008f396-d31a-4e80-91bb-734543586fd2" mode="Transparent" x="0" y="0" width="1809" height="60" forecolor="#000000" 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="Left" verticalAlignment="Top" rotation="None" markup="none">
					<font fontName="SansSerif" size="30" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Akshar.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
					<paragraph lineSpacing="Single" leftIndent="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ACT_LONG}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
