<?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="vw_items" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="BlankPage" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<style name="Row" mode="Transparent">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#E6DAC3"/>
		</conditionalStyle>
	</style>
	<parameter name="organd" class="java.lang.String"><defaultValueExpression><![CDATA[""]]></defaultValueExpression></parameter>
	<parameter name="orgwhere" class="java.lang.String"><defaultValueExpression><![CDATA[""]]></defaultValueExpression></parameter>
	<parameter name="filterid" class="java.lang.String">
		<defaultValueExpression><![CDATA["1"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT vw_items.item_category_name, vw_items.item_id, vw_items.item_name, vw_items.sales_account_id, vw_items.sales_account_name, vw_items.purchase_account_id, vw_items.purchase_account_name, vw_items.tax_type_name, vw_items.tax_rate, vw_items.item_unit_name, vw_items.sales_price, vw_items.purchase_price
FROM vw_items
$P!{orgwhere}

ORDER BY vw_items.item_category_name;]]>
	</queryString>
	<field name="item_category_name" class="java.lang.String"/>
	<field name="item_id" class="java.lang.Integer"/>
	<field name="item_name" class="java.lang.String"/>
	<field name="sales_account_id" class="java.lang.Integer"/>
	<field name="sales_account_name" class="java.lang.String"/>
	<field name="purchase_account_id" class="java.lang.Integer"/>
	<field name="purchase_account_name" class="java.lang.String"/>
	<field name="tax_type_name" class="java.lang.String"/>
	<field name="tax_rate" class="java.lang.Double"/>
	<field name="item_unit_name" class="java.lang.String"/>
	<field name="sales_price" class="java.lang.Double"/>
	<field name="purchase_price" class="java.lang.Double"/>
	<group name="item_category_name">
		<groupExpression><![CDATA[$F{item_category_name}]]></groupExpression>
		<groupHeader>
			<band height="52">
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="0" y="0" width="357" height="15"/>
					<textElement>
						<font fontName="Times New Roman" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{item_category_name}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement positionType="FixRelativeToBottom" x="0" y="48" width="802" height="1"/>
					<graphicElement>
						<pen lineWidth="0.5" lineColor="#999999"/>
					</graphicElement>
				</line>
				<staticText>
					<reportElement style="Column header" x="1" y="33" width="37" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Item ID]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="38" y="33" width="129" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Item Name]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="167" y="18" width="52" height="30" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Sales Account]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="219" y="33" width="97" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Account Name]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="316" y="18" width="52" height="30" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Purchase Account]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="368" y="33" width="97" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Account Name]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="465" y="33" width="78" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Tax Type]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="543" y="33" width="53" height="15" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Tax Rate]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="596" y="18" width="56" height="30" forecolor="#000000"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Item Unit Name]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="652" y="18" width="64" height="30" forecolor="#000000"/>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Sales Price]]></text>
				</staticText>
				<staticText>
					<reportElement style="Column header" x="716" y="18" width="64" height="30" forecolor="#000000"/>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<text><![CDATA[Purchase Price]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="4"/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="71" splitType="Stretch">
			<staticText>
				<reportElement style="Title" x="66" y="0" width="446" height="62"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Times New Roman" size="24" pdfFontName="Times-Roman"/>
				</textElement>
				<text><![CDATA[Items Report]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="13" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="802" height="15"/>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="1" y="0" width="37" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Integer"><![CDATA[$F{item_id}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="38" y="0" width="129" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{item_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="167" y="0" width="52" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Integer"><![CDATA[$F{sales_account_id}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="219" y="0" width="97" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{sales_account_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="316" y="0" width="52" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Integer"><![CDATA[$F{purchase_account_id}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="368" y="0" width="97" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{purchase_account_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="465" y="0" width="78" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{tax_type_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="543" y="0" width="53" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$F{tax_rate}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="596" y="0" width="56" height="15"/>
					<textElement>
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{item_unit_name}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="652" y="0" width="64" height="15"/>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$F{sales_price}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement style="Detail" x="716" y="0" width="64" height="15"/>
					<textElement textAlignment="Right">
						<font fontName="Times New Roman" size="10"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$F{purchase_price}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="15" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="802" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="-21" y="1" width="841" height="24" forecolor="#D0B48E" backcolor="#F2EBDF"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="771" y="1" width="40" height="20" forecolor="#736343"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement style="Column header" x="691" y="1" width="80" height="20" forecolor="#736343"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
				</textField>
				<textField pattern="EEEEE, d MMMMM yyyy HH:mm:ss Z">
					<reportElement style="Column header" x="22" y="1" width="197" height="20" forecolor="#736343"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Times New Roman" size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
