summaryrefslogtreecommitdiff
path: root/jasper_reports/custom_reports/BillOfMaterial.jrxml
diff options
context:
space:
mode:
Diffstat (limited to 'jasper_reports/custom_reports/BillOfMaterial.jrxml')
-rw-r--r--jasper_reports/custom_reports/BillOfMaterial.jrxml225
1 files changed, 225 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/BillOfMaterial.jrxml b/jasper_reports/custom_reports/BillOfMaterial.jrxml
new file mode 100644
index 0000000..6503794
--- /dev/null
+++ b/jasper_reports/custom_reports/BillOfMaterial.jrxml
@@ -0,0 +1,225 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad -->
+<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="BillOfMaterial" pageWidth="595" pageHeight="420" orientation="Landscape" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f4cf45d7-678c-424f-b460-ba24065ffb97">
+ <property name="ODOO_RELATIONS">
+ <![CDATA[['bom_line_ids']]]>
+ </property>
+ <property name="com.jaspersoft.studio.unit." value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
+ <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
+ <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Bill of Material"/>
+ <queryString language="XPath">
+ <![CDATA[/data/record]]>
+ </queryString>
+ <field name="Display_Name-display_name" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="Display_Name-display_name"/>
+ <fieldDescription><![CDATA[Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="ProductName" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="BoM_Lines-bom_line_ids/Product_Template-product_tmpl_id/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[BoM_Lines-bom_line_ids/Product_Template-product_tmpl_id/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="Qty" class="java.math.BigDecimal">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="BoM_Lines-bom_line_ids/Quantity-product_qty"/>
+ <fieldDescription><![CDATA[BoM_Lines-bom_line_ids/Quantity-product_qty]]></fieldDescription>
+ </field>
+ <field name="UOM" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="BoM_Lines-bom_line_ids/Product_Unit_of_Measure-product_uom_id/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[BoM_Lines-bom_line_ids/Product_Unit_of_Measure-product_uom_id/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <field name="BoM_Line_DisplayName" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="BoM_Lines-bom_line_ids/Display_Name-display_name"/>
+ <fieldDescription><![CDATA[BoM_Lines-bom_line_ids/Display_Name-display_name]]></fieldDescription>
+ </field>
+ <background>
+ <band splitType="Stretch"/>
+ </background>
+ <title>
+ <band height="20" splitType="Stretch">
+ <staticText>
+ <reportElement x="0" y="0" width="550" height="20" uuid="6f7dfec7-f78a-4e2a-a872-75482b2386a0"/>
+ <textElement textAlignment="Center">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[Bill of Material]]></text>
+ </staticText>
+ </band>
+ </title>
+ <pageHeader>
+ <band height="20" splitType="Stretch">
+ <textField>
+ <reportElement x="0" y="0" width="550" height="20" uuid="c0652b70-223a-4c66-8d98-f0ef818415ab">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <textElement>
+ <font isBold="true"/>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression>
+ </textField>
+ </band>
+ </pageHeader>
+ <columnHeader>
+ <band height="20" splitType="Stretch">
+ <staticText>
+ <reportElement x="30" y="0" width="420" height="20" uuid="babd7506-9420-439c-a619-acbd7dad08fd">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement>
+ <font isBold="true"/>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <text><![CDATA[Product]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="450" y="0" width="40" height="20" uuid="5fd83779-06a2-45a6-8d02-2f354aa76299">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font isBold="true"/>
+ <paragraph leftIndent="3" rightIndent="3"/>
+ </textElement>
+ <text><![CDATA[Qty]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="490" y="0" width="60" height="20" uuid="ddc28fac-3dca-48b0-9f77-a6614feade09">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fc4a8a86-c651-4a3c-bf9b-cdf8b6cedeed"/>
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Left">
+ <font isBold="true"/>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <text><![CDATA[UOM]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="0" y="0" width="30" height="20" uuid="798853b2-b22b-4df9-b1b7-c3e31502ff90">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement>
+ <font isBold="true"/>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <text><![CDATA[No]]></text>
+ </staticText>
+ </band>
+ </columnHeader>
+ <detail>
+ <band height="20" splitType="Stretch">
+ <textField>
+ <reportElement x="30" y="0" width="420" height="20" uuid="95d65c81-dac6-43cd-91b0-ba0d0b07478e">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="079e6dbd-063f-42f7-a172-f622b73475ec"/>
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{BoM_Line_DisplayName}]]></textFieldExpression>
+ </textField>
+ <textField pattern="#,###.###;(#,###.###-)">
+ <reportElement x="450" y="0" width="40" height="20" uuid="2a02b4f6-6b22-4988-b929-6ed0be92d89b">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c995929b-dc32-47e9-a529-a897d372596d"/>
+ <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right">
+ <paragraph leftIndent="3" rightIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Qty}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="490" y="0" width="60" height="20" uuid="d90a7ada-2038-4349-b2d4-081da48aef56">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fc4a8a86-c651-4a3c-bf9b-cdf8b6cedeed"/>
+ </reportElement>
+ <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Left">
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{UOM}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="0" y="0" width="30" height="20" uuid="ec4e0ccc-888d-46ab-bb70-930436ec0d80">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement>
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
+ </textField>
+ </band>
+ </detail>
+ <pageFooter>
+ <band height="16" splitType="Stretch">
+ <textField>
+ <reportElement x="490" y="0" width="30" height="16" uuid="d6816cee-7f58-474a-85ae-0bb8326787f3">
+ <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
+ </reportElement>
+ <textElement textAlignment="Right">
+ <paragraph leftIndent="3"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+ </textField>
+ <staticText>
+ <reportElement x="520" y="0" width="6" height="16" uuid="14ceef5c-8f06-4d4c-ba24-9e660547f74c"/>
+ <text><![CDATA[/]]></text>
+ </staticText>
+ <textField evaluationTime="Report">
+ <reportElement x="526" y="0" width="24" height="16" uuid="34ebda5a-e4aa-437f-b208-f9521d7ffd5a"/>
+ <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+ </textField>
+ </band>
+ </pageFooter>
+</jasperReport>
generated by cgit v1.2.3 (git 2.25.1) at 2026-04-17 17:50:00 +0000