Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ReeferOnVessel" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
- <property name="ireport.scriptlethandling" value="2"/>
- <property name="ireport.encoding" value="UTF-8"/>
- <property name="ireport.zoom" value="1.0"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <import value="net.sf.jasperreports.engine.*"/>
- <import value="java.util.*"/>
- <import value="net.sf.jasperreports.engine.data.*"/>
- <style name="Crosstab Data Text" hAlign="Center"/>
- <parameter name="JV.JPG" class="java.awt.Image"/>
- <parameter name="InboundCarrierName" class="java.lang.String"/>
- <field name="UnitNbr" class="java.lang.String"/>
- <field name="Category" class="java.lang.String"/>
- <field name="LineOperator" class="java.lang.String"/>
- <field name="EquipmentTareWeightKg" class="java.lang.Double"/>
- <field name="EquipmentTypeBasicLength" class="java.lang.String"/>
- <field name="GrossWeightKgValue" class="java.lang.Double"/>
- <field name="CargoWeight" class="java.lang.Double"/>
- <field name="UfvFlexString03" class="java.lang.String"/>
- <field name="UfvFlexString04" class="java.lang.String"/>
- <variable name="CountUnit" class="java.lang.String">
- <variableExpression><![CDATA["Units"]]></variableExpression>
- </variable>
- <variable name="CargoWt" class="java.lang.Float">
- <variableExpression><![CDATA[Float.parseFloat($F{UfvFlexString03})+Float.parseFloat($F{UfvFlexString04})]]></variableExpression>
- </variable>
- <variable name="Tare" class="java.lang.Float">
- <variableExpression><![CDATA[new Float($F{EquipmentTareWeightKg})]]></variableExpression>
- </variable>
- <variable name="gross" class="java.lang.Float">
- <variableExpression><![CDATA[new Float($F{EquipmentTareWeightKg})+( Float.parseFloat($F{UfvFlexString03})+Float.parseFloat($F{UfvFlexString04}))]]></variableExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band height="165" splitType="Stretch">
- <staticText>
- <reportElement mode="Transparent" x="302" y="28" width="198" height="40"/>
- <textElement>
- <font size="26" isUnderline="true"/>
- </textElement>
- <text><![CDATA[Move Per Vessel]]></text>
- </staticText>
- <staticText>
- <reportElement mode="Transparent" x="643" y="45" width="29" height="20"/>
- <textElement/>
- <text><![CDATA[Date:]]></text>
- </staticText>
- <textField pattern="dd/MM/yyyy">
- <reportElement mode="Transparent" x="672" y="45" width="100" height="20"/>
- <textElement/>
- <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
- </textField>
- <image>
- <reportElement mode="Transparent" x="10" y="12" width="226" height="53"/>
- <imageExpression class="java.awt.Image"><![CDATA[$P{JV.JPG}]]></imageExpression>
- </image>
- <staticText>
- <reportElement mode="Transparent" x="10" y="86" width="69" height="20"/>
- <textElement/>
- <text><![CDATA[Carrier Name:]]></text>
- </staticText>
- <textField>
- <reportElement mode="Transparent" x="79" y="86" width="100" height="20"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$P{InboundCarrierName}]]></textFieldExpression>
- </textField>
- </band>
- </title>
- <columnHeader>
- <band splitType="Stretch"/>
- </columnHeader>
- <detail>
- <band splitType="Stretch"/>
- </detail>
- <summary>
- <band height="161" splitType="Stretch">
- <crosstab>
- <reportElement mode="Transparent" x="0" y="0" width="518" height="161"/>
- <rowGroup name="LineOperator" width="65" totalPosition="End">
- <bucket>
- <bucketExpression><![CDATA[$F{LineOperator}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="65" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{LineOperator}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents backcolor="#005FB3" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <staticText>
- <reportElement mode="Transparent" x="0" y="0" width="65" height="25" forecolor="#FFFFFF"/>
- <textElement textAlignment="Center" verticalAlignment="Middle"/>
- <text><![CDATA[Total LineOperator]]></text>
- </staticText>
- </cellContents>
- </crosstabTotalRowHeader>
- </rowGroup>
- <rowGroup name="Category" width="70" totalPosition="End">
- <bucket>
- <bucketExpression><![CDATA[$F{Category}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="70" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{Category}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <staticText>
- <reportElement mode="Transparent" x="0" y="0" width="70" height="24"/>
- <textElement textAlignment="Center" verticalAlignment="Middle"/>
- <text><![CDATA[Total Category]]></text>
- </staticText>
- </cellContents>
- </crosstabTotalRowHeader>
- </rowGroup>
- <rowGroup name="Length" width="83">
- <bucket>
- <bucketExpression><![CDATA[$F{EquipmentTypeBasicLength}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="83" height="25"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{Length}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents/>
- </crosstabTotalRowHeader>
- </rowGroup>
- <columnGroup name="CountUnit" height="30">
- <bucket>
- <bucketExpression><![CDATA[$V{CountUnit}]]></bucketExpression>
- </bucket>
- <crosstabColumnHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="69" height="30"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{CountUnit}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="69" y="0" width="109" height="30"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <text><![CDATA[Sum of Tare (Kg)]]></text>
- </staticText>
- <staticText>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="178" y="0" width="120" height="30"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <text><![CDATA[Sum of CargoWt (Kg)]]></text>
- </staticText>
- </cellContents>
- </crosstabColumnHeader>
- <crosstabTotalColumnHeader>
- <cellContents/>
- </crosstabTotalColumnHeader>
- </columnGroup>
- <measure name="UnitNbrMeasure" class="java.lang.Integer" calculation="Count">
- <measureExpression><![CDATA[$F{UnitNbr}]]></measureExpression>
- </measure>
- <measure name="SumOfTare" class="java.lang.Float" calculation="Sum">
- <measureExpression><![CDATA[$V{Tare}]]></measureExpression>
- </measure>
- <measure name="SumOfCargoWt" class="java.lang.Float" calculation="Sum">
- <measureExpression><![CDATA[$V{CargoWt}]]></measureExpression>
- </measure>
- <crosstabCell width="299" height="25">
- <cellContents>
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="69" height="25"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="69" y="0" width="109" height="25"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfTare}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="178" y="0" width="120" height="25"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfCargoWt}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="299" height="25" rowTotalGroup="LineOperator">
- <cellContents backcolor="#005FB3" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="69" height="24" forecolor="#FFFFFF"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="69" y="0" width="109" height="24" forecolor="#FFFFFF"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfTare}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="178" y="0" width="120" height="24" forecolor="#FFFFFF"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfCargoWt}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="50" columnTotalGroup="CountUnit">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="LineOperator" columnTotalGroup="CountUnit">
- <cellContents backcolor="#005FB3" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25" forecolor="#FFFFFF"/>
- <textElement/>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="299" height="24" rowTotalGroup="Category">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="69" height="24"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="69" y="0" width="109" height="24"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfTare}]]></textFieldExpression>
- </textField>
- <textField pattern="###0.00;(###0.00)">
- <reportElement style="Crosstab Data Text" mode="Transparent" x="178" y="0" width="120" height="24"/>
- <box>
- <pen lineWidth="0.5"/>
- <topPen lineWidth="0.5"/>
- <leftPen lineWidth="0.5"/>
- <bottomPen lineWidth="0.5"/>
- <rightPen lineWidth="0.5"/>
- </box>
- <textElement>
- <font size="10"/>
- </textElement>
- <textFieldExpression class="java.lang.Double"><![CDATA[$V{SumOfCargoWt}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Category" columnTotalGroup="CountUnit">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <box>
- <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Integer"><![CDATA[$V{UnitNbrMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Length">
- <cellContents/>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Length" columnTotalGroup="CountUnit">
- <cellContents/>
- </crosstabCell>
- </crosstab>
- <crosstab>
- <reportElement mode="Transparent" x="518" y="0" width="177" height="161"/>
- <rowGroup name="UnitNbr" width="70" totalPosition="End">
- <bucket>
- <bucketExpression class="java.lang.String"><![CDATA[$F{UnitNbr}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque"/>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents backcolor="#005FB3" mode="Opaque"/>
- </crosstabTotalRowHeader>
- </rowGroup>
- <rowGroup name="Category" width="0" totalPosition="End">
- <bucket>
- <bucketExpression class="java.lang.String"><![CDATA[$F{Category}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque"/>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents backcolor="#BFE1FF" mode="Opaque"/>
- </crosstabTotalRowHeader>
- </rowGroup>
- <rowGroup name="Length" width="0">
- <bucket>
- <bucketExpression class="java.lang.Object"><![CDATA[$F{EquipmentTypeBasicLength}]]></bucketExpression>
- </bucket>
- <crosstabRowHeader>
- <cellContents/>
- </crosstabRowHeader>
- <crosstabTotalRowHeader>
- <cellContents/>
- </crosstabTotalRowHeader>
- </rowGroup>
- <columnGroup name="gross" height="30">
- <bucket>
- <bucketExpression class="java.lang.Float"><![CDATA[$V{gross}]]></bucketExpression>
- </bucket>
- <crosstabColumnHeader>
- <cellContents backcolor="#F0F8FF" mode="Opaque">
- <staticText>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="106" height="30"/>
- <textElement/>
- <text><![CDATA[Sum of Gross (Kg)]]></text>
- </staticText>
- </cellContents>
- </crosstabColumnHeader>
- <crosstabTotalColumnHeader>
- <cellContents/>
- </crosstabTotalColumnHeader>
- </columnGroup>
- <measure name="grossMeasure" class="java.lang.Float" calculation="Sum">
- <measureExpression><![CDATA[$V{gross}]]></measureExpression>
- </measure>
- <crosstabCell width="106" height="25">
- <cellContents>
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="106" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="106" height="25" rowTotalGroup="UnitNbr">
- <cellContents backcolor="#005FB3" mode="Opaque">
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="106" height="25" forecolor="#FFFFFF"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="50" columnTotalGroup="gross">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="UnitNbr" columnTotalGroup="gross">
- <cellContents backcolor="#005FB3" mode="Opaque">
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25" forecolor="#FFFFFF"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell width="106" height="25" rowTotalGroup="Category">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="106" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Category" columnTotalGroup="gross">
- <cellContents backcolor="#BFE1FF" mode="Opaque">
- <textField>
- <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="50" height="25"/>
- <textElement/>
- <textFieldExpression class="java.lang.Float"><![CDATA[$V{grossMeasure}]]></textFieldExpression>
- </textField>
- </cellContents>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Length">
- <cellContents/>
- </crosstabCell>
- <crosstabCell rowTotalGroup="Length" columnTotalGroup="gross">
- <cellContents/>
- </crosstabCell>
- </crosstab>
- </band>
- </summary>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement