<?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="GoondaAnyOtherCommentsReport" pageWidth="2900" pageHeight="1500" orientation="Landscape" columnWidth="2900" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="6b7998c5-8e62-4282-870b-aa3a0b060d35">
	<property name="ireport.zoom" value="0.75"/>
	<property name="ireport.x" value="3"/>
	<property name="ireport.y" value="0"/>
	<parameter name="LangCD" class="java.lang.String"/>
	<parameter name="GOONDA_PERSON_CD" class="java.lang.String"/>
	<queryString>
		<![CDATA[select  a.GOONDA_PERSON_CD,a.GOONDA_CRIMINAL_HISTORY_CD,CRIME_NUMBER,CRIME_YEAR,
 ACTIVITY_DETAILS from fr_tb_goonda_criminal_history_t a
Where  a.RECORD_STATUS = 'C' and IS_PS_LEVEL = '0'
and a.Lang_CD =  $P{LangCD}
and a.GOONDA_PERSON_CD like $P{GOONDA_PERSON_CD}]]>
	</queryString>
	<field name="GOONDA_PERSON_CD" class="java.lang.Long">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="GOONDA_CRIMINAL_HISTORY_CD" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="CRIME_NUMBER" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="CRIME_YEAR" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ACTIVITY_DETAILS" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<columnHeader>
		<band height="120" splitType="Stretch">
			<textField>
				<reportElement uuid="a181bc27-3925-42fb-bcfe-4bdaa1aad00e" positionType="FixRelativeToBottom" mode="Opaque" x="0" y="60" 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" )? "अपराध संख्या":"Crime Number"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="534839c4-f310-4e6a-8c19-3d1a3917f4d2" positionType="FixRelativeToBottom" mode="Opaque" x="0" y="0" width="2900" 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" )? "अपराध इतिहास और गतिविधि विवरण":"Crime History and Activity Details"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6c42bcc2-deae-4ed5-b6a7-e0f1c6324847" positionType="FixRelativeToBottom" mode="Opaque" x="1809" y="60" 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" )? "गतिविधि विवरण":"Activity Details"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="102" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement uuid="5995a6d5-f37b-4168-9c1d-b0ca80e7a328" mode="Transparent" x="0" y="0" width="1809" height="100" 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{CRIME_NUMBER}+"/"+$F{CRIME_YEAR}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement uuid="1f7f10c2-138b-4e5f-9e7b-8b5c1aa619bf" mode="Transparent" x="1809" y="0" width="1091" height="100" 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{ACTIVITY_DETAILS}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
