mike_64

@ReportDev: I understand that is the case, yes. However, I don't know what these values should be set to, and my attempts to find the correct values by trial and error have failed. Both the subreports and the calculation are embedded in the Summary band. I use increment type None for all variables in the subtotal calculation, since none of them use a calculation function (sum, avg, count, etc.) I also used reset type Report for all variables, including subTotal, since these values should all be calculated at the end of the report fill phase. In addition, I've used values Report, Master and Auto for the text box evaluation time. Since I still see null, I'm at a loss as to what values I should be using here. Suggestions?

I'm using JS Studio 6.4.0 and Jasper Reports library 6.4.1 in a Java application. I have a master report with 2 subreports embedded in the summary. The master calculates 2 values (loggingTotal, truckingTotal). The subreports return one value each (expenseTotal, logTotal). When I create a variable (subTotal) to add these together and I display that variable in a text field, the value is null. When I perform the addition within the text field itself, the value is correct. Why do these displayed values differ? How can I store the subTotal calculation in a variable for later reuse? The only difference between the working and non-working version is that this line: <textFieldExpression><![CDATA[$V{logTotal}.subtract($V{truckingTotal}).subtract($V{loggingTotal}).subtract($V{expenseTotal})]]> is replaced with this one: <textFieldExpression><![CDATA[$V{subTotal}]]></textFieldExpression> Applicable jrxml for the working version is included below.

I had hoped this was just a glitch, as I fixed it by deleting the existing calculations and recreating them. HOWEVER, I find I'm now facing a similar problem. See this posting.

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]

@hozawa: As noted above, I've tried this and the results have been unsatisfactory.

