Jump to content
Changes to the Jaspersoft community edition download ×

Jasper Reports giving 2 answers to the same calculation.


mike_64

Recommended Posts

I'm using JasperSoft Studio 6.3.1 final to design and compile a report, which is then executed by my Java application.

The following is a section of the .pdf file created by the report engine:

Jasper(2).png.2f7a4f5abe163ec96c9d565f9189e463.png

The subtotal is correct. The HST calculation is not. It is supposed to be 0.13 * SubTotal = $106.14. In addition, the Total, which is supposed to be SubTotal + HST, is completely off.

The left side of the page has 4 values I placed there to test the calculations. In the upper left is the value of the HST parameter supplied to the report. In the upper middle is the value 0.13 * SubTotal. In the lower left is the value HST * SubTotal. In the lower middle is the Total = SubTotal + HST.  Although it is drawing on the exact same information and using the same calculations, these values are different from those shown on the right.

What am I doing wrong?

Here is the entire jrxml file that generates this report.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  --><!-- 2017-01-20T10:17:35 --><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="ScaleSummary" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="099eaac8-9789-4d24-96ed-6a0a1a8abbbe">   <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>   <parameter name="woodlot" class="java.lang.String" isForPrompting="false"/>   <parameter name="supplier" class="java.lang.String" isForPrompting="false"/>   <parameter name="woodlotPriceList" class="java.lang.String" isForPrompting="false"/>   <parameter name="woodlotPriceRate" class="java.lang.String" isForPrompting="false"/>   <parameter name="supplierPriceList" class="java.lang.String" isForPrompting="false"/>   <parameter name="supplierPriceRate" class="java.lang.String" isForPrompting="false"/>   <parameter name="releaseDate" class="java.lang.String" isForPrompting="false"/>   <parameter name="buyer" class="java.lang.String" isForPrompting="false"/>   <parameter name="buyerBF" class="java.lang.String" isForPrompting="false"/>   <parameter name="ticket" class="java.lang.String" isForPrompting="false"/>   <parameter name="trucker" class="java.lang.String" isForPrompting="false"/>   <parameter name="truckerRate" class="java.math.BigDecimal" isForPrompting="false"/>   <parameter name="logger" class="java.lang.String" isForPrompting="false"/>   <parameter name="loggerRate" class="java.math.BigDecimal" isForPrompting="false">      <parameterDescription><![CDATA[]]></parameterDescription>   </parameter>   <parameter name="load" class="java.lang.String" isForPrompting="false"/>   <parameter name="hst" class="java.math.BigDecimal" isForPrompting="false">      <parameterDescription><![CDATA[]]></parameterDescription>   </parameter>   <parameter name="loggerRateIsFlat" class="java.lang.Boolean" isForPrompting="false"/>   <parameter name="truckerRateIsFlat" class="java.lang.Boolean" isForPrompting="false"/>   <queryString>      <![CDATA[]]>   </queryString>   <field name="species" class="java.lang.String"/>   <field name="grade" class="java.lang.String"/>   <field name="boardFeet" class="java.lang.Integer"/>   <field name="price" class="java.math.BigDecimal"/>   <field name="id" class="java.lang.Integer"/>   <field name="logType" class="java.lang.String"/>   <variable name="species1" class="java.lang.Integer" resetType="Group" resetGroup="Grade" calculation="Count">      <variableExpression><![CDATA[$F{species}]]></variableExpression>   </variable>   <variable name="boardFeet1" class="java.lang.Integer" resetType="Group" resetGroup="Grade" calculation="Sum">      <variableExpression><![CDATA[$F{boardFeet}]]></variableExpression>   </variable>   <variable name="price1" class="java.math.BigDecimal" resetType="Group" resetGroup="Grade" calculation="Sum">      <variableExpression><![CDATA[$F{price}]]></variableExpression>   </variable>   <variable name="mbf1" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{price1}.divide( new BigDecimal($V{boardFeet1}), RoundingMode.HALF_UP ).multiply(BigDecimal.valueOf(1000))]]></variableExpression>   </variable>   <variable name="species2" class="java.lang.Integer" resetType="Group" resetGroup="Species" calculation="Count">      <variableExpression><![CDATA[$F{species}]]></variableExpression>   </variable>   <variable name="boardFeet2" class="java.lang.Integer" resetType="Group" resetGroup="Species" calculation="Sum">      <variableExpression><![CDATA[$F{boardFeet}]]></variableExpression>   </variable>   <variable name="price2" class="java.math.BigDecimal" resetType="Group" resetGroup="Species" calculation="Sum">      <variableExpression><![CDATA[$F{price}]]></variableExpression>   </variable>   <variable name="mbf2" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{price2}.divide( new BigDecimal($V{boardFeet2}), RoundingMode.HALF_UP ).multiply(BigDecimal.valueOf(1000))]]></variableExpression>   </variable>   <variable name="species3" class="java.lang.Integer" resetType="Group" resetGroup="Type" calculation="Count">      <variableExpression><![CDATA[$F{species}]]></variableExpression>   </variable>   <variable name="boardFeet3" class="java.lang.Integer" resetType="Group" resetGroup="Type" calculation="Sum">      <variableExpression><![CDATA[$F{boardFeet}]]></variableExpression>   </variable>   <variable name="price3" class="java.math.BigDecimal" resetType="Group" resetGroup="Type" calculation="Sum">      <variableExpression><![CDATA[$F{price}]]></variableExpression>   </variable>   <variable name="mbf3" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{price3}.divide( new BigDecimal($V{boardFeet3}), RoundingMode.HALF_UP ).multiply(BigDecimal.valueOf(1000))]]></variableExpression>   </variable>   <variable name="species4" class="java.lang.Integer" calculation="Count">      <variableExpression><![CDATA[$F{species}]]></variableExpression>   </variable>   <variable name="boardFeet4" class="java.lang.Integer" calculation="Sum">      <variableExpression><![CDATA[$F{boardFeet}]]></variableExpression>   </variable>   <variable name="price4" class="java.math.BigDecimal" calculation="Sum">      <variableExpression><![CDATA[$F{price}]]></variableExpression>   </variable>   <variable name="mbf4" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{price4}.divide( new BigDecimal($V{boardFeet4}), RoundingMode.HALF_UP ).multiply(BigDecimal.valueOf(1000))]]></variableExpression>   </variable>   <variable name="hstAmount" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{subTotal}.multiply( $P{hst} )]]></variableExpression>   </variable>   <variable name="grandTotal" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{subTotal}.add($V{hstAmount} )]]></variableExpression>   </variable>   <variable name="loggingAmt" class="java.math.BigDecimal">      <variableExpression><![CDATA[$P{loggerRate}.multiply( new BigDecimal($V{boardFeet4}) ).negate()]]></variableExpression>   </variable>   <variable name="truckingAmt" class="java.math.BigDecimal">      <variableExpression><![CDATA[$P{truckerRate}.multiply( new BigDecimal($V{boardFeet4}) ).negate()]]></variableExpression>   </variable>   <variable name="subTotal" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{price4}.add($V{loggingAmt} ).add($V{truckingAmt})]]></variableExpression>   </variable>   <variable name="Variable_1" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{subTotal}.multiply( BigDecimal.valueOf(0.13) )]]></variableExpression>   </variable>   <variable name="Variable_2" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{subTotal}.add( $V{Variable_1} )]]></variableExpression>   </variable>   <variable name="Variable_3" class="java.math.BigDecimal">      <variableExpression><![CDATA[$V{subTotal}.multiply( $P{hst} )]]></variableExpression>   </variable>   <group name="Type">      <groupExpression><![CDATA[$F{logType}]]></groupExpression>      <groupFooter>         <band height="11">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <rectangle>               <reportElement mode="Opaque" x="0" y="0" width="572" height="11" backcolor="#B8F8FF" uuid="e42996a9-93ed-4543-ac29-41084267412c"/>               <graphicElement>                  <pen lineColor="#B8F8FF"/>               </graphicElement>            </rectangle>            <textField>               <reportElement x="0" y="0" width="60" height="11" uuid="963163c4-e597-41b8-a144-66f65d9f9a25">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>               </reportElement>               <textElement textAlignment="Center">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$F{logType}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="210" y="0" width="90" height="11" uuid="d74e0c0b-7d89-41f6-b07c-9d18e4f9824d">                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{species3}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="300" y="0" width="90" height="11" uuid="feab6805-e888-4636-9f12-c0231334dfcd">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{boardFeet3}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.00;¤-#,##0.00">               <reportElement x="480" y="0" width="90" height="11" uuid="225872cb-49f9-419a-a69e-9b91d2849a4d">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{price3}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0;¤-#,##0">               <reportElement x="390" y="0" width="90" height="11" uuid="080a089f-4b21-4846-9992-5644c7561de8">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{mbf3}]]></textFieldExpression>            </textField>         </band>      </groupFooter>   </group>   <group name="Species">      <groupExpression><![CDATA[$F{species}]]></groupExpression>      <groupFooter>         <band height="11">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <rectangle>               <reportElement x="0" y="0" width="572" height="11" backcolor="#B9B8FF" uuid="7f6b2ae7-0e91-4a61-8fc5-2c4fd0ac9d25">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <graphicElement>                  <pen lineColor="#E6E6E6"/>               </graphicElement>            </rectangle>            <textField>               <reportElement x="48" y="0" width="105" height="11" backcolor="#00496E" uuid="ccd2cbe5-8383-4997-93c9-1b5d725d8daa">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>               </reportElement>               <textElement textAlignment="Center">                  <font size="8" isBold="true" isUnderline="true"/>               </textElement>               <textFieldExpression><![CDATA[$F{species} + " Totals"]]></textFieldExpression>            </textField>            <textField>               <reportElement x="210" y="0" width="90" height="11" backcolor="#00496E" uuid="7051ec5b-0487-48cc-afce-1f78135cd128">                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{species2}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="300" y="0" width="90" height="11" backcolor="#00496E" uuid="fd341aba-083a-4a77-a534-0af30845612c">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{boardFeet2}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.00;¤-#,##0.00">               <reportElement x="480" y="0" width="90" height="11" backcolor="#00496E" uuid="3e338475-b381-4c78-806a-9cfe2d88cea7">                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{price2}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0;¤-#,##0">               <reportElement x="390" y="0" width="90" height="11" backcolor="#00496E" uuid="41425e0a-bac9-41b9-af54-8f4595c95633">                  <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{mbf2}]]></textFieldExpression>            </textField>         </band>      </groupFooter>   </group>   <group name="Grade">      <groupExpression><![CDATA[$F{grade}]]></groupExpression>      <groupFooter>         <band height="11">            <textField isBlankWhenNull="true">               <reportElement x="140" y="0" width="70" height="11" uuid="42eb2f87-ca8a-4d3b-ac93-a9ea4b5dcbfa">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Center">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$F{grade}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="210" y="0" width="90" height="11" uuid="3eec60c1-7a66-483f-8437-97adc6bb0f6e">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{species1}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="300" y="0" width="90" height="11" uuid="79fc8766-d644-400d-b069-97444a387cda">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{boardFeet1}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.00;¤-#,##0.00">               <reportElement x="480" y="0" width="90" height="11" uuid="f28f719b-7783-4ace-9d77-d4a87e149251">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{price1}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0;¤-#,##0">               <reportElement x="390" y="0" width="90" height="11" uuid="0c284109-78f7-4ad6-8c56-244fe52a024a">                  <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               </reportElement>               <textElement textAlignment="Right">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$V{mbf1}]]></textFieldExpression>            </textField>            <textField>               <reportElement x="60" y="0" width="80" height="11" printWhenGroupChanges="Species" uuid="caaf5a52-dce8-4e3e-bf8a-cf48272e1e49"/>               <textElement textAlignment="Center">                  <font size="8"/>               </textElement>               <textFieldExpression><![CDATA[$F{species}]]></textFieldExpression>            </textField>         </band>      </groupFooter>   </group>   <background>      <band splitType="Stretch"/>   </background>   <title>      <band height="192" splitType="Stretch">         <image hAlign="Center">            <reportElement x="0" y="-2" width="580" height="50" uuid="93bfff74-d6ee-4b94-a5b8-4db39f4515d5"/>            <imageExpression><![CDATA["images/bauman.png"]]></imageExpression>         </image>         <staticText>            <reportElement x="0" y="50" width="190" height="20" uuid="614fca9d-ef2c-4930-aa6b-0b4be9e88bea"/>            <textElement>               <font size="14" isBold="true"/>            </textElement>            <text><![CDATA[Log Scale Summary Report]]></text>         </staticText>         <staticText>            <reportElement x="0" y="95" width="80" height="15" backcolor="#CCFFFF" uuid="4d48a1a8-8bea-4011-87c7-b9750f2df61c"/>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right"/>            <text><![CDATA[Woodlot #: ]]></text>         </staticText>         <staticText>            <reportElement x="0" y="110" width="80" height="15" backcolor="#CCFFFF" uuid="a7ac76b0-a335-44ee-ad27-f0e7b8c9f46e"/>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right"/>            <text><![CDATA[Price List #: ]]></text>         </staticText>         <textField isBlankWhenNull="true">            <reportElement x="80" y="95" width="150" height="15" uuid="59563043-5345-4cbe-b313-42a1118973e1">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box padding="0">               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textFieldExpression><![CDATA[$P{woodlot}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="80" y="110" width="50" height="15" uuid="31e7ab7a-dad0-4fd1-ac06-fc8cb667f3b9"/>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textFieldExpression><![CDATA[$P{woodlotPriceList}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="310" y="95" width="80" height="15" backcolor="#CCFFFF" uuid="9a73d6f0-5731-4e33-a8e7-d061ded47f27"/>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right"/>            <text><![CDATA[supplier: ]]></text>         </staticText>         <staticText>            <reportElement x="310" y="110" width="80" height="15" backcolor="#CCFFFF" uuid="4dd7ba4b-f690-49c2-b425-f1173e33bfc5">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right"/>            <text><![CDATA[Price List #: ]]></text>         </staticText>         <textField isBlankWhenNull="true">            <reportElement x="390" y="95" width="150" height="15" uuid="15d3727d-658a-431c-a86a-401f1e5a60e1">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textFieldExpression><![CDATA[$P{supplier}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="390" y="110" width="50" height="15" uuid="5f65bc7e-2cd4-40d4-a3a9-9fe1947567da">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textFieldExpression><![CDATA[$P{supplierPriceList}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="0" y="130" width="120" height="15" backcolor="#CCFFFF" uuid="94c4d2d5-7f0d-4926-8571-c414bf7eda10">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[buyer]]></text>         </staticText>         <staticText>            <reportElement x="120" y="130" width="120" height="15" backcolor="#CCFFFF" uuid="3ee6fc0d-6765-45cd-b522-34ec146259f8">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[Ticket #]]></text>         </staticText>         <staticText>            <reportElement x="310" y="130" width="120" height="15" backcolor="#CCFFFF" uuid="f822331e-394e-4f11-8b58-039ff7f7d2bb"/>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[Trucker]]></text>         </staticText>         <staticText>            <reportElement x="430" y="130" width="120" height="15" backcolor="#CCFFFF" uuid="9d26ce4a-e367-4c32-a568-7b75e1c0e043">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[Logger]]></text>         </staticText>         <textField isBlankWhenNull="true">            <reportElement x="0" y="145" width="120" height="15" uuid="7d7887c5-a4b5-4602-925e-71f0a51f7bf1"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[$P{buyer}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="310" y="145" width="120" height="15" uuid="f1988efb-f87c-46d8-8b05-809d19623043"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[$P{trucker}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="430" y="145" width="120" height="15" uuid="fce5440f-7d02-4ece-8b21-dfa190a514f8"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[$P{logger}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="120" y="145" width="120" height="15" uuid="91851c24-e680-46b6-b5dd-9b0afe4ae809"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[$P{ticket}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="0" y="160" width="120" height="15" backcolor="#CCFFFF" uuid="8f36ad8e-fda3-46e6-b9d4-49b499c5ba9a"/>            <box>               <pen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[buyer BF]]></text>         </staticText>         <staticText>            <reportElement x="310" y="160" width="120" height="15" backcolor="#CCFFFF" uuid="cb14f26d-da97-4b4a-b560-b3c976d19a1d"/>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[Rate]]></text>         </staticText>         <staticText>            <reportElement x="430" y="160" width="120" height="15" backcolor="#CCFFFF" uuid="95d465ce-2015-4f96-9e89-ee2025b046f4"/>            <box>               <topPen lineWidth="0.2"/>               <leftPen lineWidth="0.2"/>               <bottomPen lineWidth="0.2"/>               <rightPen lineWidth="0.2"/>            </box>            <textElement textAlignment="Center"/>            <text><![CDATA[Rate]]></text>         </staticText>         <textField isBlankWhenNull="true">            <reportElement x="0" y="175" width="120" height="15" uuid="cdda5956-bce8-491e-ae43-31019e41e305"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[$P{buyerBF}]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="310" y="175" width="120" height="15" uuid="cd175b34-450f-4118-bcba-bbe7165da375">               <property name="com.jaspersoft.studio.unit.width" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[string.format("$%.3f", $P{truckerRate}) + ($P{truckerRateIsFlat} ? "" : "/bf")]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="430" y="175" width="120" height="15" uuid="b6b425cf-a43d-4819-b2d6-2894a1506a06"/>            <box>               <topPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.2" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Center"/>            <textFieldExpression><![CDATA[string.format("$%.3f", $P{loggerRate}) + ($P{loggerRateIsFlat} ? "" : "/bf")]]></textFieldExpression>         </textField>         <textField isBlankWhenNull="true">            <reportElement x="491" y="70" width="79" height="15" uuid="2f423025-4158-42ad-b5bc-29aec3d63ee2"/>            <textFieldExpression><![CDATA[$P{releaseDate}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="0" y="70" width="35" height="25" uuid="8c5983a6-d9a1-4b14-acef-3350a09d5a6a"/>            <textElement>               <font size="12" isBold="false"/>            </textElement>            <text><![CDATA[Load:]]></text>         </staticText>         <textField isBlankWhenNull="true">            <reportElement x="35" y="70" width="100" height="25" uuid="79293e60-f907-44a3-9511-98215f367a11"/>            <textElement>               <font size="12"/>            </textElement>            <textFieldExpression><![CDATA[$P{load}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="400" y="70" width="91" height="15" uuid="2dbec0c0-05cc-46f5-bf36-d92609e5c152"/>            <text><![CDATA[Load Release Date:]]></text>         </staticText>      </band>   </title>   <columnHeader>      <band height="18" splitType="Stretch">         <staticText>            <reportElement x="60" y="0" width="80" height="15" uuid="17d998ad-0ea9-4b21-97d6-4c56dae261c5"/>            <textElement textAlignment="Center"/>            <text><![CDATA[species]]></text>         </staticText>         <staticText>            <reportElement x="140" y="0" width="70" height="15" uuid="0b2514cb-5755-4ee5-87f5-402834fda2f0"/>            <textElement textAlignment="Center"/>            <text><![CDATA[Grade]]></text>         </staticText>         <staticText>            <reportElement x="210" y="0" width="90" height="15" uuid="3d77ab58-500f-4a2b-a43b-0e15c141966d"/>            <textElement textAlignment="Right"/>            <text><![CDATA[Log Count]]></text>         </staticText>         <staticText>            <reportElement x="300" y="0" width="90" height="15" uuid="6b68f141-a413-4d79-a6fd-f19aecbf84d5"/>            <textElement textAlignment="Right"/>            <text><![CDATA[board Feet]]></text>         </staticText>         <staticText>            <reportElement x="390" y="0" width="90" height="15" uuid="c1b98920-3ab4-441e-9d24-7797d580004e"/>            <textElement textAlignment="Right"/>            <text><![CDATA[Price (/mbf)]]></text>         </staticText>         <staticText>            <reportElement x="480" y="0" width="88" height="15" uuid="1fd994f4-0857-4e90-a6dc-ab08e3e88c87">               <property name="com.jaspersoft.studio.unit.x" value="pixel"/>            </reportElement>            <textElement textAlignment="Right"/>            <text><![CDATA[Line Total]]></text>         </staticText>         <line>            <reportElement x="0" y="15" width="570" height="1" isRemoveLineWhenBlank="true" uuid="a18f566c-5972-43f5-8754-00a46cdf262f"/>            <graphicElement>               <pen lineWidth="2.0"/>            </graphicElement>         </line>         <staticText>            <reportElement x="0" y="0" width="60" height="15" uuid="9c4c70bc-049d-4a4f-b820-507aaa906e5c">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Center"/>            <text><![CDATA[Type]]></text>         </staticText>      </band>   </columnHeader>   <pageFooter>      <band height="1" splitType="Stretch">         <property name="com.jaspersoft.studio.unit.height" value="pixel"/>      </band>   </pageFooter>   <summary>      <band height="85" splitType="Stretch">         <staticText>            <reportElement x="380" y="36" width="100" height="11" uuid="31141427-83b2-49f4-8edc-d238fdcfb701">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right">               <font size="8" isBold="true"/>            </textElement>            <text><![CDATA[sub Total: ]]></text>         </staticText>         <staticText>            <reportElement x="380" y="46" width="100" height="11" uuid="7de0205f-c41b-4ac9-898b-863df2d1df9c">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8" isBold="true"/>            </textElement>            <text><![CDATA[HST: ]]></text>         </staticText>         <staticText>            <reportElement x="380" y="64" width="100" height="11" uuid="5177d0a6-8777-4867-86ea-47543f7709ca">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right">               <font size="8" isBold="true"/>            </textElement>            <text><![CDATA[Total: ]]></text>         </staticText>         <line>            <reportElement x="0" y="0" width="570" height="1" isRemoveLineWhenBlank="true" uuid="1f4bc1f7-66fc-456b-bb79-758a429af033"/>            <graphicElement>               <pen lineWidth="1.0"/>            </graphicElement>         </line>         <textField>            <reportElement x="210" y="2" width="90" height="11" uuid="087214ac-c394-4730-af49-be4d55d708da">               <property name="com.jaspersoft.studio.unit.y" value="pixel"/>               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{species4}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="300" y="2" width="90" height="11" uuid="27f1834c-58fc-41f3-a8dd-efc66b242b0b">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{boardFeet4}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0.00;¤-#,##0.00">            <reportElement x="480" y="2" width="90" height="11" uuid="02bbc4d6-ddf9-4faa-b1d6-0d499d57b0ac">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{price4}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0;¤-#,##0">            <reportElement x="390" y="2" width="90" height="11" uuid="532389a4-e342-47b4-9894-f1268d485058">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{mbf4}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0.00;¤-#,##0.00">            <reportElement x="480" y="46" width="90" height="11" uuid="fac237cf-cd2d-443b-893c-f820856f971d">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{hstAmount}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0.00;¤-#,##0.00">            <reportElement x="480" y="64" width="90" height="11" uuid="60cc1cec-1231-4fa2-9cac-5f10a2c980f9">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{grandTotal}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0.00;¤(#,##0.00) ">            <reportElement x="480" y="13" width="90" height="11" uuid="5eb7484e-df5b-45e0-b36f-dd7d2cbc9b93">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               <printWhenExpression><![CDATA[$P{woodlot}.equals( "" )]]></printWhenExpression>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{loggingAmt}]]></textFieldExpression>         </textField>         <textField pattern="¤#,##0.00;¤(#,##0.00) ">            <reportElement x="480" y="25" width="90" height="11" uuid="c9e79cfe-282d-497f-a2f1-a6873a50c2bf">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               <printWhenExpression><![CDATA[$P{woodlot}.equals( "" )]]></printWhenExpression>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{truckingAmt}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="380" y="13" width="100" height="11" uuid="97532794-d865-4121-8608-ad03acb0e63a">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               <printWhenExpression><![CDATA[$P{woodlot}.equals( "" )]]></printWhenExpression>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <text><![CDATA[Less Logging: ]]></text>         </staticText>         <staticText>            <reportElement x="380" y="24" width="100" height="11" uuid="d46634d8-3298-4b00-95f4-68d19db1eaee">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>               <printWhenExpression><![CDATA[$P{woodlot}.equals( "" )]]></printWhenExpression>            </reportElement>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <text><![CDATA[Less Trucking: ]]></text>         </staticText>         <textField pattern="¤#,##0.00;¤-#,##0.00">            <reportElement x="480" y="36" width="90" height="11" uuid="5632e087-f65e-40f5-8227-a297a264a550">               <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            </reportElement>            <box>               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>            </box>            <textElement textAlignment="Right">               <font size="8"/>            </textElement>            <textFieldExpression><![CDATA[$V{subTotal}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="258" y="25" width="100" height="30" uuid="75088f21-edc3-4745-ad79-79a33e33e47f"/>            <textFieldExpression><![CDATA[$V{Variable_1}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="259" y="55" width="100" height="30" uuid="b08fb057-aa2a-47a4-b8db-0646b56ab574"/>            <textFieldExpression><![CDATA[$V{Variable_2}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="135" y="20" width="100" height="30" uuid="afedc0db-c07f-49ec-98db-a29584a46b2d"/>            <textFieldExpression><![CDATA[$P{hst}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="136" y="50" width="100" height="30" uuid="4aaa7f32-75de-41ae-88eb-b8d6d3e28428"/>            <textFieldExpression><![CDATA[$V{Variable_3}]]></textFieldExpression>         </textField>      </band>   </summary></jasperReport>[/code]

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...