在尝试SUM组变量时，为什么在报表上打印错误的数字？ [英] Why do I have wrong number printing out on report while trying to SUM a group variable?
本文介绍了在尝试SUM组变量时，为什么在报表上打印错误的数字？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我已在iReport中制作了自定义报告，在尝试完报告后，我注意到我的 总计数量 变量没有打印出正确的数量。
我将所有字段放入名为 product 的组中，该组的目的是分组提取所有productNumbers（名称），然后总结每个数量。存储每件商品总数的变量为 sumTotalQuantity
问题在于 产品组页脚 我创建了一个名为 sumGrandTotalQuantity 的变量来汇总 sumTotalQuantity 变量。
尽管有什么理由将数字返回到 sumGrandTotalQuantity 变量大于组波段变量。
为什么我的变量没有返回正确的变量？这是我试图总计已经整理东西的组变量的方式吗？
正如你在上一张照片中看到的那样 - 实际显示的总数量是173而不是显示的175.
<？xml version =1.0encoding = UTF-8\" >？;
< jasperReport xmlns =http://jasperreports.sourceforge.net/jasperreportsxmlns：xsi =http://www.w3.org/2001/XMLSchema-instancexsi：schemaLocation =http： //jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsdname =SalesOrderItemsByZippageWidth =595pageHeight =842columnWidth =555leftMargin =20 rightMargin =20topMargin =20bottomMargin =20uuid =d4cb0e75-8b4b-4aba-9324-9be9518ac4c7>
< property name =ireport.zoomvalue =1.5/>
< property name =ireport.xvalue =0/>
< property name =ireport.yvalue =0/>
< parameter name =Fromclass =java.util.Date/>
< parameter name =Toclass =java.util.Date/>
< parameter name =ZipCodeclass =java.lang.StringisForPrompting =false/>
< parameter name =Stateclass =java.lang.StringisForPrompting =false>
< defaultValueExpression><！[CDATA []]>< / defaultValueExpression>
< /参数>
< queryString>
<！[CDATA [SELECT
soitem.PRODUCTNUM，so.SHIPTOZIP as ZIP，soitem.QTYTOFULFILL as QTY，so.SHIPTOSTATEID as stateID，COALESCE（stateconst.code，''）AS stateabbr，so .DATECOMPLETED为soDATE，soitem.TOTALPRICE为totalAmount，soitem.typeid，company.NAME AS companyName
FROM so
在STATECONST.ID上的JOIN STATECONST = so.SHIPTOSTATEID
在soitem.SOID上加入soitem = so.ID，
公司公司
WHERE
so.DATECOMPLEDED $ P {From}和$ P {To}
AND（UPPER（COALESCE（stateconst.code） ，''））= UPPER（$ P {State}）OR so.SHIPTOZIP = $ P {ZipCode}）
AND soitem.PRODUCTNUM！='SHIPPING'
AND soitem.PRODUCTNUM！='SAMPLE '
AND soitem.PRODUCTNUM！='船只联系'
AND（soitem.typeid = 10 OR soitem.typeid = 20）
ORDER BY 1]]>
< / queryString>
< field name =PRODUCTNUMclass =java.lang.String/>
< field name =ZIPclass =java.lang.String/>
< field name =QTYclass =java.lang.Double/>
< field name =STATEIDclass =java.lang.Integer/>
< field name =STATEABBRclass =java.lang.String/>
< field name =SODATEclass =java.sql.Timestamp/>
< field name =TOTALAMOUNTclass =java.lang.Double/>
< field name =TYPEIDclass =java.lang.Integer/>
< field name =COMPANYNAMEclass =java.lang.String/>
< variable name =sumTotalQuantityclass =java.lang.DoubleresetType =GroupresetGroup =productcalculation =Sum>
< variableExpression><！[CDATA [$ F {QTY}]]>< / variableExpression>
< / variable>
< variable name =sumGrandTotalQuantityclass =java.lang.Doublecalculation =Sum>
< variableExpression><！[CDATA [$ V {sumTotalQuantity}]]>< / variableExpression>
< initialValueExpression><！[CDATA [0d]]>< / initialValueExpression>
< / variable>
< variable name =sumGrandTotalAmountclass =java.lang.Doublecalculation =Sum>
< variableExpression><！[CDATA [$ F {TOTALAMOUNT}]]>< / variableExpression>
< / variable>
< group name =product>
< groupExpression><！[CDATA [$ F {PRODUCTNUM}]]>< / groupExpression>
< groupFooter>
< band height =50>
< textField evaluationTime =GroupevaluationGroup =productpattern =### 0.00>
< reportElement x =175y =0width =50height =20uuid =915c3f87-127a-4ec7-8b54-136612672c46/>
< textElement textAlignment =Center/>
< textFieldExpression><！[CDATA [$ V {sumTotalQuantity}]]>< / textFieldExpression>
< / textField>
< textField>
< reportElement x =375y =0width =75height =20uuid =4d241f98-7272-4c6e-bdc4-d395de916ede/>
< textElement textAlignment =Center/>
< textFieldExpression><！[CDATA [$ F {ZIP}]]>< / textFieldExpression>
< / textField>
< textField>
< reportElement x =479y =0width =75height =20uuid =3885c024-0db1-44f3-83c0-7f82a9d43a6c/>
< textElement textAlignment =Center/>
< textFieldExpression><！[CDATA [$ F {STATEABBR}]]>< / textFieldExpression>
< / textField>
< textField>
< reportElement x =0y =0width =150height =50uuid =16730885-6808-471e-b14c-cce62c865307/>
< textFieldExpression><！[CDATA [$ F {PRODUCTNUM}]]>< / textFieldExpression>
< / textField>
< textField pattern =¤＃，## 0.00>
< reportElement x =250y =0width =100height =20uuid =1cc304ae-ca15-40d4-ab0c-122b6909677b/>
< textElement textAlignment =Center/>
< textFieldExpression><！[CDATA [$ F {TOTALAMOUNT}]]>< / textFieldExpression>
< / textField>
< / band>
< / groupFooter>
< / group>
< title>
< band height =50splitType =Stretch>
< textField>
< reportElement x =0y =0width =555height =25uuid =02aceea0-791a-430c-9bb4-b6c0a62bb29a/>
< textElement textAlignment =CenterverticalAlignment =Middle>
< font size =16isBold =true/>
< / textElement>
< textFieldExpression><！[CDATA [$ F {COMPANYNAME}]]>< / textFieldExpression>
< / textField>
< staticText>
< reportElement x =0y =25width =555height =25uuid =044c5bea-f482-4329-93d0-64433f0714a9/>
< textElement textAlignment =CenterverticalAlignment =Middle>
< font size =15isBold =true/>
< / textElement>
< text><！[CDATA [按邮编的销售订单项目]]>< / text>
< / staticText>
< / band>
< / title>
< pageHeader>
< band height =20>
< staticText>
< reportElement x =301y =0width =20height =20uuid =e3eeac2b-12bb-43af-b133-1faeabdb0260/>
< textElement textAlignment =Center>
< font size =14/>
< / textElement>
< text><！[CDATA [ - ]]>< / text>
< / staticText>
< textField pattern =MM / dd / yyyy>
< reportElement x =226y =0width =75height =20uuid =1c3c18a3-d58c-41a9-b157-9baecdc04a70/>
< textElement textAlignment =Right>
< font size =14/>
< / textElement>
< textFieldExpression><！[CDATA [$ P {From}]]>< / textFieldExpression>
< / textField>
< staticText>
< reportElement x =1y =0width =225height =20uuid =98522dcd-468c-4fa9-829c-e3a9349a07a4/>
< textElement textAlignment =Right>
< font size =14/>
< / textElement>
< text><！[CDATA [日期范围：]]>< / text>
< / staticText>
< textField pattern =MM / dd / yyyy>
< reportElement x =321y =0width =75height =20uuid =29ec56c7-3aff-4119-9fcb-f533608bc9ab/>
< textElement>
< font size =14/>
< / textElement>
< textFieldExpression><！[CDATA [$ P {To}]]>< / textFieldExpression>
< / textField>
< / band>
< / pageHeader>
< columnHeader>
< band height =25splitType =Stretch>
< staticText>
< reportElement x =0y =0width =150height =20uuid =b2e517f0-bd17-4b5c-a958-a6f71ecc6f3d/>
< textElement>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [Product＃]]>< / text>
< / staticText>
< staticText>
< reportElement x =175y =0width =50height =20uuid =fffdc077-159e-446e-b110-a8c3f8b2e3a0/>
< textElement textAlignment =Center>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [Qty]]>< / text>
< / staticText>
< staticText>
< reportElement x =375y =0width =75height =20uuid =fd05ad98-c3d1-43ff-a56a-9cfe47c56a7e/>
< textElement textAlignment =Center>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [ZIP]]>< / text>
< / staticText>
< staticText>
< reportElement x =479y =0width =75height =20uuid =a15d76c6-9a14-4089-bcb8-a6f58122004f/>
< textElement textAlignment =Center>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [State]]>< / text>
< / staticText>
< staticText>
< reportElement x =250y =0width =100height =20uuid =30e32f6b-9477-41f9-8eef-ef27995f5cb4/>
< textElement textAlignment =Center>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [销售额]]>< / text>
< / staticText>
< line>
< reportElement x =0y =24width =555height =1uuid =eaf8a705-5cbb-4809-9345-517f1128b919/>
< / line>
< / band>
< / columnHeader>
< summary>
< band height =45>
< staticText>
< reportElement x =0y =5width =126height =20uuid =dc471d6e-e9a6-4351-9464-07b485708f0d/>
< textElement verticalAlignment =Middle>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [总价数量：]]>< / text>
< / staticText>
< staticText>
< reportElement x =0y =25width =126height =20uuid =0d772f98-e1ef-449e-9dd0-7df1c0e4071d/>
< textElement verticalAlignment =Middle>
< font size =12isBold =true/>
< / textElement>
< text><！[CDATA [总销售额：]]>< / text>
< / staticText>
< textField evaluationTime =Reportpattern =＃，## 0>
< reportElement x =126y =5width =75height =20uuid =450ee5e0-459b-4f7b-8990-68db5732c39d/>
< textElement textAlignment =rightverticalAlignment =Middle/>
< textFieldExpression><！[CDATA [$ V {sumGrandTotalQuantity}]]>< / textFieldExpression>
< / textField>
< textField evaluationTime =Reportpattern =¤＃，## 0.00>
< reportElement x =126y =25width =75height =20uuid =9286c874-dc26-4aff-bf27-15b2dea28b9c/>
< textElement textAlignment =rightverticalAlignment =Middle/>
< textFieldExpression><！[CDATA [$ V {sumGrandTotalAmount}]]>< / textFieldExpression>
< / textField>
< line>
< reportElement x =0y =0width =555height =1uuid =01b925b2-ff3c-4df3-a5bd-ca11defc4bf2/>
< / line>
< / band>
< / summary>
< / jasperReport>
这是我的查询，变量的屏幕截图和设计视图。
< a href =https://i.stack.imgur.com/7dYc6.png =nofollow noreferrer>
解决方案
您需要正确
编辑：不要求和字段上的其他变量总和
< variable name =sumGrandTotalQuantityclass =java.lang .Doublecalculation =Sum>
< variableExpression><！[CDATA [$ F {QTY}]]>< / variableExpression>
< initialValueExpression><！[CDATA [0d]]>< / initialValueExpression>
< / variable>
I have made a custom report in iReport and after trying the report I have noticed that the variable I have Grand Total Quantity is not printing out the correct quantity number.
I have all of my fields placed into a group called "product" and the group's purpose is to group up all of the productNumbers (names) and then sum up each of their quantities. The variable storing the total quantities per item is sumTotalQuantity
The issue is that outside of the Product Group Footer I made a variable called sumGrandTotalQuantity to SUM up the values in the sumTotalQuantity variable in the group band.
For what ever reason though the number being returned into the sumGrandTotalQuantity variable is more then the group band variable.
Why is my variable not returning the correct variable? Is it the way I am trying to total up the group variable that is already SUMing up stuff?
As you can see in the last photo- the actual totled quantities showing up is 173 not the 175 that is being displayed.
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="SalesOrderItemsByZip" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d4cb0e75-8b4b-4aba-9324-9be9518ac4c7">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="From" class="java.util.Date"/>
<parameter name="To" class="java.util.Date"/>
<parameter name="ZipCode" class="java.lang.String" isForPrompting="false"/>
<parameter name="State" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT
soitem.PRODUCTNUM, so.SHIPTOZIP as ZIP, soitem.QTYTOFULFILL as QTY, so.SHIPTOSTATEID as stateID, COALESCE(stateconst.code,'') AS stateabbr, so.DATECOMPLETED as soDATE, soitem.TOTALPRICE as totalAmount, soitem.typeid, company.NAME AS companyName
FROM so
JOIN STATECONST on STATECONST.ID = so.SHIPTOSTATEID
JOIN soitem on soitem.SOID = so.ID,
"COMPANY" COMPANY
WHERE
so.DATECOMPLETED between $P{From} and $P{To}
AND (UPPER(COALESCE(stateconst.code,'')) = UPPER($P{State}) OR so.SHIPTOZIP = $P{ZipCode})
AND soitem.PRODUCTNUM != 'SHIPPING'
AND soitem.PRODUCTNUM != 'SAMPLE'
AND soitem.PRODUCTNUM != 'SHIP TO CONTACT'
AND (soitem.typeid = 10 OR soitem.typeid = 20)
ORDER BY 1]]>
</queryString>
<field name="PRODUCTNUM" class="java.lang.String"/>
<field name="ZIP" class="java.lang.String"/>
<field name="QTY" class="java.lang.Double"/>
<field name="STATEID" class="java.lang.Integer"/>
<field name="STATEABBR" class="java.lang.String"/>
<field name="SODATE" class="java.sql.Timestamp"/>
<field name="TOTALAMOUNT" class="java.lang.Double"/>
<field name="TYPEID" class="java.lang.Integer"/>
<field name="COMPANYNAME" class="java.lang.String"/>
<variable name="sumTotalQuantity" class="java.lang.Double" resetType="Group" resetGroup="product" calculation="Sum">
<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
</variable>
<variable name="sumGrandTotalQuantity" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$V{sumTotalQuantity}]]></variableExpression>
<initialValueExpression><![CDATA[0d]]></initialValueExpression>
</variable>
<variable name="sumGrandTotalAmount" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{TOTALAMOUNT}]]></variableExpression>
</variable>
<group name="product">
<groupExpression><![CDATA[$F{PRODUCTNUM}]]></groupExpression>
<groupFooter>
<band height="50">
<textField evaluationTime="Group" evaluationGroup="product" pattern="###0.00">
<reportElement x="175" y="0" width="50" height="20" uuid="915c3f87-127a-4ec7-8b54-136612672c46"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$V{sumTotalQuantity}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="375" y="0" width="75" height="20" uuid="4d241f98-7272-4c6e-bdc4-d395de916ede"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{ZIP}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="479" y="0" width="75" height="20" uuid="3885c024-0db1-44f3-83c0-7f82a9d43a6c"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{STATEABBR}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="0" width="150" height="50" uuid="16730885-6808-471e-b14c-cce62c865307"/>
<textFieldExpression><![CDATA[$F{PRODUCTNUM}]]></textFieldExpression>
</textField>
<textField pattern="¤ #,##0.00">
<reportElement x="250" y="0" width="100" height="20" uuid="1cc304ae-ca15-40d4-ab0c-122b6909677b"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{TOTALAMOUNT}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<title>
<band height="50" splitType="Stretch">
<textField>
<reportElement x="0" y="0" width="555" height="25" uuid="02aceea0-791a-430c-9bb4-b6c0a62bb29a"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="16" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{COMPANYNAME}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="25" width="555" height="25" uuid="044c5bea-f482-4329-93d0-64433f0714a9"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="15" isBold="true"/>
</textElement>
<text><![CDATA[Sales Order Items By Zip]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="20">
<staticText>
<reportElement x="301" y="0" width="20" height="20" uuid="e3eeac2b-12bb-43af-b133-1faeabdb0260"/>
<textElement textAlignment="Center">
<font size="14"/>
</textElement>
<text><![CDATA[-]]></text>
</staticText>
<textField pattern="MM/dd/yyyy">
<reportElement x="226" y="0" width="75" height="20" uuid="1c3c18a3-d58c-41a9-b157-9baecdc04a70"/>
<textElement textAlignment="Right">
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$P{From}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="1" y="0" width="225" height="20" uuid="98522dcd-468c-4fa9-829c-e3a9349a07a4"/>
<textElement textAlignment="Right">
<font size="14"/>
</textElement>
<text><![CDATA[Date Range:]]></text>
</staticText>
<textField pattern="MM/dd/yyyy">
<reportElement x="321" y="0" width="75" height="20" uuid="29ec56c7-3aff-4119-9fcb-f533608bc9ab"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$P{To}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="25" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="150" height="20" uuid="b2e517f0-bd17-4b5c-a958-a6f71ecc6f3d"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Product #]]></text>
</staticText>
<staticText>
<reportElement x="175" y="0" width="50" height="20" uuid="fffdc077-159e-446e-b110-a8c3f8b2e3a0"/>
<textElement textAlignment="Center">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Qty]]></text>
</staticText>
<staticText>
<reportElement x="375" y="0" width="75" height="20" uuid="fd05ad98-c3d1-43ff-a56a-9cfe47c56a7e"/>
<textElement textAlignment="Center">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[ZIP]]></text>
</staticText>
<staticText>
<reportElement x="479" y="0" width="75" height="20" uuid="a15d76c6-9a14-4089-bcb8-a6f58122004f"/>
<textElement textAlignment="Center">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[State]]></text>
</staticText>
<staticText>
<reportElement x="250" y="0" width="100" height="20" uuid="30e32f6b-9477-41f9-8eef-ef27995f5cb4"/>
<textElement textAlignment="Center">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Sales Amount]]></text>
</staticText>
<line>
<reportElement x="0" y="24" width="555" height="1" uuid="eaf8a705-5cbb-4809-9345-517f1128b919"/>
</line>
</band>
</columnHeader>
<summary>
<band height="45">
<staticText>
<reportElement x="0" y="5" width="126" height="20" uuid="dc471d6e-e9a6-4351-9464-07b485708f0d"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Grand Total Quantity:]]></text>
</staticText>
<staticText>
<reportElement x="0" y="25" width="126" height="20" uuid="0d772f98-e1ef-449e-9dd0-7df1c0e4071d"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Grand Total Sales:]]></text>
</staticText>
<textField evaluationTime="Report" pattern="#,##0">
<reportElement x="126" y="5" width="75" height="20" uuid="450ee5e0-459b-4f7b-8990-68db5732c39d"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$V{sumGrandTotalQuantity}]]></textFieldExpression>
</textField>
<textField evaluationTime="Report" pattern="¤ #,##0.00">
<reportElement x="126" y="25" width="75" height="20" uuid="9286c874-dc26-4aff-bf27-15b2dea28b9c"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$V{sumGrandTotalAmount}]]></textFieldExpression>
</textField>
<line>
<reportElement x="0" y="0" width="555" height="1" uuid="01b925b2-ff3c-4df3-a5bd-ca11defc4bf2"/>
</line>
</band>
</summary>
</jasperReport>
Here is my query, screenshots of the variables and design view.
解决方案
You need correct evaluationTime on your textField
$V{sumTotalQuantity}, needs to be evaluate when your group has been terminated
<textField pattern="###0.00" evaluationTime="Group" evaluationGroup="product">
<reportElement x="175" y="0" width="50" height="20" uuid="915c3f87-127a-4ec7-8b54-136612672c46"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$V{sumTotalQuantity}]]></textFieldExpression>
</textField>
$V{sumGrandTotalAmount}, should have evalutationTime="Report" (it currently works beacuse it is in the summary band, but if you move it to another band you need to set the evaluationTime.
<textField pattern="¤ #,##0.00" evaluationTime="Report">
<reportElement x="126" y="25" width="75" height="20" uuid="9286c874-dc26-4aff-bf27-15b2dea28b9c"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$V{sumGrandTotalAmount}]]></textFieldExpression>
</textField>
In iReport, select textField and set properties
EDIT: Don't sum on other variables sum on fields
<variable name="sumGrandTotalQuantity" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
<initialValueExpression><![CDATA[0d]]></initialValueExpression>
</variable>
这篇关于在尝试SUM组变量时，为什么在报表上打印错误的数字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