I'm creating a summary report in Java using Jasper Reports where information on logs (trees) and their prices is displayed. I want to show the price per thousand board feet for each species. The calculation for this is: cost * 1000 / netFootage. The data is supplied as a list of JavaBeans. Problem: the resulting price/MBF is not correct, as demonstrated by doing the math using the cost and netFootage shown below. The only way around this that I've been able to come up with is performing the summary calculations outside of Jasper Reports, and that's a headache I'd rather not suffer if I don't have to. If I change from using the fields cost and netFootage to using the variables cost1 and netFootage1, I get this result, which is different... but still wrong. This is the full inventory.jrxml file: <?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-04T19:33:33 --><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="reportDate" class="java.lang.String" isForPrompting="false"/> <queryString> <![CDATA[]]> </queryString> <field name="species" class="java.lang.String"/> <field name="netFootage" class="java.math.BigDecimal"/> <field name="overheadCost" class="java.math.BigDecimal"/> <field name="cost" class="java.math.BigDecimal"/> <variable name="netFootage1" class="java.math.BigDecimal" resetType="Group" resetGroup="Species" calculation="Sum"> <variableExpression><![CDATA[$F{netFootage}]]></variableExpression> </variable> <variable name="species1" class="java.lang.Integer" resetType="Group" resetGroup="Species" calculation="Count"> <variableExpression><![CDATA[$F{species}]]></variableExpression> </variable> <variable name="priceRate1" class="java.math.BigDecimal" resetType="Group" resetGroup="Species"> <variableExpression><![CDATA[$F{cost}.multiply(new BigDecimal(1000)).divide( $F{netFootage} )]]></variableExpression> </variable> <variable name="cost1" class="java.math.BigDecimal" resetType="Group" resetGroup="Species" calculation="Sum"> <variableExpression><![CDATA[$F{cost}]]></variableExpression> </variable> <variable name="overhead1" class="java.math.BigDecimal" resetType="Group" resetGroup="Species" calculation="Sum"> <variableExpression><![CDATA[$F{overheadCost}]]></variableExpression> </variable> <variable name="lineTotal1" class="java.math.BigDecimal" resetType="Group" resetGroup="Species"> <variableExpression><![CDATA[$V{cost1}.add( $V{overhead1} )]]></variableExpression> </variable> <variable name="species2" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[$F{species}]]></variableExpression> </variable> <variable name="netFootage2" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{netFootage}]]></variableExpression> </variable> <variable name="priceRate2" class="java.math.BigDecimal"> <variableExpression><![CDATA[$F{cost}.multiply(new BigDecimal(1000)).divide( $F{netFootage} )]]></variableExpression> </variable> <variable name="overheadCost1" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{overheadCost}]]></variableExpression> </variable> <variable name="cost2" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{cost}]]></variableExpression> </variable> <variable name="lineTotal2" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$V{cost1}.add( $V{overhead1} )]]></variableExpression> </variable> <group name="Species"> <groupExpression><![CDATA[$F{species}]]></groupExpression> <groupFooter> <band height="15"> <textField isBlankWhenNull="true"> <reportElement x="0" y="0" width="100" height="15" printWhenGroupChanges="Species" uuid="1123bb45-40fd-4fc9-a5f1-2e976d1a3f99"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{species}]]></textFieldExpression> </textField> <textField> <reportElement x="190" y="-1" width="70" height="15" uuid="b655bef4-dcf0-4e3a-818d-8383020f3e8c"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{netFootage1}]]></textFieldExpression> </textField> <textField> <reportElement x="110" y="0" width="80" height="15" printWhenGroupChanges="Species" uuid="db90f3b9-aca4-4ab5-97b0-48c9dfda815f"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{species1}]]></textFieldExpression> </textField> <textField evaluationTime="Group" evaluationGroup="Species" pattern="¤#,##0.000;¤-#,##0.000" isBlankWhenNull="true"> <reportElement x="260" y="0" width="80" height="15" printWhenGroupChanges="Species" uuid="8188363f-3984-4b11-bfcf-c99cf65c8a61"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{priceRate1}]]></textFieldExpression> </textField> <textField evaluationTime="Group" evaluationGroup="Species" pattern="¤#,##0.##;¤-#,##0.##"> <reportElement x="340" y="0" width="80" height="15" uuid="8a707e2f-3e22-46d7-a833-f95a3538541c"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{cost1}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.00;¤-#,##0.00"> <reportElement x="420" y="0" width="80" height="15" uuid="a345cd4e-32b5-4bd6-bb89-d3064bbe4042"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{overhead1}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.00;¤-#,##0.00"> <reportElement x="500" y="0" width="70" height="15" uuid="5679a2ee-43dd-4e52-9915-0da8b2788cfc"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{lineTotal1}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="95" splitType="Stretch"> <image hAlign="Center"> <reportElement x="0" y="-2" width="580" height="50" uuid="93bfff74-d6ee-4b94-a5b8-4db39f4515d5"/> <imageExpression><![CDATA["images/title.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[Current Inventory Report]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="445" y="80" width="125" height="15" uuid="2f423025-4158-42ad-b5bc-29aec3d63ee2"/> <textFieldExpression><![CDATA[$P{reportDate}]]></textFieldExpression> </textField> <staticText> <reportElement x="354" y="80" width="91" height="15" uuid="2dbec0c0-05cc-46f5-bf36-d92609e5c152"/> <textElement textAlignment="Right"/> <text><![CDATA[Report Date:]]></text> </staticText> </band> </title> <columnHeader> <band height="21" splitType="Stretch"> <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="1" width="100" height="20" uuid="d839c8d1-ff31-4aa0-a0ea-d0d57780f919"/> <text><![CDATA[species]]></text> </staticText> <staticText> <reportElement x="500" y="0" width="70" height="20" uuid="b6a482c2-52e7-4e87-b4e1-cd59a605964d"/> <textElement textAlignment="Right"/> <text><![CDATA[Total Cost]]></text> </staticText> <staticText> <reportElement x="420" y="0" width="80" height="20" uuid="dcdaf6e6-d07a-4d59-a702-2ca5ee0e2667"/> <textElement textAlignment="Right"/> <text><![CDATA[Overhead Cost]]></text> </staticText> <staticText> <reportElement x="340" y="0" width="80" height="20" uuid="0064bc76-4f28-4fcd-a6a4-a0021e37c329"/> <textElement textAlignment="Right"/> <text><![CDATA[Cost]]></text> </staticText> <staticText> <reportElement x="260" y="0" width="80" height="20" uuid="a5e40833-70bc-4afa-a16e-33f7bd9225a5"/> <textElement textAlignment="Right"/> <text><![CDATA[$/MBF]]></text> </staticText> <staticText> <reportElement x="180" y="0" width="80" height="20" uuid="80325097-ad9c-4cb7-8f1d-cd28e508b85b"/> <textElement textAlignment="Right"/> <text><![CDATA[Net BFt]]></text> </staticText> <staticText> <reportElement x="110" y="0" width="80" height="20" uuid="b4bc60d0-fac0-48c0-8db3-f7cae8abbbf0"/> <textElement textAlignment="Right"/> <text><![CDATA[# of Logs]]></text> </staticText> </band> </columnHeader> <pageFooter> <band height="27" splitType="Stretch"/> </pageFooter> <summary> <band height="81" splitType="Stretch"> <line> <reportElement x="0" y="0" width="570" height="1" isRemoveLineWhenBlank="true" uuid="2815f185-79f9-4c63-9c3e-a26d889e290c"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <graphicElement> <pen lineWidth="2.0"/> </graphicElement> </line> <staticText> <reportElement x="0" y="0" width="100" height="15" uuid="31141427-83b2-49f4-8edc-d238fdcfb701"/> <textElement textAlignment="Right"> <font isBold="true"/> </textElement> <text><![CDATA[Totals: ]]></text> </staticText> <textField> <reportElement x="110" y="0" width="80" height="15" uuid="baa57730-fef0-4194-a2a0-1fb67428615b"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{species2}]]></textFieldExpression> </textField> <textField> <reportElement x="190" y="0" width="70" height="15" uuid="e9fc1f24-c4d8-430e-a9ed-15874c450c15"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{netFootage2}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.000;¤-#,##0.000"> <reportElement x="260" y="0" width="80" height="15" uuid="673065c9-010a-40ac-bae0-3286df02b659"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{priceRate2}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.00;¤-#,##0.00"> <reportElement x="420" y="0" width="80" height="15" uuid="a96091a6-d61a-4624-aa5b-49fe00cdde75"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{overheadCost1}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.##;¤-#,##0.##"> <reportElement x="340" y="0" width="80" height="15" uuid="1530dda8-714f-48e8-886c-66e1c0122c65"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{cost2}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.00;¤-#,##0.00"> <reportElement x="500" y="0" width="70" height="15" uuid="57e3165b-60cc-4e08-bf71-9b9b3681219c"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{lineTotal2}]]></textFieldExpression> </textField> </band> </summary></jasperReport>[/code]