summaryrefslogtreecommitdiff
path: root/jasper_reports/custom_reports/logbook_sj.jrxml
diff options
context:
space:
mode:
Diffstat (limited to 'jasper_reports/custom_reports/logbook_sj.jrxml')
-rw-r--r--jasper_reports/custom_reports/logbook_sj.jrxml253
1 files changed, 253 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/logbook_sj.jrxml b/jasper_reports/custom_reports/logbook_sj.jrxml
new file mode 100644
index 0000000..9cf38e4
--- /dev/null
+++ b/jasper_reports/custom_reports/logbook_sj.jrxml
@@ -0,0 +1,253 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e -->
+<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="logbook_sj" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6d86dab4-0040-4ba1-be1d-8bc305baaca3">
+ <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter9.jrdax"/>
+ <property name="ODOO_RELATIONS">
+ <![CDATA[['report_logbook_sj_line']]]>
+ </property>
+ <queryString language="XPath">
+ <![CDATA[]]>
+ </queryString>
+ <field name="Document No" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Name-name]]></fieldDescription>
+ </field>
+ <field name="Created By" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_By-created_by/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Created_By-created_by/Name-name]]></fieldDescription>
+ </field>
+ <field name="Date Created" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Created-date"/>
+ <fieldDescription><![CDATA[/data/record/Date_Created-date]]></fieldDescription>
+ </field>
+ <field name="Customer" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Customer-partner_id/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Customer-partner_id/Name-name]]></fieldDescription>
+ </field>
+ <field name="SO" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Sale_Order-sale_id/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Sale_Order-sale_id/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="Tracking No" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Tracking_No-tracking_no"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Tracking_No-tracking_no]]></fieldDescription>
+ </field>
+ <field name="PO" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Picking-picking_id/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Picking-picking_id/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="Driver" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Driver-driver_id/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Driver-driver_id/Name-name]]></fieldDescription>
+ </field>
+ <field name="Shipping Method" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Shipping_Method-carrier_id/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Shipping_Method-carrier_id/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="Deparutre Date" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Departure_Date-departure_date"/>
+ <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Departure_Date-departure_date]]></fieldDescription>
+ </field>
+ <background>
+ <band splitType="Stretch"/>
+ </background>
+ <title>
+ <band height="70" splitType="Stretch"/>
+ </title>
+ <pageHeader>
+ <band height="80" splitType="Stretch">
+ <staticText>
+ <reportElement x="160" y="-68" width="240" height="30" uuid="f68656b8-e6f8-4587-ad95-af8ffecadcfe"/>
+ <textElement textAlignment="Center">
+ <font size="20" isBold="false"/>
+ </textElement>
+ <text><![CDATA[Logbook Surat Jalan]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="1" y="45" width="99" height="30" uuid="48cb313c-49b4-499c-a53b-ecbb9083b616"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <text><![CDATA[Document No:]]></text>
+ </staticText>
+ <textField>
+ <reportElement x="101" y="45" width="188" height="30" uuid="c1498c69-9b75-40aa-98f2-953a61f33d84"/>
+ <textElement textAlignment="Left" verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression>
+ </textField>
+ <staticText>
+ <reportElement x="380" y="45" width="94" height="30" uuid="3dbc2633-e5b9-407d-b8dd-61d2eec65ce3"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <text><![CDATA[Created by:]]></text>
+ </staticText>
+ <textField>
+ <reportElement x="474" y="45" width="100" height="30" uuid="2ef64d01-19a1-43fd-a673-ac6594a9aa22"/>
+ <textElement textAlignment="Left" verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Created By}]]></textFieldExpression>
+ </textField>
+ <staticText>
+ <reportElement x="380" y="10" width="94" height="30" uuid="4ed24f17-5682-4888-a4fb-a99a459c0ad1"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <text><![CDATA[Date Created :]]></text>
+ </staticText>
+ <textField>
+ <reportElement x="474" y="10" width="100" height="30" uuid="fe01b41b-0d62-4099-8a7b-0ef3112cd9a8"/>
+ <textElement verticalAlignment="Middle">
+ <font size="14"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Date Created}]]></textFieldExpression>
+ </textField>
+ </band>
+ </pageHeader>
+ <columnHeader>
+ <band height="30" splitType="Stretch">
+ <staticText>
+ <reportElement x="1" y="0" width="90" height="30" uuid="c9c16b5f-0562-494d-bab7-d0e78ab8cdb7"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[Customer]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="92" y="0" width="90" height="30" uuid="e9a6b68f-a462-4e5a-b3f5-c4f5102820fa"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[No Picking]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="182" y="0" width="90" height="30" uuid="acd8a5fc-92b6-411c-909d-13f37dfb1efe"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[No SO]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="273" y="0" width="90" height="30" uuid="cfbb56e7-92c7-4c14-acd0-b6e21aed682b"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[Driver]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="363" y="0" width="90" height="30" uuid="2e566559-f915-4dd7-b092-8a3bf382120d"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[Shipping Method]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="453" y="0" width="92" height="30" uuid="6d462229-750c-492f-a7d5-358097e8355a"/>
+ <box>
+ <pen lineWidth="1.0"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[Departure Date]]></text>
+ </staticText>
+ </band>
+ </columnHeader>
+ <detail>
+ <band height="30" splitType="Stretch">
+ <textField>
+ <reportElement x="1" y="0" width="90" height="30" uuid="b05a45f2-b836-488d-bef7-797cdce16ddf">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6dc69da-7c59-4895-9302-1da41ffe990b"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{Customer}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="91" y="0" width="91" height="30" uuid="1bab2b10-cbff-46d8-aead-2fe0604fcb5f">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="02c28e92-1108-4659-97c1-7a47f06e979e"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{PO}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="182" y="0" width="90" height="30" uuid="90affdf0-a109-4a5d-be7e-1444767d09cd">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="38404627-3374-4b80-bc1c-20fe87aab743"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{SO}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="273" y="0" width="90" height="30" uuid="71463154-d00d-413e-a1a1-e2881d6ef809">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bfd8dec3-2bc9-4b38-a643-e18724aaf3ed"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{Driver}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="363" y="0" width="90" height="30" uuid="6d4b0665-5a7c-474e-b2f8-1acde0e36a06">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b92bdba1-3992-4940-874a-4159fa47e605"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{Shipping Method}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="453" y="0" width="92" height="30" uuid="465e4dce-f36e-4d61-9f26-4b1dea2d1cda">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a1e60b9-75bb-4594-a1b1-13be9ad8219b"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{Deparutre Date}]]></textFieldExpression>
+ </textField>
+ </band>
+ </detail>
+ <columnFooter>
+ <band height="45" splitType="Stretch"/>
+ </columnFooter>
+ <pageFooter>
+ <band height="54" splitType="Stretch"/>
+ </pageFooter>
+ <summary>
+ <band height="42" splitType="Stretch"/>
+ </summary>
+</jasperReport>