<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --> <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="inventory" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f2b84649-4c05-45e1-97d0-9f31966f494f"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="647"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="353"/> <parameter name="date" class="java.sql.Date"/> <queryString language="SQL"> <![CDATA[SELECT locationCode AS locationCode, containerCode AS containerCode, materialCode AS materialCode, name AS name, spec AS spec, inventorySts AS inventorySts, qty AS qty FROM inventory_detail i INNER JOIN material m ON 'NULL' = 'NULL' ORDER BY locationCode ASC]]> </queryString> <field name="locationCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="locationCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="containerCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="containerCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="materialCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="materialCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="name"/> <property name="com.jaspersoft.studio.field.tree.path" value="material"/> </field> <field name="spec" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="spec"/> <property name="com.jaspersoft.studio.field.tree.path" value="material"/> </field> <field name="inventorySts" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="inventorySts"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="57" splitType="Stretch"> <staticText> <reportElement x="190" y="20" width="140" height="30" uuid="a5dadfff-1941-4d79-94ab-d850eed5ae79"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="16"/> </textElement> <text><![CDATA[长沙华恒库存报表]]></text> </staticText> </band> </title> <pageHeader> <band height="35" splitType="Stretch"> <staticText> <reportElement x="-20" y="0" width="100" height="30" uuid="cb8872ee-e1ac-4b42-a863-e8ac49daa4c4"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <text><![CDATA[时间:]]></text> </staticText> <staticText> <reportElement x="370" y="0" width="100" height="30" uuid="559c32ed-18e1-4bd0-8eb1-98eb70990295"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <text><![CDATA[部门:]]></text> </staticText> <staticText> <reportElement x="470" y="0" width="100" height="30" uuid="49283584-65ca-4219-8c4d-3f8dbd641e56"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[仓库]]></text> </staticText> <textField pattern="MMMMM dd, yyyy"> <reportElement x="80" y="0" width="100" height="30" uuid="b6c60f61-7328-4d66-89df-8136959bb837"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="32" splitType="Stretch"> <staticText> <reportElement x="-20" y="0" width="80" height="30" uuid="b202c2a1-46b8-4727-91ce-4e1280566016"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[库位]]></text> </staticText> <staticText> <reportElement x="60" y="0" width="70" height="30" uuid="c03890b2-30ed-4b16-b884-acbfe95cd982"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[容器]]></text> </staticText> <staticText> <reportElement x="130" y="0" width="80" height="30" uuid="ece5cb44-94b6-4203-82b7-094214770cad"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[物料编码]]></text> </staticText> <staticText> <reportElement x="210" y="0" width="90" height="30" uuid="31baaf40-5e47-4b4a-a8ba-d3efb10137e7"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[物料名称]]></text> </staticText> <staticText> <reportElement x="300" y="0" width="100" height="30" uuid="46dfbcb4-5464-4df0-afae-8f24f91e9082"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[物料规格]]></text> </staticText> <staticText> <reportElement x="400" y="0" width="90" height="30" uuid="637a4fa3-87f2-48c7-8077-ab1a0182bbac"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[库存]]></text> </staticText> <staticText> <reportElement x="490" y="0" width="85" height="30" uuid="6c92e083-a134-423e-814f-870b0e522e9c"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[库存状态]]></text> </staticText> </band> </columnHeader> <detail> <band height="34" splitType="Stretch"> <textField> <reportElement x="-20" y="0" width="80" height="30" uuid="44ac5289-dc22-45f4-ac12-d59f564b3dea"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{locationCode}]]></textFieldExpression> </textField> <textField> <reportElement x="60" y="0" width="70" height="30" uuid="0c322385-42cc-4908-a1f5-f92c707cfe23"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{containerCode}]]></textFieldExpression> </textField> <textField> <reportElement x="130" y="0" width="80" height="30" uuid="f6576e46-cbaa-4f97-a303-9adb35d66dbd"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{materialCode}]]></textFieldExpression> </textField> <textField> <reportElement x="210" y="0" width="90" height="30" uuid="21d367fe-919a-4669-82e4-f13fdc9d4223"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField> <reportElement x="300" y="0" width="100" height="30" uuid="3927d013-40f7-4bb5-9de9-cc9587214dd5"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{spec}]]></textFieldExpression> </textField> <textField> <reportElement x="400" y="0" width="90" height="30" uuid="8ad633b4-63e6-46b9-b09f-8a2658f0248d"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression> </textField> <textField> <reportElement x="490" y="0" width="85" height="30" uuid="e33bc011-8c17-4ee9-8eb0-f18da95f51c8"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{inventorySts}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="36" splitType="Stretch"> <textField> <reportElement x="475" y="0" width="100" height="30" uuid="142d35d8-e054-4bdb-a690-4e044d037273"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>