JRXML

Jrxml.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
<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="CrossCheck" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="89270185-cb23-480f-80d1-ee91b13ccfa9">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="REPORTSDB"/>
	<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
	<property name="ireport.jasperserver.user" value="jasperadmin|organization_1"/>
	<property name="ireport.jasperserver.report.resource" value="/JSW_Reports/CrossCheck_files/main_jrxml"/>
	<property name="ireport.jasperserver.reportUnit" value="/JSW_Reports/CrossCheck"/>
	<parameter name="CustometID" class="java.lang.Integer" isForPrompting="false"/>
	<queryString language="SQL">
		<![CDATA[select * from JSW_LOCATION_MASTER where ID_NO=$P!{CustometID}]]>
	</queryString>
	<field name="ID_NO" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.label" value="ID_NO"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="JSW_LOCATION_MASTER"/>
	</field>
	<field name="LOCATION_CODE" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="LOCATION_CODE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="JSW_LOCATION_MASTER"/>
	</field>
	<field name="LOCATION_NAME" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="LOCATION_NAME"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="JSW_LOCATION_MASTER"/>
	</field>
	<field name="IS_ACTIVE" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.label" value="IS_ACTIVE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="JSW_LOCATION_MASTER"/>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="35" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="61" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="100" height="30" uuid="eb872fd5-9a61-4b74-bce0-c5e67895a7b6">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5c0b679a-6701-4759-92b8-8dc5170c481d"/>
				</reportElement>
				<text><![CDATA[ID_NO]]></text>
			</staticText>
			<staticText>
				<reportElement x="190" y="0" width="100" height="30" uuid="5e87b8cd-6cfc-4e71-97c2-d901c2ef5682">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="238693ac-efa1-43db-870d-d102744517b3"/>
				</reportElement>
				<text><![CDATA[LOCATION_CODE]]></text>
			</staticText>
			<staticText>
				<reportElement x="419" y="0" width="100" height="30" uuid="502c36f3-f2e0-4e02-95e9-3fa3b241b1ba">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="aee0e651-d1ac-4eea-a9ce-48d5762cbc0e"/>
				</reportElement>
				<text><![CDATA[LOCATION_NAME]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="125" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="100" height="30" uuid="97381c9d-e5c8-4ca8-9e61-493b0dcf5d4d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5c0b679a-6701-4759-92b8-8dc5170c481d"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ID_NO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="190" y="23" width="100" height="30" uuid="3bf09f41-a157-4624-b3da-d956543f5e10">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="238693ac-efa1-43db-870d-d102744517b3"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{LOCATION_CODE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="419" y="22" width="100" height="30" uuid="7a16d288-45f9-4902-8ce8-2d109a3069f8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="aee0e651-d1ac-4eea-a9ce-48d5762cbc0e"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{LOCATION_NAME}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>