NNd
-
Posts
9 -
Joined
-
Last visited
NNd's Achievements
-
I created a report with 2 subreports in detail section. In the subreports, I use page stop to limit the number of rows of data to be displayed on 1 page to 6 rows in both subreports. Everything is going well, but there is a problem that when the number of rows in the subreport is more than 1, the last page will be displayed as the main report page, except that the subreports are not displayed. I don't want this last page to be displayed. What should I do? Thanks . I have attached a file with rows of data in the subreports. ReturnProducts1(10-09-2024).rar sub report 1 sub report 2
-
My report shows duplicate pages based on the number of rows of data in the table(elements). I want to remove the duplicate pages, how do I do that? Thanks and regards have 3 Detail table(elements) in Detail 1 and Detail 3 <!-- Created with Jaspersoft Studio version 7.0.0.final using JasperReports Library version 7.0.0-b478feaa9aab4375eba71de77b4ca138ad2f62aa --> <jasperReport name="RetrunProducts" language="java" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f39b87e9-1534-4ba0-9716-4addafefb99d"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="*PHC*"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="basic" default="true" fontName="TH SarabunPSK" fontSize="16.0"> <paragraph leftIndent="3"/> </style> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Transparent" backcolor="#000000"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <dataset name="ReturnProductData" uuid="6dda87ae-bfee-4e78-96ca-5bc53ca4c24e"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="*PHC*"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <parameter name="DocNo" class="java.lang.String"/> <query language="SQL"><![CDATA[SELECT sale.DocNo AS DocNo, sale_detail.Item_Code AS Item_Code, item.NameTH AS item_Name, sale_detail.Qty AS Qty, sale.Cus_Code AS Cus_Code, sale.AreaCode AS AreaCode, customer.FName AS FName, sale_detail.Inv_Code AS Inv_Code, wh_inventory.LotNo AS Lotno FROM sale JOIN sale_detail ON sale_detail.DocNo = sale.Docno JOIN customer ON customer.Cus_Code = sale.Cus_Code JOIN item ON item.Item_Code = sale_detail.Item_Code JOIN wh_inventory ON wh_inventory.Inv_Code = sale_detail.Inv_Code WHERE sale.`Docno` = $P{DocNo}]]></query> <field name="DocNo" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="DocNo"/> <property name="com.jaspersoft.studio.field.label" value="DocNo"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="Item_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Item_Code"/> <property name="com.jaspersoft.studio.field.label" value="Item_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="item_Name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="NameTH"/> <property name="com.jaspersoft.studio.field.label" value="item_Name"/> <property name="com.jaspersoft.studio.field.tree.path" value="item"/> </field> <field name="Qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="Qty"/> <property name="com.jaspersoft.studio.field.label" value="Qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Cus_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.label" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="AreaCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="AreaCode"/> <property name="com.jaspersoft.studio.field.label" value="AreaCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="FName" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FName"/> <property name="com.jaspersoft.studio.field.label" value="FName"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer"/> </field> <field name="Inv_Code" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.name" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.label" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Lotno" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LotNo"/> <property name="com.jaspersoft.studio.field.label" value="Lotno"/> <property name="com.jaspersoft.studio.field.tree.path" value="wh_inventory"/> </field> </dataset> <parameter name="Item Code" class="java.lang.String"/> <parameter name="DocNo" class="java.lang.String"/> <query language="sql"><![CDATA[SELECT sale.DocNo AS DocNo, sale_detail.Item_Code AS Item_Code, item.NameTH AS item_Name, sale_detail.Qty AS Qty, sale.Cus_Code AS Cus_Code, sale.AreaCode AS AreaCode, customer.FName AS FName, sale_detail.Inv_Code AS Inv_Code, wh_inventory.LotNo AS Lotno FROM sale JOIN sale_detail ON sale_detail.DocNo = sale.Docno JOIN customer ON customer.Cus_Code = sale.Cus_Code JOIN item ON item.Item_Code = sale_detail.Item_Code JOIN wh_inventory ON wh_inventory.Inv_Code = sale_detail.Inv_Code WHERE sale.DocNo = $P{DocNo} ]]></query> <field name="DocNo" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="DocNo"/> <property name="com.jaspersoft.studio.field.label" value="DocNo"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="Item_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Item_Code"/> <property name="com.jaspersoft.studio.field.label" value="Item_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="item_Name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="NameTH"/> <property name="com.jaspersoft.studio.field.label" value="item_Name"/> <property name="com.jaspersoft.studio.field.tree.path" value="item"/> </field> <field name="Qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="Qty"/> <property name="com.jaspersoft.studio.field.label" value="Qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Cus_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.label" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="AreaCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="AreaCode"/> <property name="com.jaspersoft.studio.field.label" value="AreaCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="FName" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FName"/> <property name="com.jaspersoft.studio.field.label" value="FName"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer"/> </field> <field name="Inv_Code" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.name" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.label" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Lotno" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LotNo"/> <property name="com.jaspersoft.studio.field.label" value="Lotno"/> <property name="com.jaspersoft.studio.field.tree.path" value="wh_inventory"/> </field> <background splitType="Stretch"/> <pageHeader height="40"> <element kind="frame" uuid="746660fa-cc80-40b5-9cf2-ff87ccf3064e" x="0" y="0" width="555" height="40"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="image" uuid="f8606cef-d9d4-4be8-ba95-3dabe05e36fb" x="113" y="7" width="119" height="28"> <expression><![CDATA["https://jobbkk.com/upload/employer/0F/82F/00D82F/images/2021-12-087057.png"]]></expression> </element> <element kind="staticText" uuid="0486ba56-3542-4044-a73b-a363f851ab94" x="241" y="10" width="198" height="22" fontSize="18.0" bold="true" hTextAlign="Left"> <text><![CDATA[แบบฟอร์มการดำเนินการเกี่ยวกับสินค้า]]></text> </element> <box> <pen lineWidth="1.0"/> </box> </element> </pageHeader> <detail> <band height="329" splitType="Stretch"> <element kind="frame" uuid="1cc115ed-a0d3-4814-851a-b31b6c8fe051" x="0" y="0" width="555" height="329"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="f5316221-7b6f-4be8-bba4-1af83693fa8a" x="0" y="0" width="98" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายบริหารการขาย]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="49ad6748-5630-416a-9c4b-4e66cbf122b8" x="381" y="1" width="174" height="26" vTextAlign="Bottom"> <text><![CDATA[วันที่รับสินค้าส่งคืน / / ]]></text> </element> <element kind="staticText" uuid="b6e823de-e90b-494c-8e6a-89cbe666c7e2" x="0" y="28" width="555" height="22" fontName="TH SarabunPSK" vTextAlign="Bottom"> <paragraph leftIndent="3"/> <text><![CDATA[รายละเอียดผลิตภัณฑ์]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <element kind="rectangle" uuid="bc203efd-8269-40a3-817c-09a5b43b7cec" x="7" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="1b722353-86c3-4e35-a0de-310344963409" x="14" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ผู้แทนขายออกคำสั่งซื้อผิด]]></text> </element> <element kind="rectangle" uuid="3d3c1655-209a-4508-a560-c84323ad2924" x="214" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="4c02a0e6-5f7b-41de-9b26-3be83d610431" x="221" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฝ่าายคลังสินค้าจัดของผิด]]></text> </element> <element kind="rectangle" uuid="175f4ea1-d1c3-4e3c-9dc7-2fd389be9473" x="389" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="2dbd5bd5-e4bf-4d71-a953-b3b83eed296d" x="396" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[สินค้าใกล้หมดอายุ]]></text> </element> <element kind="rectangle" uuid="9ada6c11-81aa-4aab-8eee-d1d7a91daa81" x="8" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="c9971247-0691-4216-8732-e92053ec817d" x="15" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฝ่ายขายออกคำสั่งซื้อผิด]]></text> </element> <element kind="staticText" uuid="4c73dab2-0d15-4031-b5e0-634f0f136694" x="222" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ใบวิเคราะห์ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="4bb51891-114f-495b-bd80-fa5a56a6c134" x="215" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="0465a621-4088-4209-b0ba-2d25eb2a854d" x="390" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="6cbd1cd2-ade9-4d79-9fd9-c7785ecee675" x="397" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[Appearance หรือ Ref. ผิดปกติ]]></text> </element> <element kind="rectangle" uuid="1569edc3-c85d-4a38-bb20-ef32658bfe95" x="8" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="39c2c9fb-f10c-449f-ad59-f2ee37ebd11d" x="15" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ตามความต้องการของลูกค้า]]></text> </element> <element kind="rectangle" uuid="b44d90cf-0a70-4cc5-b144-919c9746e985" x="215" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="19c2e78e-8ddb-4ffc-a3c1-01f555f5d866" x="222" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฉลากไม่ครบ/ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="e4486e8c-bc1a-4fbf-8e0c-5d04b707193c" x="390" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="13ae1bc2-3ede-41ea-b7df-b1c32417f75b" x="397" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[บรรจุภัณฑ์ชำรุด]]></text> </element> <element kind="rectangle" uuid="eafce0d5-ad39-4a93-b9a5-13bfeb17cb9d" x="8" y="308" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="bf2d16e3-e769-4767-932f-63b0bc1c017e" x="15" y="297" width="254" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[อื่นๆ ]]></text> </element> <element kind="staticText" uuid="5db7a57f-865b-4f9d-8dd3-4c6a495756b7" x="290" y="298" width="262" height="22" vTextAlign="Bottom"> <text><![CDATA[ผู้ดำเนินการ วันที่ / / ]]></text> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="textField" uuid="c0d686f3-c653-45f9-a181-5b9eff08cd89" x="67" y="209" width="485" height="19"> <expression><![CDATA[$F{DocNo}]]></expression> </element> <element kind="textField" uuid="ff1161ca-829e-4897-9c4d-5aede47a454d" x="41" y="155" width="511" height="19"> <expression><![CDATA[$F{FName}]]></expression> </element> <element kind="component" uuid="7d118d18-cff1-45a1-b500-398099ba36f7" mode="Transparent" x="0" y="50" width="555" height="105" backcolor="#FFFFFF"> <component kind="table"> <datasetRun uuid="d51f8aa4-d4b2-41e4-95b0-21f21396234f" subDataset="ReturnProductData"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <parameter name="DocNo"> <expression><![CDATA[$P{DocNo}]]></expression> </parameter> </datasetRun> <column kind="single" uuid="33088c94-48be-4cbe-b002-27485baef9eb" width="60"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="c1787db4-f599-4af5-8fc4-1d54d220f975" x="0" y="0" width="60" height="19" vTextAlign="Bottom" style="basic"> <text><![CDATA[ชื่อผลิตภัณฑ์]]></text> </element> <property name="com.jaspersoft.studio.unit.height" value="px"/> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> </column> <column kind="single" uuid="09b2a670-3a34-4f32-877a-43ca80c5e28a" width="160"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="6348d175-8ff0-452f-a0c9-ebe8a4453be2" x="0" y="0" width="160" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{item_Name}]]></expression> <box bottomPadding="0" style="basic"> <pen lineWidth="1.0" lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> </column> <column kind="single" uuid="3f3d9f76-3d4d-4b08-a75c-79be240ced5e" width="55"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="803eba97-663c-4190-8ea0-e670a77f65cd" x="0" y="0" width="55" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="7"/> <text><![CDATA[Batch No.]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> </column> <column kind="single" uuid="5888c3c1-0dbc-476f-8b35-1328d518205a" width="75"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="a03737ec-4b42-4194-aa36-3d2170b4ee0f" x="0" y="0" width="75" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{Lotno}]]></expression> <box bottomPadding="0" style="basic"> <pen lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> </column> <column kind="single" uuid="c4e5e6ca-53fd-405d-a86e-d6288295aca1" width="30"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="c174d83f-dd18-4f20-a06a-f176f530a206" x="0" y="0" width="30" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="2"/> <text><![CDATA[ขนาด]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> </column> <column kind="single" uuid="99e1cc79-c61e-4157-8bd4-85c8c00308d8" width="70"> <detailCell height="19" rowSpan="1" style="basic"> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> </column> <column kind="single" uuid="af592516-d68a-4083-ad61-f797f9c2bffa" width="40"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="2d3f2697-1dac-444c-bfed-42166cb32791" x="0" y="0" width="40" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="3"/> <text><![CDATA[จำนวน]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> </column> <column kind="single" uuid="e6736b8e-f233-48ec-bf73-c17e1a3e6c44" width="65"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="88110802-b027-45a9-a274-bb8936959e44" x="0" y="0" width="65" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{Qty}]]></expression> <box bottomPadding="0" style="basic"> <pen lineWidth="1.0" lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> </column> </component> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/> </element> <element kind="line" uuid="49b18f2b-2ddc-47d8-adc5-9d79be82b8f5" x="42" y="170" width="512" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="staticText" uuid="0653c64d-51ad-4009-b56a-c6e5adc91966" x="0" y="155" width="555" height="74" fontName="TH SarabunPSK" vTextAlign="Bottom"> <paragraph leftIndent="3"/> <text><![CDATA[ชื่อลูกค้า สาเหตุการเปลี่ยน/คืน รายละเอียด อ้างอิงบิลเลขที่ สาเหตุการเปลี่ยน/คืน]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <element kind="line" uuid="8af1e6ba-7a1e-4711-90f4-25e13475c48e" x="94" y="189" width="460" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="a443b57d-b36f-4211-9d41-8a8fe49f396d" x="52" y="208" width="503" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="1fcaf310-36fc-4c54-803e-08b15fc2c49a" x="63" y="225" width="492" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="98d9bd0f-8b5a-4868-b806-6bfa4abb2629" x="35" y="316" width="250" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="47d250a4-e76b-49c0-9dd2-36e50135584c" x="343" y="316" width="108" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="8369633b-b1e2-4e34-a79e-f57d27457748" x="474" y="316" width="80" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> <band height="93"> <element kind="frame" uuid="9d708ea8-46ee-4d76-9b5a-bc7c9f286695" x="0" y="0" width="555" height="93"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="cf070fdd-9bf3-4502-921b-066742f9fb1d" x="0" y="0" width="150" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายควบคุมผลิตภัณฑ์สำเร็จรูป]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="ce5a3840-a294-4ff0-8eda-c36ace5cd6a9" x="0" y="28" width="555" height="32" fontSize="14.0"> <text><![CDATA[ชื่อผลิตภัณฑ์ ถูกต้อง ไม่ถูกต้อง Batch No. ถูกต้อง ไม่ถูกต้อง ขนาด ถูกต้อง ไม่ถูกต้อง จำนวน ถูกต้อง ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="3e610bb1-4317-4115-975f-bb3f407b40fc" x="72" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="c79f604f-fc80-4411-a5cb-514665ba9d2e" x="114" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="8f4b9140-d085-487d-928b-63e2bf8627e5" x="272" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="4b6676a3-5900-4481-90cd-055f7ab8ff11" x="314" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="e123b8a2-3e74-4f71-8b2b-ae4e1d43f46a" x="72" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="44fbc468-bdb2-41db-b0c4-a3e1daf90d1a" x="114" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="a010ff5b-5381-43e0-8365-6aed08770cf1" x="272" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="b07032c0-026f-47ce-85d7-176196f9bb92" x="314" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="161a0156-ab53-4330-ad51-ebc15a4aee56" x="0" y="71" width="555" height="22" fontSize="16.0"> <text><![CDATA[รับเข้าคลังสินค้า ใบรับเข้าเลขที่ ผู้ดำเนินการ วันที่ / /]]></text> </element> <element kind="line" uuid="0f2614d9-326d-4a8f-8e38-add5595dda0b" x="464" y="-306" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="88a730e3-092e-4b7c-b875-6d3787f2b77c" x="134" y="84" width="160" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="ab87c6d9-b0c8-4c63-acfe-036c6f810edf" x="348" y="84" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="8c2b1d23-44ca-4291-8b7f-590436f15ac6" x="464" y="84" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> <band height="309"> <element kind="frame" uuid="d5e6143e-b5fa-4ad0-8de7-7b5a5571f219" x="0" y="0" width="555" height="309"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="723f20ff-5a10-47dc-9e48-ae2f662ad6ac" x="0" y="0" width="98" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายควบคุมคุณภาพ]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="3825aa65-21b2-434a-8f8d-06386837ea05" x="0" y="29" width="555" height="22" fontSize="16.0"> <text><![CDATA[ ผลการตรวจสอบพบว่า:]]></text> </element> <element kind="component" uuid="9d523fd9-b497-4f59-9dd2-66b3010edfae" mode="Transparent" x="9" y="49" width="538" height="202" style="basic"> <component kind="table" whenNoDataType="AllSectionsNoDetail"> <datasetRun uuid="e5ad8b58-15c3-4bfe-bab6-f35cbc271a9b" subDataset="ReturnProductData"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <parameter name="DocNo"> <expression><![CDATA[$P{DocNo}]]></expression> </parameter> </datasetRun> <column kind="single" uuid="93cc7514-a1c9-4d08-9707-7ac19cf6cac8" width="200"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="c0aa3a0f-2610-4bd0-9b8c-71aa91095eab" mode="Transparent" x="0" y="0" width="200" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ชื่อผลิตภัณฑ์]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="60c1766c-86d0-4cc2-93f4-a3fa374344a6" mode="Transparent" x="0" y="0" width="200" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" vTextAlign="Middle"> <expression><![CDATA[$F{item_Name}]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> <box style="Table_TD"> <pen lineWidth="0.5"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> </column> <column kind="single" uuid="eace232a-6d7a-4ba8-bba2-fcfedec7b931" width="70"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="47199026-c597-421f-a727-39686691fc14" mode="Transparent" x="0" y="0" width="70" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[Batch no.]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="fc999319-ca3e-41c1-b665-c51ad0ee448d" mode="Transparent" x="0" y="0" width="70" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" vTextAlign="Middle"> <expression><![CDATA[$F{Lotno}]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> </column> <column kind="single" uuid="79659f7e-f69b-4b8c-845b-0fba946cbe94" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="eb73221a-8b2d-4b0d-b4c1-310d096e8f24" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[สภาพดี]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="4164188d-9d35-40bf-9081-90a26801abc2" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> </column> <column kind="single" uuid="1629d5f0-af82-4e58-aaa6-dd858fe5f045" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="5bb38840-6521-4c98-83b9-8843369e530f" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ทำสาย]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="6d61fbdd-0542-4aa2-ae7f-a2a1370dcd7c" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> </column> <column kind="single" uuid="246d9728-ffce-4204-81fe-2c8eff9d2f05" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="658cf30f-c9b1-4efd-9271-2d4abb9dc1d3" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ทำความสะอาด]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="fcc05be9-b70c-43f9-8fd1-f560b8784f51" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> </column> <column kind="group" uuid="1555497e-ce4a-45a0-8b1b-d43b36124e94" width="80"> <columnHeader height="20" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="95bf96b8-cb8e-429c-9240-bab71f547821" mode="Transparent" x="0" y="0" width="80" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ซ่อม/เปลี่ยน]]></text> <box> <pen lineWidth="0.5"/> </box> </element> </columnHeader> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Columns [4]"/> <column kind="single" uuid="ff1641c3-db05-4dff-9ca1-84ea2466cf24" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="8693b17e-d227-4d87-805e-3e8fc6e752e0" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[หัวจ่าย]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="7508d26e-ba3d-4072-836c-9a2ca47e26c0" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> </column> <column kind="single" uuid="1ad0f9de-3bff-45eb-8c2c-c01352478030" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="843ef909-e8ce-47bd-b77f-8598223b3ce7" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ฉลาก]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="3e7b5905-4cc2-4df5-9314-684ba87d1a46" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> </column> <column kind="single" uuid="b0a61349-a09c-4eb8-9ef1-45c9c3ae6b45" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="b79e03d0-3e34-444f-a86b-5dcc1ef63b2b" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ฟิล์ม]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="54afd251-a997-43e1-9614-3248441328af" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> </column> <column kind="single" uuid="20d5a084-be2e-4b1f-9715-4f8b21ea09c4" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="9ad8fa92-680f-4647-b2ad-dff7e55de52b" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[กล่อง]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="71cdbbbb-20ab-4f98-98b2-cddb390e9c66" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column9"/> </column> </column> <column kind="single" uuid="919eae7b-7c00-4c2f-8283-00bb37d76ce4" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="b991189d-f10e-4570-baeb-8c3161ee01b8" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[อื่น ๆ]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="8a09448c-87a8-4279-800f-eed8aa6fc26a" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column10"/> </column> <column kind="single" uuid="8298b3f1-5900-4c4b-8bb5-45a4daf7faf7" width="108"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="ea444388-30b3-4740-a963-3508ce2abcca" mode="Transparent" x="0" y="0" width="108" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[หมายเหตุ]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="8a828223-56e7-4955-80bd-e5f96cc09e68" mode="Transparent" x="0" y="0" width="108" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> <box style="Table_TD"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column11"/> </column> </component> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> </element> <element kind="staticText" uuid="bc110683-16ab-4193-a58d-b3080a0e9cb5" x="0" y="251" width="555" height="39" fontSize="16.0"> <text><![CDATA[หลังการดำเนินการตรวจสอบหรือแก้ไข ผู้ตรวจสอบ ]]></text> </element> <element kind="staticText" uuid="14fda64d-2820-485a-93a4-bbbef87afd2e" x="171" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[วันที่ / / ]]></text> </element> <element kind="staticText" uuid="c98e023a-dc22-4c7c-8f13-4443fcbd0d5e" x="437" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[วันที่ / / ]]></text> </element> <element kind="staticText" uuid="cef2e33c-bbd7-4ddd-a2df-d47ac772c048" x="283" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[ผู้อนุมัติ ]]></text> </element> <element kind="line" uuid="73935cb8-03da-4c86-9852-1d2a8d8dd31f" x="165" y="264" width="390" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="3a80b79c-d638-4fbb-bcf5-3d4155b962b6" x="51" y="282" width="120" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="6508cf8f-5c26-45ab-8a7e-af8a57c4e5c1" x="193" y="282" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="968f74a0-1fb7-4cde-976b-38894a728cd0" x="318" y="282" width="120" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="e41fddd8-612f-4ac2-b777-6cbce8e61495" x="459" y="282" width="95" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> </detail> <pageFooter height="20" splitType="Stretch"> <element kind="staticText" uuid="9843ef8a-e25b-4fcb-8a8d-641657eab250" x="397" y="0" width="158" height="20" bold="true" vTextAlign="Top"> <text><![CDATA[FM-MR-13 Rev.No.02/15-03-64]]></text> </element> <property name="com.jaspersoft.studio.unit.height" value="px"/> </pageFooter> </jasperReport>
-
jasper reports repeated pages following amount of row in table
NNd replied to NNd's topic in Connectors and Platforms
<!-- Created with Jaspersoft Studio version 7.0.0.final using JasperReports Library version 7.0.0-b478feaa9aab4375eba71de77b4ca138ad2f62aa --> <jasperReport name="RetrunProducts" language="java" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f39b87e9-1534-4ba0-9716-4addafefb99d"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="*PHC*"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="basic" default="true" fontName="TH SarabunPSK" fontSize="16.0"> <paragraph leftIndent="3"/> </style> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Transparent" backcolor="#000000"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <dataset name="ReturnProductData" uuid="6dda87ae-bfee-4e78-96ca-5bc53ca4c24e"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="*PHC*"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <parameter name="DocNo" class="java.lang.String"/> <query language="SQL"><![CDATA[SELECT sale.DocNo AS DocNo, sale_detail.Item_Code AS Item_Code, item.NameTH AS item_Name, sale_detail.Qty AS Qty, sale.Cus_Code AS Cus_Code, sale.AreaCode AS AreaCode, customer.FName AS FName, sale_detail.Inv_Code AS Inv_Code, wh_inventory.LotNo AS Lotno FROM sale JOIN sale_detail ON sale_detail.DocNo = sale.Docno JOIN customer ON customer.Cus_Code = sale.Cus_Code JOIN item ON item.Item_Code = sale_detail.Item_Code JOIN wh_inventory ON wh_inventory.Inv_Code = sale_detail.Inv_Code WHERE sale.`Docno` = $P{DocNo}]]></query> <field name="DocNo" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="DocNo"/> <property name="com.jaspersoft.studio.field.label" value="DocNo"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="Item_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Item_Code"/> <property name="com.jaspersoft.studio.field.label" value="Item_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="item_Name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="NameTH"/> <property name="com.jaspersoft.studio.field.label" value="item_Name"/> <property name="com.jaspersoft.studio.field.tree.path" value="item"/> </field> <field name="Qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="Qty"/> <property name="com.jaspersoft.studio.field.label" value="Qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Cus_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.label" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="AreaCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="AreaCode"/> <property name="com.jaspersoft.studio.field.label" value="AreaCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="FName" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FName"/> <property name="com.jaspersoft.studio.field.label" value="FName"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer"/> </field> <field name="Inv_Code" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.name" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.label" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Lotno" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LotNo"/> <property name="com.jaspersoft.studio.field.label" value="Lotno"/> <property name="com.jaspersoft.studio.field.tree.path" value="wh_inventory"/> </field> </dataset> <parameter name="Item Code" class="java.lang.String"/> <parameter name="DocNo" class="java.lang.String"/> <query language="sql"><![CDATA[SELECT sale.DocNo AS DocNo, sale_detail.Item_Code AS Item_Code, item.NameTH AS item_Name, sale_detail.Qty AS Qty, sale.Cus_Code AS Cus_Code, sale.AreaCode AS AreaCode, customer.FName AS FName, sale_detail.Inv_Code AS Inv_Code, wh_inventory.LotNo AS Lotno FROM sale JOIN sale_detail ON sale_detail.DocNo = sale.Docno JOIN customer ON customer.Cus_Code = sale.Cus_Code JOIN item ON item.Item_Code = sale_detail.Item_Code JOIN wh_inventory ON wh_inventory.Inv_Code = sale_detail.Inv_Code WHERE sale.DocNo = $P{DocNo} ]]></query> <field name="DocNo" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="DocNo"/> <property name="com.jaspersoft.studio.field.label" value="DocNo"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="Item_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Item_Code"/> <property name="com.jaspersoft.studio.field.label" value="Item_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="item_Name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="NameTH"/> <property name="com.jaspersoft.studio.field.label" value="item_Name"/> <property name="com.jaspersoft.studio.field.tree.path" value="item"/> </field> <field name="Qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="Qty"/> <property name="com.jaspersoft.studio.field.label" value="Qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Cus_Code" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.label" value="Cus_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="AreaCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="AreaCode"/> <property name="com.jaspersoft.studio.field.label" value="AreaCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale"/> </field> <field name="FName" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FName"/> <property name="com.jaspersoft.studio.field.label" value="FName"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer"/> </field> <field name="Inv_Code" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.name" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.label" value="Inv_Code"/> <property name="com.jaspersoft.studio.field.tree.path" value="sale_detail"/> </field> <field name="Lotno" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LotNo"/> <property name="com.jaspersoft.studio.field.label" value="Lotno"/> <property name="com.jaspersoft.studio.field.tree.path" value="wh_inventory"/> </field> <background splitType="Stretch"/> <pageHeader height="40"> <element kind="frame" uuid="746660fa-cc80-40b5-9cf2-ff87ccf3064e" x="0" y="0" width="555" height="40"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="image" uuid="f8606cef-d9d4-4be8-ba95-3dabe05e36fb" x="113" y="7" width="119" height="28"> <expression><![CDATA["https://jobbkk.com/upload/employer/0F/82F/00D82F/images/2021-12-087057.png"]]></expression> </element> <element kind="staticText" uuid="0486ba56-3542-4044-a73b-a363f851ab94" x="241" y="10" width="198" height="22" fontSize="18.0" bold="true" hTextAlign="Left"> <text><![CDATA[แบบฟอร์มการดำเนินการเกี่ยวกับสินค้า]]></text> </element> <box> <pen lineWidth="1.0"/> </box> </element> </pageHeader> <detail> <band height="329" splitType="Stretch"> <element kind="frame" uuid="1cc115ed-a0d3-4814-851a-b31b6c8fe051" x="0" y="0" width="555" height="329"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="f5316221-7b6f-4be8-bba4-1af83693fa8a" x="0" y="0" width="98" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายบริหารการขาย]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="49ad6748-5630-416a-9c4b-4e66cbf122b8" x="381" y="1" width="174" height="26" vTextAlign="Bottom"> <text><![CDATA[วันที่รับสินค้าส่งคืน / / ]]></text> </element> <element kind="staticText" uuid="b6e823de-e90b-494c-8e6a-89cbe666c7e2" x="0" y="28" width="555" height="22" fontName="TH SarabunPSK" vTextAlign="Bottom"> <paragraph leftIndent="3"/> <text><![CDATA[รายละเอียดผลิตภัณฑ์]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <element kind="rectangle" uuid="bc203efd-8269-40a3-817c-09a5b43b7cec" x="7" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="1b722353-86c3-4e35-a0de-310344963409" x="14" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ผู้แทนขายออกคำสั่งซื้อผิด]]></text> </element> <element kind="rectangle" uuid="3d3c1655-209a-4508-a560-c84323ad2924" x="214" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="4c02a0e6-5f7b-41de-9b26-3be83d610431" x="221" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฝ่าายคลังสินค้าจัดของผิด]]></text> </element> <element kind="rectangle" uuid="175f4ea1-d1c3-4e3c-9dc7-2fd389be9473" x="389" y="240" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="2dbd5bd5-e4bf-4d71-a953-b3b83eed296d" x="396" y="229" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[สินค้าใกล้หมดอายุ]]></text> </element> <element kind="rectangle" uuid="9ada6c11-81aa-4aab-8eee-d1d7a91daa81" x="8" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="c9971247-0691-4216-8732-e92053ec817d" x="15" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฝ่ายขายออกคำสั่งซื้อผิด]]></text> </element> <element kind="staticText" uuid="4c73dab2-0d15-4031-b5e0-634f0f136694" x="222" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ใบวิเคราะห์ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="4bb51891-114f-495b-bd80-fa5a56a6c134" x="215" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="0465a621-4088-4209-b0ba-2d25eb2a854d" x="390" y="263" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="6cbd1cd2-ade9-4d79-9fd9-c7785ecee675" x="397" y="252" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[Appearance หรือ Ref. ผิดปกติ]]></text> </element> <element kind="rectangle" uuid="1569edc3-c85d-4a38-bb20-ef32658bfe95" x="8" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="39c2c9fb-f10c-449f-ad59-f2ee37ebd11d" x="15" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ตามความต้องการของลูกค้า]]></text> </element> <element kind="rectangle" uuid="b44d90cf-0a70-4cc5-b144-919c9746e985" x="215" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="19c2e78e-8ddb-4ffc-a3c1-01f555f5d866" x="222" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[ฉลากไม่ครบ/ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="e4486e8c-bc1a-4fbf-8e0c-5d04b707193c" x="390" y="285" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="13ae1bc2-3ede-41ea-b7df-b1c32417f75b" x="397" y="274" width="146" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[บรรจุภัณฑ์ชำรุด]]></text> </element> <element kind="rectangle" uuid="eafce0d5-ad39-4a93-b9a5-13bfeb17cb9d" x="8" y="308" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="bf2d16e3-e769-4767-932f-63b0bc1c017e" x="15" y="297" width="254" height="22" fontSize="14.0" vTextAlign="Bottom"> <text><![CDATA[อื่นๆ ]]></text> </element> <element kind="staticText" uuid="5db7a57f-865b-4f9d-8dd3-4c6a495756b7" x="290" y="298" width="262" height="22" vTextAlign="Bottom"> <text><![CDATA[ผู้ดำเนินการ วันที่ / / ]]></text> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="textField" uuid="c0d686f3-c653-45f9-a181-5b9eff08cd89" x="67" y="209" width="485" height="19"> <expression><![CDATA[$F{DocNo}]]></expression> </element> <element kind="textField" uuid="ff1161ca-829e-4897-9c4d-5aede47a454d" x="41" y="155" width="511" height="19"> <expression><![CDATA[$F{FName}]]></expression> </element> <element kind="component" uuid="7d118d18-cff1-45a1-b500-398099ba36f7" mode="Transparent" x="0" y="50" width="555" height="105" backcolor="#FFFFFF"> <component kind="table"> <datasetRun uuid="d51f8aa4-d4b2-41e4-95b0-21f21396234f" subDataset="ReturnProductData"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <parameter name="DocNo"> <expression><![CDATA[$P{DocNo}]]></expression> </parameter> </datasetRun> <column kind="single" uuid="33088c94-48be-4cbe-b002-27485baef9eb" width="60"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="c1787db4-f599-4af5-8fc4-1d54d220f975" x="0" y="0" width="60" height="19" vTextAlign="Bottom" style="basic"> <text><![CDATA[ชื่อผลิตภัณฑ์]]></text> </element> <property name="com.jaspersoft.studio.unit.height" value="px"/> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> </column> <column kind="single" uuid="09b2a670-3a34-4f32-877a-43ca80c5e28a" width="160"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="6348d175-8ff0-452f-a0c9-ebe8a4453be2" x="0" y="0" width="160" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{item_Name}]]></expression> <box bottomPadding="0" style="basic"> <pen lineWidth="1.0" lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> </column> <column kind="single" uuid="3f3d9f76-3d4d-4b08-a75c-79be240ced5e" width="55"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="803eba97-663c-4190-8ea0-e670a77f65cd" x="0" y="0" width="55" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="7"/> <text><![CDATA[Batch No.]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> </column> <column kind="single" uuid="5888c3c1-0dbc-476f-8b35-1328d518205a" width="75"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="a03737ec-4b42-4194-aa36-3d2170b4ee0f" x="0" y="0" width="75" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{Lotno}]]></expression> <box bottomPadding="0" style="basic"> <pen lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> </column> <column kind="single" uuid="c4e5e6ca-53fd-405d-a86e-d6288295aca1" width="30"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="c174d83f-dd18-4f20-a06a-f176f530a206" x="0" y="0" width="30" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="2"/> <text><![CDATA[ขนาด]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> </column> <column kind="single" uuid="99e1cc79-c61e-4157-8bd4-85c8c00308d8" width="70"> <detailCell height="19" rowSpan="1" style="basic"> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> </column> <column kind="single" uuid="af592516-d68a-4083-ad61-f797f9c2bffa" width="40"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="staticText" uuid="2d3f2697-1dac-444c-bfed-42166cb32791" x="0" y="0" width="40" height="19" vTextAlign="Bottom" style="basic"> <paragraph leftIndent="3"/> <text><![CDATA[จำนวน]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> </column> <column kind="single" uuid="e6736b8e-f233-48ec-bf73-c17e1a3e6c44" width="65"> <detailCell height="19" rowSpan="1" style="basic"> <element kind="textField" uuid="88110802-b027-45a9-a274-bb8936959e44" x="0" y="0" width="65" height="19" hTextAlign="Left" vTextAlign="Bottom" style="basic"> <expression><![CDATA[$F{Qty}]]></expression> <box bottomPadding="0" style="basic"> <pen lineWidth="1.0" lineStyle="Dotted"/> <topPen lineWidth="0.0" lineStyle="Dotted" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </element> <box style="basic"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> </column> </component> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/> </element> <element kind="line" uuid="49b18f2b-2ddc-47d8-adc5-9d79be82b8f5" x="42" y="170" width="512" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="staticText" uuid="0653c64d-51ad-4009-b56a-c6e5adc91966" x="0" y="155" width="555" height="74" fontName="TH SarabunPSK" vTextAlign="Bottom"> <paragraph leftIndent="3"/> <text><![CDATA[ชื่อลูกค้า สาเหตุการเปลี่ยน/คืน รายละเอียด อ้างอิงบิลเลขที่ สาเหตุการเปลี่ยน/คืน]]></text> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </element> <element kind="line" uuid="8af1e6ba-7a1e-4711-90f4-25e13475c48e" x="94" y="189" width="460" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="a443b57d-b36f-4211-9d41-8a8fe49f396d" x="52" y="208" width="503" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="1fcaf310-36fc-4c54-803e-08b15fc2c49a" x="63" y="225" width="492" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="98d9bd0f-8b5a-4868-b806-6bfa4abb2629" x="35" y="316" width="250" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="47d250a4-e76b-49c0-9dd2-36e50135584c" x="343" y="316" width="108" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="8369633b-b1e2-4e34-a79e-f57d27457748" x="474" y="316" width="80" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> <band height="93"> <element kind="frame" uuid="9d708ea8-46ee-4d76-9b5a-bc7c9f286695" x="0" y="0" width="555" height="93"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="cf070fdd-9bf3-4502-921b-066742f9fb1d" x="0" y="0" width="150" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายควบคุมผลิตภัณฑ์สำเร็จรูป]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="ce5a3840-a294-4ff0-8eda-c36ace5cd6a9" x="0" y="28" width="555" height="32" fontSize="14.0"> <text><![CDATA[ชื่อผลิตภัณฑ์ ถูกต้อง ไม่ถูกต้อง Batch No. ถูกต้อง ไม่ถูกต้อง ขนาด ถูกต้อง ไม่ถูกต้อง จำนวน ถูกต้อง ไม่ถูกต้อง]]></text> </element> <element kind="rectangle" uuid="3e610bb1-4317-4115-975f-bb3f407b40fc" x="72" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="c79f604f-fc80-4411-a5cb-514665ba9d2e" x="114" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="8f4b9140-d085-487d-928b-63e2bf8627e5" x="272" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="4b6676a3-5900-4481-90cd-055f7ab8ff11" x="314" y="33" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="e123b8a2-3e74-4f71-8b2b-ae4e1d43f46a" x="72" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="44fbc468-bdb2-41db-b0c4-a3e1daf90d1a" x="114" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="a010ff5b-5381-43e0-8365-6aed08770cf1" x="272" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="rectangle" uuid="b07032c0-026f-47ce-85d7-176196f9bb92" x="314" y="49" width="6" height="6"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </element> <element kind="staticText" uuid="161a0156-ab53-4330-ad51-ebc15a4aee56" x="0" y="71" width="555" height="22" fontSize="16.0"> <text><![CDATA[รับเข้าคลังสินค้า ใบรับเข้าเลขที่ ผู้ดำเนินการ วันที่ / /]]></text> </element> <element kind="line" uuid="0f2614d9-326d-4a8f-8e38-add5595dda0b" x="464" y="-306" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="88a730e3-092e-4b7c-b875-6d3787f2b77c" x="134" y="84" width="160" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="ab87c6d9-b0c8-4c63-acfe-036c6f810edf" x="348" y="84" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="8c2b1d23-44ca-4291-8b7f-590436f15ac6" x="464" y="84" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> <band height="309"> <element kind="frame" uuid="d5e6143e-b5fa-4ad0-8de7-7b5a5571f219" x="0" y="0" width="555" height="309"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <element kind="staticText" uuid="723f20ff-5a10-47dc-9e48-ae2f662ad6ac" x="0" y="0" width="150" height="28" fontSize="18.0" bold="false" hTextAlign="Left" vTextAlign="Middle"> <text><![CDATA[ฝ่ายควบคุมคุณภาพ]]></text> <box> <pen lineWidth="0.5"/> </box> </element> <element kind="staticText" uuid="3825aa65-21b2-434a-8f8d-06386837ea05" x="0" y="29" width="555" height="22" fontSize="16.0"> <text><![CDATA[ ผลการตรวจสอบพบว่า:]]></text> </element> <element kind="component" uuid="9d523fd9-b497-4f59-9dd2-66b3010edfae" mode="Transparent" x="9" y="49" width="538" height="202" style="basic"> <component kind="table" whenNoDataType="AllSectionsNoDetail"> <datasetRun uuid="e5ad8b58-15c3-4bfe-bab6-f35cbc271a9b" subDataset="ReturnProductData"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <parameter name="DocNo"> <expression><![CDATA[$P{DocNo}]]></expression> </parameter> </datasetRun> <column kind="single" uuid="93cc7514-a1c9-4d08-9707-7ac19cf6cac8" width="200"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="c0aa3a0f-2610-4bd0-9b8c-71aa91095eab" mode="Transparent" x="0" y="0" width="200" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ชื่อผลิตภัณฑ์]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="60c1766c-86d0-4cc2-93f4-a3fa374344a6" mode="Transparent" x="0" y="0" width="200" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" vTextAlign="Middle"> <expression><![CDATA[$F{item_Name}]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> <box style="Table_TD"> <pen lineWidth="0.5"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> </column> <column kind="single" uuid="eace232a-6d7a-4ba8-bba2-fcfedec7b931" width="70"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="47199026-c597-421f-a727-39686691fc14" mode="Transparent" x="0" y="0" width="70" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[Batch no.]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="fc999319-ca3e-41c1-b665-c51ad0ee448d" mode="Transparent" x="0" y="0" width="70" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" vTextAlign="Middle"> <expression><![CDATA[$F{Lotno}]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> </column> <column kind="single" uuid="79659f7e-f69b-4b8c-845b-0fba946cbe94" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="eb73221a-8b2d-4b0d-b4c1-310d096e8f24" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[สภาพดี]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="4164188d-9d35-40bf-9081-90a26801abc2" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> </column> <column kind="single" uuid="1629d5f0-af82-4e58-aaa6-dd858fe5f045" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="5bb38840-6521-4c98-83b9-8843369e530f" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ทำสาย]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="6d61fbdd-0542-4aa2-ae7f-a2a1370dcd7c" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> </column> <column kind="single" uuid="246d9728-ffce-4204-81fe-2c8eff9d2f05" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="658cf30f-c9b1-4efd-9271-2d4abb9dc1d3" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ทำความสะอาด]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="fcc05be9-b70c-43f9-8fd1-f560b8784f51" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> </column> <column kind="group" uuid="1555497e-ce4a-45a0-8b1b-d43b36124e94" width="80"> <columnHeader height="20" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="95bf96b8-cb8e-429c-9240-bab71f547821" mode="Transparent" x="0" y="0" width="80" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ซ่อม/เปลี่ยน]]></text> <box> <pen lineWidth="0.5"/> </box> </element> </columnHeader> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Columns [4]"/> <column kind="single" uuid="ff1641c3-db05-4dff-9ca1-84ea2466cf24" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="8693b17e-d227-4d87-805e-3e8fc6e752e0" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[หัวจ่าย]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="7508d26e-ba3d-4072-836c-9a2ca47e26c0" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> </column> <column kind="single" uuid="1ad0f9de-3bff-45eb-8c2c-c01352478030" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="843ef909-e8ce-47bd-b77f-8598223b3ce7" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ฉลาก]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="3e7b5905-4cc2-4df5-9314-684ba87d1a46" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> </column> <column kind="single" uuid="b0a61349-a09c-4eb8-9ef1-45c9c3ae6b45" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="b79e03d0-3e34-444f-a86b-5dcc1ef63b2b" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[ฟิล์ม]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="54afd251-a997-43e1-9614-3248441328af" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> </column> <column kind="single" uuid="20d5a084-be2e-4b1f-9715-4f8b21ea09c4" width="20"> <columnHeader height="50" rowSpan="1" style="Table_CH"> <element kind="staticText" uuid="9ad8fa92-680f-4647-b2ad-dff7e55de52b" mode="Transparent" x="0" y="0" width="20" height="50" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="12.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[กล่อง]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="71cdbbbb-20ab-4f98-98b2-cddb390e9c66" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column9"/> </column> </column> <column kind="single" uuid="919eae7b-7c00-4c2f-8283-00bb37d76ce4" width="20"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="b991189d-f10e-4570-baeb-8c3161ee01b8" mode="Transparent" x="0" y="0" width="20" height="70" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[อื่น ๆ]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="8a09448c-87a8-4279-800f-eed8aa6fc26a" mode="Transparent" x="0" y="0" width="20" height="20" backcolor="#FFFFFF" rotation="Left" fontName="TH SarabunPSK" fontSize="14.0"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column10"/> </column> <column kind="single" uuid="8298b3f1-5900-4c4b-8bb5-45a4daf7faf7" width="108"> <columnHeader height="70" rowSpan="2" style="Table_CH"> <element kind="staticText" uuid="ea444388-30b3-4740-a963-3508ce2abcca" mode="Transparent" x="0" y="0" width="108" height="70" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <text><![CDATA[หมายเหตุ]]></text> <box> <pen lineWidth="0.0"/> </box> </element> </columnHeader> <detailCell height="20" style="Table_TD"> <element kind="textField" uuid="8a828223-56e7-4955-80bd-e5f96cc09e68" mode="Transparent" x="0" y="0" width="108" height="20" backcolor="#FFFFFF" fontName="TH SarabunPSK" fontSize="14.0" hTextAlign="Center" vTextAlign="Middle"> <expression><![CDATA["test"]]></expression> <box> <pen lineWidth="0.5"/> </box> </element> <box style="Table_TD"> <pen lineWidth="0.0"/> </box> </detailCell> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column11"/> </column> </component> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> </element> <element kind="staticText" uuid="bc110683-16ab-4193-a58d-b3080a0e9cb5" x="0" y="251" width="555" height="39" fontSize="16.0"> <text><![CDATA[หลังการดำเนินการตรวจสอบหรือแก้ไข ผู้ตรวจสอบ ]]></text> </element> <element kind="staticText" uuid="14fda64d-2820-485a-93a4-bbbef87afd2e" x="171" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[วันที่ / / ]]></text> </element> <element kind="staticText" uuid="c98e023a-dc22-4c7c-8f13-4443fcbd0d5e" x="437" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[วันที่ / / ]]></text> </element> <element kind="staticText" uuid="cef2e33c-bbd7-4ddd-a2df-d47ac772c048" x="283" y="269" width="114" height="19" fontSize="16.0"> <text><![CDATA[ผู้อนุมัติ ]]></text> </element> <element kind="line" uuid="73935cb8-03da-4c86-9852-1d2a8d8dd31f" x="165" y="264" width="390" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="3a80b79c-d638-4fbb-bcf5-3d4155b962b6" x="51" y="282" width="120" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="6508cf8f-5c26-45ab-8a7e-af8a57c4e5c1" x="193" y="282" width="90" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="968f74a0-1fb7-4cde-976b-38894a728cd0" x="318" y="282" width="120" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <element kind="line" uuid="e41fddd8-612f-4ac2-b777-6cbce8e61495" x="459" y="282" width="95" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <pen lineStyle="Dotted"/> </element> <box> <pen lineWidth="1.0"/> </box> </element> </band> </detail> <pageFooter height="20" splitType="Stretch"> <element kind="staticText" uuid="9843ef8a-e25b-4fcb-8a8d-641657eab250" x="397" y="0" width="158" height="20" bold="true" vTextAlign="Top"> <text><![CDATA[FM-MR-13 Rev.No.02/15-03-64]]></text> </element> <property name="com.jaspersoft.studio.unit.height" value="px"/> </pageFooter> </jasperReport> My XML Code -
My report shows duplicate pages based on the number of rows of data in the table(elements). I want to remove the duplicate pages, how do I do that? Thanks and regards have 3 Detail table(elements) in Detail 1 and Detail 3
-
-
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by net.sf.jasperreports_7.0.0.final How to fix?
