Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="dummy_purchaseOrder" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="88ba5f8a-512a-480d-b610-881ab4521f0b">
- <property name="ireport.zoom" value="1.100000000000025"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="37"/>
- <parameter name="title" class="java.lang.String"/>
- <parameter name="main_ou" class="java.lang.String"/>
- <parameter name="status_doc" class="java.lang.String"/>
- <parameter name="so_no" class="java.lang.String"/>
- <parameter name="so_date" class="java.lang.String"/>
- <parameter name="due_date" class="java.lang.String"/>
- <parameter name="curr_code" class="java.lang.String"/>
- <parameter name="salesman" class="java.lang.String"/>
- <parameter name="remark" class="java.lang.String"/>
- <parameter name="customer" class="java.lang.String"/>
- <parameter name="customer_purchase_order_no" class="java.lang.String"/>
- <parameter name="customer_purchase_order_date" class="java.lang.String"/>
- <parameter name="customer_bill_to" class="java.lang.String"/>
- <parameter name="customer_contact_person" class="java.lang.String"/>
- <parameter name="total_item_amount" class="java.lang.Double"/>
- <parameter name="tax_amount" class="java.lang.Double"/>
- <parameter name="grand_total" class="java.lang.Double"/>
- <queryString>
- <![CDATA[select * from dummy_so]]>
- </queryString>
- <field name="product_name" class="java.lang.String"/>
- <field name="uom_so" class="java.lang.String"/>
- <field name="price" class="java.math.BigDecimal"/>
- <field name="qty_so" class="java.math.BigDecimal"/>
- <field name="sub_total_price" class="java.math.BigDecimal"/>
- <field name="qty_internal" class="java.math.BigDecimal"/>
- <field name="uom_internal" class="java.lang.String"/>
- <field name="ship_to_address" class="java.lang.String"/>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band splitType="Stretch"/>
- </title>
- <pageHeader>
- <band height="201" splitType="Stretch">
- <staticText>
- <reportElement uuid="abd7542b-bc75-4c3c-8da6-aa51ac58ecba" mode="Transparent" x="258" y="67" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Customer]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="0521b7a1-f150-4e3e-96f9-55ed46332920" stretchType="RelativeToBandHeight" x="92" y="68" width="140" height="20"/>
- <textElement textAlignment="Justified"/>
- <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd-MMM-yyyy").format(new java.text.SimpleDateFormat("yyyyMMdd").parse($P{so_date}))]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="9b9d0448-b924-4947-b2b7-ff6122a29d9f" x="1" y="68" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[SO Date]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="bb6d49f2-1a99-4fcb-9613-3c6a91aab55d" x="78" y="68" width="13" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="75b34bb4-5d8b-4b02-b55f-ba7f971f6f02" x="1" y="128" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Salesman]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="77745f15-39a5-4b07-b6ed-3729cdf615a9" x="78" y="128" width="13" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="0cb865f2-7cf2-4da5-bf29-ef8ab699b2a7" stretchType="RelativeToBandHeight" x="92" y="128" width="140" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{salesman}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="327974dd-308f-4a6a-9a70-987e8ab07ef3" x="1" y="108" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Currency]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="bdd95c1d-a1a7-469c-bfc4-2ba6d7e7888b" x="78" y="108" width="13" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="124e9807-da50-44ee-9bd9-b01aaffad7c3" stretchType="RelativeToBandHeight" x="92" y="108" width="140" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{curr_code}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="6e5a4fc5-8a92-4c80-84ce-42c36a83ca12" x="1" y="88" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Due Date]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="a41d75a5-eb64-431d-bf51-b421b1f8f2d5" x="78" y="88" width="13" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="fc939143-f261-4f50-99d5-bc72e044962d" stretchType="RelativeToBandHeight" x="92" y="88" width="140" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd-MMM-yyyy").format(new java.text.SimpleDateFormat("yyyyMMdd").parse($P{due_date}))]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="0692d6c4-c0f1-4fbe-8b47-c63b987a3be9" stretchType="RelativeToBandHeight" x="345" y="68" width="209" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{customer}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="4d935881-8fd2-461f-bda5-a98d245d5e9c" stretchType="RelativeToBandHeight" x="345" y="128" width="209" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{customer_bill_to}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="8b357ccd-f578-4ddf-a3e0-952060483b95" stretchType="RelativeToBandHeight" x="345" y="148" width="209" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{customer_contact_person}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="ab2885cf-b345-429b-a201-11deeb3eadca" x="345" y="88" width="209" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{customer_purchase_order_no}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="b32d8f46-83ed-460a-8a75-3488de7c7382" x="336" y="67" width="9" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="d61cad85-a076-422f-b3c6-10292419e6d3" x="345" y="108" width="209" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd-MMM-yyyy").format(new java.text.SimpleDateFormat("yyyyMMdd").parse($P{customer_purchase_order_date}))]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="1a6c3638-2357-4b75-8d78-d092803cf06d" mode="Transparent" x="258" y="128" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Bill To]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="090f18e2-8739-4000-b914-a3ebe953d682" mode="Transparent" x="258" y="148" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Contact Person]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="f3b12d32-adac-414f-a23b-7a45f60167f4" mode="Transparent" x="258" y="88" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[PO No.]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="6072eab6-a4c9-4270-b414-d9c9b3d4de5b" mode="Transparent" x="258" y="108" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[PO Date]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="bd6e2ad2-03ea-4723-b935-859a00aa59e0" x="336" y="128" width="9" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="57b8ce0e-6872-4b80-bf52-79bbd9a27336" x="336" y="148" width="9" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="e0198c76-1146-4592-acfb-ac5dff5e23cf" x="336" y="88" width="9" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="2cb25a92-6d9d-4d12-ad3a-2e43c0b3b167" x="336" y="108" width="9" height="20"/>
- <textElement/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="9a7d17d1-5e81-42e9-874e-7d591b2ccf19" x="92" y="148" width="140" height="53"/>
- <textElement/>
- <textFieldExpression><![CDATA[$P{remark}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="840f3e63-7813-42b2-ab35-bfd94ce40bda" x="1" y="148" width="78" height="20"/>
- <textElement/>
- <text><![CDATA[Remark]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="15e3a775-62ed-4046-8637-387997263090" x="78" y="148" width="13" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="c6ca140a-6554-4939-9e63-ae0613d77ef0" x="372" y="0" width="182" height="44"/>
- <textElement textAlignment="Right">
- <font size="16" isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{status_doc}]]></textFieldExpression>
- </textField>
- <line>
- <reportElement uuid="31c96244-1ecf-4520-9122-36192ca88885" x="0" y="65" width="554" height="1"/>
- <graphicElement>
- <pen lineWidth="2.0"/>
- </graphicElement>
- </line>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="e9d058a9-898a-479e-bba1-2a99c1f1066f" x="0" y="22" width="232" height="22"/>
- <textElement>
- <font size="12" isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{main_ou}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="3b0351c4-d59a-483a-91f0-91fed78b5267" x="0" y="0" width="232" height="22"/>
- <textElement>
- <font size="14" isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{title}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="dcc5c58c-4196-49df-aef2-026fe45723c9" stretchType="RelativeToBandHeight" x="0" y="44" width="232" height="20"/>
- <textElement>
- <font size="12" isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA["No. "+$P{so_no}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement uuid="b564dcb3-d424-43cf-a2e3-d2ea185a54b3" x="480" y="44" width="56" height="20"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of "]]></textFieldExpression>
- </textField>
- <textField evaluationTime="Report">
- <reportElement uuid="487d2a95-8527-448b-b890-00de3a6cfbb3" x="538" y="44" width="16" height="20"/>
- <box leftPadding="1"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="22" splitType="Stretch">
- <staticText>
- <reportElement uuid="a8dd679d-47a0-4af6-97e4-42a1fa02e844" x="0" y="2" width="183" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <text><![CDATA[Product]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="a88c7e73-93e3-42fc-9411-6e9fa1d9d679" x="293" y="2" width="64" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle"/>
- <text><![CDATA[Qty SO]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="5975a83e-9710-4998-974c-7a4805fdd6a7" x="421" y="2" width="65" height="20"/>
- <box leftPadding="0" rightPadding="0">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle"/>
- <text><![CDATA[Price]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="1f6c4543-5a6e-4618-88fe-dea92a725ce7" x="486" y="2" width="70" height="20"/>
- <box leftPadding="0" rightPadding="0">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle"/>
- <text><![CDATA[Sub Total]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="88d9637e-4f83-4f4d-b316-dbcca04ed0c2" x="357" y="2" width="64" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right" verticalAlignment="Middle"/>
- <text><![CDATA[Qty Internal]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="a8b070a7-daad-43f5-9bd4-11b3f05e6ea8" x="183" y="2" width="110" height="20"/>
- <box>
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <text><![CDATA[Ship To]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="20" splitType="Stretch">
- <textField isStretchWithOverflow="true">
- <reportElement uuid="ac77fb8b-0bb4-4227-aa3a-7d52d112f4c4" stretchType="RelativeToBandHeight" x="0" y="0" width="183" height="20"/>
- <box leftPadding="2" rightPadding="2"/>
- <textElement/>
- <textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="39c5d6c4-da5f-4c7b-bc6d-d96ad30c43ef" x="421" y="0" width="65" height="20"/>
- <box leftPadding="1" rightPadding="1"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.##",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{price})]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="e0000e58-2411-4fb7-982e-b55df6ca582f" x="486" y="0" width="70" height="20"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.##",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{sub_total_price})]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="e5db0f3b-7079-44a7-aa4d-a86a10424d9e" x="333" y="0" width="24" height="20"/>
- <box leftPadding="0" rightPadding="0"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[$F{uom_so}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="6261dd81-ab38-4f11-81fb-cdfb8ad88cad" x="293" y="0" width="40" height="20"/>
- <box leftPadding="0" rightPadding="0"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{qty_so})]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="0f8557be-5ef0-4dc0-96e8-a7087a2f2af2" x="397" y="0" width="24" height="20"/>
- <box leftPadding="0" rightPadding="0"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[$F{uom_internal}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="ab671ab1-56fc-4f0c-a754-79f71dc6ca0f" x="357" y="0" width="40" height="20"/>
- <box leftPadding="0" rightPadding="0"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{qty_internal})]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement uuid="29e38e42-b457-4bbc-b9e4-697bd9aaf4eb" x="183" y="0" width="110" height="20"/>
- <textElement/>
- <textFieldExpression><![CDATA[$F{ship_to_address}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <columnFooter>
- <band splitType="Stretch"/>
- </columnFooter>
- <lastPageFooter>
- <band height="62">
- <textField>
- <reportElement uuid="287a33d7-ad60-44e1-929e-72d737b1cfba" x="426" y="2" width="128" height="20"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.##",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($P{total_item_amount})]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement uuid="41a59e45-320e-4483-9b88-c678e6212d9f" x="426" y="22" width="128" height="20"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.##",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($P{tax_amount})]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement uuid="ec5e8c15-453a-4749-8e08-20aef27ae4be" x="426" y="42" width="128" height="20"/>
- <textElement textAlignment="Right">
- <font size="12" isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.##",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($P{grand_total})]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement uuid="fb70d127-585c-4335-aa1a-484e6ce0f69d" x="314" y="2" width="74" height="20"/>
- <textElement/>
- <text><![CDATA[Total Price]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="d8bb7c9a-7ac2-4c4c-bf36-b5f7fc73f2ea" x="314" y="22" width="74" height="20"/>
- <textElement/>
- <text><![CDATA[VAT (PPn)]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="65daa472-9b0e-4018-b868-3c4a0d471ea3" x="314" y="42" width="74" height="20"/>
- <textElement>
- <font size="12" isBold="true"/>
- </textElement>
- <text><![CDATA[Grand Total]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="3e8a8469-11b7-42c7-8cdf-d274b4041e92" x="387" y="2" width="15" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="dfab1510-4674-4645-a896-7010ec7c7cc1" x="387" y="22" width="15" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement uuid="a5e5c2ab-1f56-4ab7-a264-b3bb0a583139" x="387" y="42" width="15" height="20"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField>
- <reportElement uuid="97ad41ca-f1ea-4f21-a58d-dbabd1bd53f7" stretchType="RelativeToBandHeight" x="400" y="42" width="26" height="20"/>
- <textElement textAlignment="Right">
- <font size="12" isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{curr_code}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement uuid="f1f50a79-2088-42ed-995c-6c54c65b8abb" x="402" y="22" width="24" height="20"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[$P{curr_code}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement uuid="1cda4e5f-1e0c-4d97-8a26-b592c33bf96d" x="402" y="2" width="24" height="20"/>
- <textElement textAlignment="Right"/>
- <textFieldExpression><![CDATA[$P{curr_code}]]></textFieldExpression>
- </textField>
- <line>
- <reportElement uuid="891f199a-3b7b-45ed-b085-b8d6885ce2ab" x="1" y="1" width="553" height="1"/>
- </line>
- </band>
- </lastPageFooter>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement