Jasper INV >> Store Request - Aegis Web
Store Request Format (A4) -
<!-- Created with Jaspersoft Studio version 7.0.8.final using JasperReports Library version 7.0.8-6f896111 -->
<jasperReport name="Store_request" language="java" columnCount="1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="94b61d5c-0fd4-4fab-8890-70eba9d492fc">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<parameter name="requisition_number" class="java.lang.String"/>
<parameter name="requisition_date" class="java.lang.String"/>
<parameter name="fiscal_year" class="java.lang.String"/>
<parameter name="grand_total" class="java.lang.String"/>
<parameter name="grand_total_in_words" class="java.lang.String"/>
<parameter name="remarks" class="java.lang.String"/>
<parameter name="created_by" class="java.lang.String"/>
<parameter name="created_on" class="java.lang.String"/>
<parameter name="updated_by" class="java.lang.String"/>
<parameter name="updated_on" class="java.lang.String"/>
<parameter name="printed_by" class="java.lang.String"/>
<parameter name="printed_on" class="java.lang.String"/>
<parameter name="property_name" class="java.lang.String"/>
<parameter name="property_address" class="java.lang.String"/>
<parameter name="property_contact" class="java.lang.String"/>
<parameter name="property_email" class="java.lang.String"/>
<parameter name="approved_by_level_1" class="java.lang.String"/>
<parameter name="header_image" class="java.io.InputStream"/>
<parameter name="approved_by_level_2" class="java.lang.String"/>
<parameter name="approved_by_level_3" class="java.lang.String"/>
<parameter name="approved_by_level1_signature" class="java.io.InputStream"/>
<parameter name="approved_by_level2_signature" class="java.io.InputStream"/>
<parameter name="approved_by_level3_signature" class="java.io.InputStream"/>
<parameter name="created_by_signature" class="java.io.InputStream"/>
<parameter name="updated_by_signature" class="java.io.InputStream"/>
<parameter name="printed_by_signature" class="java.io.InputStream"/>
<query language="sql"><![CDATA[]]></query>
<field name="description" class="java.lang.String"/>
<field name="uom_full_name" class="java.lang.String"/>
<field name="uom_short_name" class="java.lang.String"/>
<field name="requested_quantity" class="java.lang.String"/>
<field name="approved_quantity" class="java.lang.String"/>
<field name="current_stock" class="java.lang.String"/>
<field name="average_rate" class="java.lang.String"/>
<field name="required_date" class="java.lang.String"/>
<field name="requested_by" class="java.lang.String"/>
<field name="requested_to" class="java.lang.String"/>
<field name="item_code" class="java.lang.String"/>
<group name="ReportSummary" keepTogether="true" preventOrphanFooter="true">
<groupHeader>
<band>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</band>
</groupHeader>
<groupFooter>
<band height="180">
<element kind="textField" uuid="b5fbe1a8-1a24-46f9-bf92-a7e731a2eb41" x="0" y="0" width="555" height="20" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box rightPadding="3">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="0.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["<b>Grand Total : </b>"+($P{grand_total} != null ? $P{grand_total} : "")]]></expression>
</element>
<element kind="image" uuid="49a4054e-a752-4276-8beb-8c6dc1a498e0" x="36" y="90" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{created_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{created_by_signature}]]></expression>
</element>
<element kind="image" uuid="c2dc505d-37e9-4aae-9f67-f23bb6c40ca7" x="255" y="90" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{updated_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{updated_by_signature}]]></expression>
</element>
<element kind="image" uuid="2e38523e-3ee4-4614-8606-efc9cdd8d6b0" x="474" y="90" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{printed_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{printed_by_signature}]]></expression>
</element>
<element kind="textField" uuid="4828c42b-e65d-44af-8c5b-54d4de85a1dd" x="447" y="135" width="100" height="20" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Printed By"]]></expression>
</element>
<element kind="textField" uuid="7af08fd5-c6a7-4388-964e-e8e1df9d83bf" x="227" y="135" width="100" height="20" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Updated By"]]></expression>
</element>
<element kind="textField" uuid="d5097173-68ee-4520-a73e-c474854522ee" x="447" y="120" width="100" height="15" fontSize="9.0" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{printed_by_signature} == null && $P{printed_by} != null && !$P{printed_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{printed_by}]]></expression>
</element>
<element kind="textField" uuid="c18b419c-e5b3-4a8c-a9a6-64b046dc8c6f" x="227" y="120" width="100" height="15" fontSize="9.0" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{updated_by_signature} == null && $P{updated_by} != null && !$P{updated_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{updated_by}]]></expression>
</element>
<element kind="textField" uuid="af1ca017-5790-4f0c-975a-af67d921a3e2" x="9" y="135" width="100" height="20" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Created By"]]></expression>
</element>
<element kind="textField" uuid="8c309e6b-43b9-41a4-88a0-8867f14a4463" x="9" y="120" width="100" height="15" fontSize="9.0" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{created_by_signature} == null && $P{created_by} != null && !$P{created_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{created_by}]]></expression>
</element>
<element kind="textField" uuid="bdd1af93-84e3-4bd4-9cb1-5678eefc7239" x="0" y="40" width="555" height="20" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Top">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box topPadding="5" leftPadding="2" rightPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA["<b>Remarks : </b>"+($P{remarks} != null ? $P{remarks} : "")]]></expression>
</element>
<element kind="textField" uuid="e4c196fb-2799-4bee-b33f-6ca850ad3148" x="0" y="20" width="555" height="20" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Left" vTextAlign="Top">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box topPadding="5" leftPadding="2" rightPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA["<b>Total In Words : </b>"+($P{grand_total_in_words} != null ? $P{grand_total_in_words} : "")]]></expression>
</element>
</band>
</groupFooter>
</group>
<background height="802" splitType="Stretch">
<element kind="rectangle" uuid="f4a8e992-6b2b-43f4-980d-be0d3b88d1be" x="0" y="0" width="555" height="802" mode="Transparent">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<pen lineWidth="0.0" lineStyle="Solid"/>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</background>
<title splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</title>
<pageHeader height="158" splitType="Stretch">
<element kind="image" uuid="ef2af2d4-5b75-4ba8-bf40-221e9e0116ac" x="2" y="2" width="551" height="95" removeLineWhenBlank="true" scaleImage="FillFrame" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
<printWhenExpression><![CDATA[$P{header_image} != null]]></printWhenExpression>
<expression><![CDATA[$P{header_image}]]></expression>
</element>
<element kind="textField" uuid="cd1909cb-2562-491b-84bd-f100c8f68df5" x="227" y="100" width="100" height="20" fontSize="10.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<box>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["STORE REQUEST"]]></expression>
</element>
<element kind="textField" uuid="0c5dfca1-4e51-4a4d-aba7-48ab82019290" x="2" y="126" width="551" height="15" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box rightPadding="2"/>
<expression><![CDATA["<b>Requisition Date | Time : </b>" +($P{requisition_date} != null ? $P{requisition_date} : "")]]></expression>
</element>
<element kind="textField" uuid="20186d50-abd5-4559-b1f8-c34dd272d7cf" x="2" y="141" width="551" height="15" positionType="Float" markup="html" fontSize="9.0" textAdjust="StretchHeight" bold="false" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box rightPadding="2"/>
<expression><![CDATA["<b>Requisition # : </b>" +($P{requisition_number} != null ? $P{requisition_number} : "")]]></expression>
</element>
</pageHeader>
<columnHeader height="24" splitType="Stretch">
<element kind="textField" uuid="60c25734-9af0-48ad-bfa5-5d82b4ff0a1c" x="0" y="0" width="26" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["S.No"]]></expression>
</element>
<element kind="textField" uuid="23575e9a-1993-4440-93e1-b21a55dee4d1" x="27" y="0" width="70" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Store/Sub Store"]]></expression>
</element>
<element kind="textField" uuid="179d52e7-f5c2-4c68-9079-4a997689aa60" x="172" y="0" width="165" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Item Name"]]></expression>
</element>
<element kind="textField" uuid="3aebc3cf-2e24-428e-8972-8196b4f4b31d" x="338" y="0" width="30" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["UOM"]]></expression>
</element>
<element kind="textField" uuid="4641e206-052c-4bfa-b10c-2e5662da2f44" x="370" y="0" width="49" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Curr. Stock"]]></expression>
</element>
<element kind="textField" uuid="061e7e93-b3cc-4331-9c6f-08651ab7e5ab" x="420" y="0" width="39" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Qty"]]></expression>
</element>
<element kind="textField" uuid="4e766993-128c-4adf-9119-393849c02245" x="460" y="0" width="48" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Avg. Rate"]]></expression>
</element>
<element kind="textField" uuid="cbb6e712-669a-40a0-bbfb-9324d11bf204" x="510" y="0" width="45" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Req. Date"]]></expression>
</element>
<element kind="textField" uuid="ba02cf05-5156-4375-9501-32d9736f53e9" x="96" y="0" width="74" height="24" fontSize="9.0" textAdjust="StretchHeight" bold="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<pen lineWidth="0.0"/>
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Req. By"]]></expression>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</columnHeader>
<detail>
<band height="24" splitType="Prevent">
<element kind="frame" uuid="e69d575c-3b43-4e84-b2cc-ea9154d5edb5" x="0" y="0" width="555" height="20" positionType="Float">
<element kind="textField" uuid="e22823ea-e0ec-4783-8318-25832959e66d" x="0" y="0" width="26" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$V{REPORT_COUNT}]]></expression>
</element>
<element kind="textField" uuid="d61dedca-4bce-48aa-b95f-96ba85b41457" x="172" y="0" width="165" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{description}]]></expression>
</element>
<element kind="textField" uuid="20162ebd-d6f4-4b2b-96b9-e6b1e0b49967" x="27" y="0" width="70" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{requested_to}]]></expression>
</element>
<element kind="textField" uuid="f6e0491d-b336-4d10-982a-5bef887d2109" x="338" y="0" width="30" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{uom_short_name}]]></expression>
</element>
<element kind="textField" uuid="69a81ae0-4e12-41fb-a9f9-6a8eb470444a" x="370" y="0" width="49" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{current_stock}]]></expression>
</element>
<element kind="textField" uuid="657fc35e-8566-4800-83b9-81e87d5a7285" x="420" y="0" width="39" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{requested_quantity}]]></expression>
</element>
<element kind="textField" uuid="7695f3c1-c657-4c53-9ee5-b060900d963e" x="460" y="0" width="48" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{average_rate}]]></expression>
</element>
<element kind="textField" uuid="60ca5524-9119-4b2c-aed1-a11317f6c7cb" x="510" y="0" width="45" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{required_date}]]></expression>
</element>
<element kind="textField" uuid="f7f39065-cfac-4b91-aa9d-02bb94d646e8" x="96" y="0" width="74" height="20" stretchType="ContainerHeight" fontSize="9.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Left" vTextAlign="Middle">
<box leftPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA[$F{requested_by}]]></expression>
</element>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</band>
</detail>
<columnFooter splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</columnFooter>
<pageFooter height="15" splitType="Stretch">
<element kind="textField" uuid="684d5d7c-8e97-4e2f-a302-35f1823c402e" x="0" y="0" width="280" height="15" fontSize="9.0" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<expression><![CDATA["Page " + $V{PAGE_NUMBER}]]></expression>
</element>
<element kind="textField" uuid="3c089190-4c51-43c8-8030-50c80ceb5eeb" x="280" y="0" width="274" height="15" fontSize="9.0" evaluationTime="Report" hTextAlign="Left" vTextAlign="Middle">
<expression><![CDATA[" of " + $V{PAGE_NUMBER}]]></expression>
</element>
</pageFooter>
<summary splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</summary>
</jasperReport>
Store Request Format A5 -
<!-- Created with Jaspersoft Studio version 7.0.8.final using JasperReports Library version 7.0.8-6f896111 -->
<jasperReport name="store_request_A5" language="java" columnCount="1" pageWidth="420" pageHeight="595" columnWidth="400" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="d87cea9a-e647-49e2-844e-d699ca2d171c">
<parameter name="requisition_number" class="java.lang.String"/>
<parameter name="requisition_date" class="java.lang.String"/>
<parameter name="fiscal_year" class="java.lang.String"/>
<parameter name="grand_total" class="java.lang.String"/>
<parameter name="grand_total_in_words" class="java.lang.String"/>
<parameter name="remarks" class="java.lang.String"/>
<parameter name="created_by" class="java.lang.String"/>
<parameter name="created_on" class="java.lang.String"/>
<parameter name="updated_by" class="java.lang.String"/>
<parameter name="updated_on" class="java.lang.String"/>
<parameter name="printed_by" class="java.lang.String"/>
<parameter name="printed_on" class="java.lang.String"/>
<parameter name="property_name" class="java.lang.String"/>
<parameter name="property_address" class="java.lang.String"/>
<parameter name="property_contact" class="java.lang.String"/>
<parameter name="property_email" class="java.lang.String"/>
<parameter name="approved_by_level_1" class="java.lang.String"/>
<parameter name="header_image" class="java.io.InputStream"/>
<parameter name="approved_by_level_2" class="java.lang.String"/>
<parameter name="approved_by_level_3" class="java.lang.String"/>
<parameter name="approved_by_level1_signature" class="java.io.InputStream"/>
<parameter name="approved_by_level2_signature" class="java.io.InputStream"/>
<parameter name="approved_by_level3_signature" class="java.io.InputStream"/>
<parameter name="created_by_signature" class="java.io.InputStream"/>
<parameter name="updated_by_signature" class="java.io.InputStream"/>
<parameter name="printed_by_signature" class="java.io.InputStream"/>
<query language="sql"><![CDATA[]]></query>
<field name="description" class="java.lang.String"/>
<field name="uom_full_name" class="java.lang.String"/>
<field name="uom_short_name" class="java.lang.String"/>
<field name="requested_quantity" class="java.lang.String"/>
<field name="approved_quantity" class="java.lang.String"/>
<field name="current_stock" class="java.lang.String"/>
<field name="average_rate" class="java.lang.String"/>
<field name="required_date" class="java.lang.String"/>
<field name="requested_by" class="java.lang.String"/>
<field name="requested_to" class="java.lang.String"/>
<field name="item_code" class="java.lang.String"/>
<group name="ReportSummary" keepTogether="true" preventOrphanFooter="true">
<groupHeader>
<band>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</band>
</groupHeader>
<groupFooter>
<band height="172">
<element kind="textField" uuid="e6bf76af-eb21-46b8-9306-dc5b8ecba13c" x="0" y="0" width="400" height="15" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box rightPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["<b>Grand Total : </b>" +($P{grand_total} != null ? $P{grand_total} : "")]]></expression>
</element>
<element kind="image" uuid="83e81038-f3be-46f5-b36c-8da096135ba5" x="24" y="82" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{created_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{created_by_signature}]]></expression>
</element>
<element kind="image" uuid="ab1c1af2-4a02-43f3-b132-1dda0617b23d" x="328" y="82" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{printed_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{printed_by_signature}]]></expression>
</element>
<element kind="image" uuid="289e71e2-2efe-4b75-932f-b08be279c71e" x="166" y="82" width="45" height="45" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<printWhenExpression><![CDATA[$P{updated_by_signature} != null]]></printWhenExpression>
<expression><![CDATA[$P{updated_by_signature}]]></expression>
</element>
<element kind="textField" uuid="6dc0d9aa-3c5f-41b3-a4ae-b06b809df637" x="6" y="132" width="80" height="15" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Created By"]]></expression>
</element>
<element kind="textField" uuid="49c08342-7fff-4613-8a19-02658854273c" x="310" y="132" width="80" height="15" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Printed By"]]></expression>
</element>
<element kind="textField" uuid="bd26ce26-9215-4e51-9180-1a8fcc66cfed" x="148" y="132" width="80" height="15" fontSize="9.0" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Updated By"]]></expression>
</element>
<element kind="textField" uuid="37f0ae5d-6e55-4996-ad63-e67284495220" x="6" y="112" width="80" height="15" fontSize="9.0" blankWhenNull="false" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<printWhenExpression><![CDATA[$P{created_by_signature} == null && $P{created_by} != null && !$P{created_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{created_by}]]></expression>
</element>
<element kind="textField" uuid="eef1a33c-703b-4349-9369-29fcfb30e751" x="310" y="112" width="80" height="15" fontSize="9.0" blankWhenNull="false" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<printWhenExpression><![CDATA[$P{printed_by_signature} == null && $P{printed_by} != null && !$P{printed_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{printed_by}]]></expression>
</element>
<element kind="textField" uuid="0ef744c1-f7dd-4128-b5be-4e59031d9913" x="148" y="112" width="80" height="15" fontSize="9.0" blankWhenNull="false" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<printWhenExpression><![CDATA[$P{updated_by_signature} == null && $P{updated_by} != null && !$P{updated_by}.trim().isEmpty()]]></printWhenExpression>
<expression><![CDATA[$P{updated_by}]]></expression>
</element>
<element kind="textField" uuid="443ae229-03ca-41e8-af51-4e993553e578" x="0" y="15" width="400" height="20" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Top">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box topPadding="5" leftPadding="2" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA["<b>Total In Words : </b>" +($P{grand_total_in_words} != null ? $P{grand_total_in_words} : "")]]></expression>
</element>
<element kind="textField" uuid="10906948-61e1-4f5a-a309-d17c034900aa" x="0" y="35" width="400" height="20" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Top">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box topPadding="5" leftPadding="2" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<expression><![CDATA["<b>Remarks : </b>" +($P{remarks} != null ? $P{remarks} : "")]]></expression>
</element>
</band>
</groupFooter>
</group>
<background height="575" splitType="Stretch">
<element kind="rectangle" uuid="73d2863a-5d58-4653-8058-8349664cd203" x="0" y="0" width="400" height="575" mode="Transparent">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<pen lineWidth="0.0"/>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</background>
<title splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</title>
<pageHeader height="144" splitType="Stretch">
<element kind="image" uuid="668355d2-7421-4463-9151-3fec0852fb6f" x="2" y="2" width="395" height="84" removeLineWhenBlank="true" scaleImage="FillFrame" hImageAlign="Center" vImageAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<printWhenExpression><![CDATA[$P{header_image} != null]]></printWhenExpression>
<expression><![CDATA[$P{header_image}]]></expression>
</element>
<element kind="textField" uuid="fb3bd6c4-033e-4671-ab3b-401265f9f6cc" x="150" y="89" width="100" height="15" bold="true" hTextAlign="Center" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["STORE REQUEST"]]></expression>
</element>
<element kind="textField" uuid="c6add065-5a06-4488-892a-839afa54c505" x="228" y="127" width="170" height="15" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<box rightPadding="2"/>
<expression><![CDATA["<b>Requisition # : </b>" +($P{requisition_number} != null ? $P{requisition_number} : "")]]></expression>
</element>
<element kind="textField" uuid="667cbe5b-3e41-45a1-8baa-f4292acde151" x="180" y="112" width="218" height="15" positionType="Float" markup="html" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" hTextAlign="Right" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box rightPadding="2"/>
<expression><![CDATA["<b>Requisition Date | Time : </b>" +($P{requisition_date} != null ? $P{requisition_date} : "")]]></expression>
</element>
</pageHeader>
<columnHeader height="30" splitType="Stretch">
<element kind="textField" uuid="47f0ec22-0c4a-4d96-93fc-c9e8f97b616b" x="0" y="0" width="20" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["S. No"]]></expression>
</element>
<element kind="textField" uuid="31b1ba77-de3c-4cc7-be61-55916ad968c3" x="21" y="0" width="41" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Store/Sub Store"]]></expression>
</element>
<element kind="textField" uuid="e5cafeb0-b45a-478c-be19-4cf863faf8b3" x="108" y="0" width="84" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Item Name"]]></expression>
</element>
<element kind="textField" uuid="8e092c0c-da1a-45d4-a77b-66c3bbdd80b3" x="193" y="0" width="30" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["UOM"]]></expression>
</element>
<element kind="textField" uuid="8971eacd-e4d4-4c9b-8956-e07ba87eb5bc" x="225" y="0" width="43" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Curr. Stock"]]></expression>
</element>
<element kind="textField" uuid="2096e821-b5be-4176-856c-85bd8a702752" x="350" y="0" width="50" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Req.Date"]]></expression>
</element>
<element kind="textField" uuid="ba30fd25-7f3e-461e-9ecd-6172903efc2e" x="270" y="0" width="40" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Qty"]]></expression>
</element>
<element kind="textField" uuid="8246b87e-ec84-429c-9559-047048d076fe" x="311" y="0" width="38" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Avg.Rate"]]></expression>
</element>
<element kind="textField" uuid="99fb1ed8-cdaf-473e-980d-1b7a5da9fcd4" x="63" y="0" width="44" height="30" positionType="Float" fontSize="8.0" textAdjust="StretchHeight" bold="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="2">
<topPen lineWidth="1.0" lineStyle="Solid"/>
<bottomPen lineWidth="1.0" lineStyle="Solid"/>
</box>
<expression><![CDATA["Requested By"]]></expression>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</columnHeader>
<detail>
<band height="25" splitType="Prevent">
<element kind="frame" uuid="b7c99a92-6bd1-403b-a094-10897b42cff0" x="0" y="0" width="400" height="25" positionType="Float">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<element kind="textField" uuid="65294511-514a-4264-8b86-c1759fb573d5" x="0" y="0" width="20" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="2"/>
<expression><![CDATA[$V{REPORT_COUNT}]]></expression>
</element>
<element kind="textField" uuid="ede8551d-7550-47f3-8bd6-98c96cb44858" x="21" y="0" width="41" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{requested_to}]]></expression>
</element>
<element kind="textField" uuid="82f7005c-f644-453b-9b4e-82acfe3d39d9" x="108" y="0" width="84" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{description}]]></expression>
</element>
<element kind="textField" uuid="241abef1-386b-48a6-9fe2-9518ca45e0a8" x="193" y="0" width="30" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{uom_short_name}]]></expression>
</element>
<element kind="textField" uuid="bf014d58-01f1-4c99-b094-3d6e187014af" x="225" y="0" width="43" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{current_stock}]]></expression>
</element>
<element kind="textField" uuid="9ea8f8fa-957f-4457-82fb-249623667a89" x="270" y="0" width="40" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{requested_quantity}]]></expression>
</element>
<element kind="textField" uuid="ae68e1bf-9673-4c52-a495-7c1e46c4865f" x="311" y="0" width="38" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{average_rate}]]></expression>
</element>
<element kind="textField" uuid="134cc7e9-0a4a-4460-8bca-a987a7ba861d" x="350" y="0" width="50" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box topPadding="0" leftPadding="1"/>
<expression><![CDATA[$F{required_date}]]></expression>
</element>
<element kind="textField" uuid="6d54d097-717e-4b2c-83c5-19af1de60238" x="63" y="0" width="44" height="25" stretchType="ContainerHeight" fontSize="8.0" textAdjust="StretchHeight" blankWhenNull="true" vTextAlign="Middle">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<box leftPadding="1"/>
<expression><![CDATA[$F{requested_by}]]></expression>
</element>
</element>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</band>
</detail>
<columnFooter splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</columnFooter>
<pageFooter height="15" splitType="Stretch">
<element kind="textField" uuid="452b972c-0aeb-48d5-94cb-f66b6b65b825" x="0" y="0" width="190" height="15" fontSize="9.0" hTextAlign="Right">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<expression><![CDATA["Page " + $V{PAGE_NUMBER}]]></expression>
</element>
<element kind="textField" uuid="74564261-1370-4533-b352-9e926e3a8fb4" x="190" y="0" width="210" height="15" fontSize="9.0" evaluationTime="Report" hTextAlign="Left">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<expression><![CDATA[" of " + $V{PAGE_NUMBER}]]></expression>
</element>
</pageFooter>
<summary splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</summary>
</jasperReport>
No Comments