mike_64 Posted January 20, 2017 Share Posted January 20, 2017 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: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 More sharing options...
reportdev Posted January 20, 2017 Share Posted January 20, 2017 I think you are losing some precision while converting integers to bigdecimals and also while rounding. Link to comment Share on other sites More sharing options...
bob.baldwin Posted January 20, 2017 Share Posted January 20, 2017 Are all of your fields within the same report band? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now