Row Group Total showing null in Crosstab (Run from jasper server)

[sanjayapradhan30]

Hi

I am trying to convert the following table data to a report using cross tab (as shown in image-2)

Image-1

The report is getting generated as expected when i open the server copy and click on the "Preview" button.

But when I try to run it from the server through option menu as shown in the image, the total value for column ( "Total Kilos" and "Re-Use" is showing null (blank))

why it's not working when run from server, is there something else i need to do?

Please help me out. I am stuck with this issue.

In image-3 i have added the crosstab "Report Inspecter view" and Crosstab screenshot.

Image-2

Image -3

Thanks

Sanjaya

[hozawa]

You need to provide version of JasperReports Server you are using. Haven't encountered that problem with JasperReports Server 5.6.1.

[sanjayapradhan30]

Hi Hozawa,

Thanks for you timely reply. iReport version is : 4.1.3 and Jasper server version is 4.1.

I have provided the below picture of the report inspector pane and the jrxml file too. 

Please let me know if some thing wrong in this.

/sites/default/files/images/Report%20Inspecter.jpg

<?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="WTN Report" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true">

<property name="ireport.jasperserver.reportUnit" value="/reports/mattelli/Test_1"/>

<property name="ireport.jasperserver.url" value="http://212.126.140.27:903/jasperserver/services/repository"/>

<property name="ireport.zoom" value="1.1000000000000005"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="0"/>

<style name="Crosstab Data Text" hAlign="Center"/>

<style name="Mismatch Data Text">

<conditionalStyle>

<conditionExpression><![CDATA[$V{WEIGHTMeasure_Equipment_Desc_ALL} != $V{total_Kilos}]]></conditionExpression>

<style forecolor="#FF0000" hAlign="Center" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false">

<pen lineColor="#FF0000"/>

</style>

</conditionalStyle>

</style>

<subDataset name="Crosstab">

<parameter name="WTNHeaderID" class="java.lang.String">

<defaultValueExpression><![CDATA[]]></defaultValueExpression>

</parameter>

<queryString>

<![CDATA[sELECT WWL.id,

            WWL.DESCRIPTION || ' X ' || NVL(WWL.QTY,1) AS "Equipment_Desc",

            CNT.category_count AS "COUNT",

            NVL(WWL.NETTWT,0) as "Total Kilos",

            NVL2(WWL.NETTWT,WWL.NETTWT/CNT.category_count,0) "Divided Kilo",

            NVL( (SELECT sum(wi2.WEIGHT) "Weight"

             FROM

                  WMS_ITEM_BKP wi2

             WHERE wi2.WTNHEADERID  = wwh.ID

             AND wi2.WTNLINEID      = wwl.ID

             AND UPPER(wi2.typeid) !=(SELECT id FROM WMS_ITEM_TYPE WHERE upper(shortname) = 'RECOVERED')

             GROUP BY wwl.id),0) "Re-use",

            WRM.SHORTNAME ||' '|| WRM.EWCCODE shortname,

            NVL(WI.WEIGHT,0) "WEIGHT"

            FROM

            (SELECT wi1.wtnlineid WTNLID, count(*) category_count

            FROM

            WMS_ITEM_BKP WI1

            WHERE

            UPPER(wi1.typeid) = (SELECT id FROM WMS_ITEM_TYPE WHERE upper(shortname) = 'RECOVERED')

            group by wi1.wtnlineid ) CNT,

            WMS_RECOVERY_MATERIAL_BKP WRM,

            WMS_ITEM_BKP WI,

            WMS_WASTETRANSFERNOTE_HD_BKP wwh,

            WMS_WASTETRANSFERNOTE_LINE_BKP wwl

            WHERE WRM.id = WI.MATERIALID (+)

            AND CNT.WTNLID = WI.WTNLINEID

            AND UPPER(wi.typeid) = (SELECT id FROM WMS_ITEM_TYPE WHERE upper(shortname) = 'RECOVERED')

            AND wi.wtnlineid = wwl.id

            AND wi.wtnheaderid = wwh.id

            AND wwl.HEADERID = wwh.ID

            AND wwh.ID = $P{WTNHeaderID}]]>

</queryString>

<field name="ID" class="java.math.BigDecimal"/>

<field name="Equipment_Desc" class="java.lang.String"/>

<field name="COUNT" class="java.math.BigDecimal"/>

<field name="Total Kilos" class="java.math.BigDecimal"/>

<field name="Divided Kilo" class="java.math.BigDecimal"/>

<field name="Re-use" class="java.math.BigDecimal"/>

<field name="SHORTNAME" class="java.lang.String"/>

<field name="WEIGHT" class="java.math.BigDecimal"/>

</subDataset>

<parameter name="WTNHeaderID" class="java.lang.String"/>

<queryString>

<![CDATA[sELECT org.longname CUST_NAME,

  s.Shortname SITE_NAME,

  s.firstname||' '||s.lastname "SITE_CONTACT", s.addressline1||chr(10)||s.addressline2||','||s.addressline3||''||s.addressline4||chr(10)||s.postcode SITE_ADDRESS,

  s.TELEPHONENUMBER CONTACT_NUM,

  wwh.sitecontact SITE_CONTACT,

 '100' as totalqty

FROM SITE s,

     ORGENTITY org,

     WMS_WASTETRANSFERNOTE_HEADER wwh

WHERE org.siteid = s.id

AND wwh.siteid = s.id(+)

AND wwh.ID = $P{WTNHeaderID}]]>

</queryString>

<field name="CUST_NAME" class="java.lang.String"/>

<field name="SITE_NAME" class="java.lang.String"/>

<field name="SITE_CONTACT" class="java.lang.String"/>

<field name="SITE_ADDRESS" class="java.lang.String"/>

<field name="CONTACT_NUM" class="java.lang.String"/>

<field name="TOTALQTY" class="java.lang.String"/>

<background>

<band splitType="Stretch"/>

</background>

<title>

<band height="310" splitType="Stretch">

<rectangle>

<reportElement x="0" y="20" width="188" height="251"/>

</rectangle>

<image>

<reportElement x="2" y="34" width="118" height="49"/>

<imageExpression><![CDATA["repo:n2s.jpg"]]></imageExpression>

</image>

<staticText>

<reportElement x="2" y="20" width="186" height="14"/>

<textElement>

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[The waste will be taken to:]]></text>

</staticText>

<staticText>

<reportElement x="2" y="85" width="186" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[Network House, Western Way,]]></text>

</staticText>

<staticText>

<reportElement x="2" y="99" width="186" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[bury St.Edmunds, Suffolk, IP33 3SP]]></text>

</staticText>

<staticText>

<reportElement x="16" y="113" width="172" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[01234 761111]]></text>

</staticText>

<staticText>

<reportElement x="16" y="127" width="172" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[01234 719093]]></text>

</staticText>

<staticText>

<reportElement x="2" y="141" width="14" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[W:]]></text>

</staticText>

<textField hyperlinkType="Reference" hyperlinkTarget="Blank">

<reportElement x="16" y="141" width="172" height="14" forecolor="#0000FF"/>

<textElement>

<font size="8" isBold="true" isUnderline="true"/>

</textElement>

<textFieldExpression><![CDATA["www.n2s.co.uk"]]></textFieldExpression>

<hyperlinkReferenceExpression><![CDATA["http://www.n2s.co.uk"]]></hyperlinkReferenceExpression>

</textField>

<staticText>

<reportElement x="2" y="159" width="186" height="14"/>

<textElement>

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Waste Exemptions:]]></text>

</staticText>

<staticText>

<reportElement x="2" y="173" width="186" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[storage of WEEE S2 ref.YH0616XH]]></text>

</staticText>

<staticText>

<reportElement x="2" y="187" width="186" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Repair or Refurbishment of WEEE T11]]></text>

</staticText>

<staticText>

<reportElement x="2" y="201" width="186" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[ref. NCC/059575/2012]]></text>

</staticText>

<staticText>

<reportElement x="2" y="215" width="186" height="14"/>

<textElement>

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Waste Carrier Licence:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="2" y="229" width="186" height="14"/>

<textElement verticalAlignment="Middle">

<font size="10"/>

</textElement>

<text><![CDATA[CB/VE5338ZK]]></text>

</staticText>

<staticText>

<reportElement x="2" y="243" width="186" height="14"/>

<textElement>

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Hazardous Waste Registration:

]]></text>

</staticText>

<staticText>

<reportElement x="2" y="257" width="186" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[NW1594]]></text>

</staticText>

<rectangle>

<reportElement x="202" y="20" width="600" height="251"/>

</rectangle>

<rectangle>

<reportElement x="636" y="20" width="166" height="251"/>

</rectangle>

<rectangle>

<reportElement x="202" y="217" width="220" height="55"/>

</rectangle>

<rectangle>

<reportElement x="422" y="216" width="214" height="55"/>

</rectangle>

<rectangle>

<reportElement x="202" y="20" width="220" height="197"/>

</rectangle>

<staticText>

<reportElement x="2" y="127" width="14" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[F:]]></text>

</staticText>

<staticText>

<reportElement x="2" y="113" width="14" height="14"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[T:]]></text>

</staticText>

<staticText>

<reportElement x="2" y="273" width="41" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Disposal]]></text>

</staticText>

<rectangle>

<reportElement x="43" y="274" width="10" height="10"/>

</rectangle>

<staticText>

<reportElement x="73" y="273" width="62" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Data Erasure]]></text>

</staticText>

<rectangle>

<reportElement x="135" y="274" width="10" height="10"/>

</rectangle>

<staticText>

<reportElement x="165" y="273" width="79" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Data Destruction]]></text>

</staticText>

<rectangle>

<reportElement x="243" y="274" width="10" height="10"/>

</rectangle>

<staticText>

<reportElement x="275" y="273" width="37" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[storage]]></text>

</staticText>

<rectangle>

<reportElement x="312" y="274" width="10" height="10"/>

</rectangle>

<staticText>

<reportElement x="341" y="273" width="248" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[inventory Required:  No/ Basic/ Comprehencivce]]></text>

</staticText>

<staticText>

<reportElement x="638" y="20" width="167" height="14"/>

<textElement>

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Notes:]]></text>

</staticText>

<staticText>

<reportElement x="204" y="20" width="27" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[site:]]></text>

</staticText>

<staticText>

<reportElement x="204" y="34" width="73" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="false"/>

</textElement>

<text><![CDATA[Contact name:]]></text>

</staticText>

<staticText>

<reportElement x="204" y="76" width="27" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="false"/>

</textElement>

<text><![CDATA[Tele:]]></text>

</staticText>

<staticText>

<reportElement x="204" y="99" width="218" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="false"/>

</textElement>

<text><![CDATA[Collection Address:]]></text>

</staticText>

<staticText>

<reportElement x="422" y="20" width="60" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[Customer:]]></text>

</staticText>

<staticText>

<reportElement x="422" y="34" width="95" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[Order Number:]]></text>

</staticText>

<staticText>

<reportElement x="422" y="62" width="214" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[Customer name and address:]]></text>

</staticText>

<staticText>

<reportElement x="424" y="141" width="212" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[Customer Project Manager:]]></text>

</staticText>

<staticText>

<reportElement x="424" y="155" width="37" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="false"/>

</textElement>

<text><![CDATA[Name:]]></text>

</staticText>

<staticText>

<reportElement x="424" y="183" width="27" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="false"/>

</textElement>

<text><![CDATA[Tele:]]></text>

</staticText>

<staticText>

<reportElement x="204" y="217" width="100" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[identified site risks:]]></text>

</staticText>

<staticText>

<reportElement x="424" y="215" width="145" height="14"/>

<textElement>

<font size="10" isBold="true" isUnderline="true"/>

</textElement>

<text><![CDATA[Corrective actions applied:]]></text>

</staticText>

<staticText>

<reportElement x="1" y="0" width="800" height="16"/>

<textElement>

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[Duty of care 'Equipment Transfer Note' and 'Site Risk Assessment']]></text>

</staticText>

<textField isBlankWhenNull="true">

<reportElement x="231" y="20" width="191" height="14"/>

<textElement/>

<textFieldExpression><![CDATA[$F{SITE_NAME}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="204" y="48" width="218" height="28"/>

<textElement/>

<textFieldExpression><![CDATA[$F{SITE_CONTACT}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="231" y="76" width="191" height="14"/>

<textElement/>

<textFieldExpression><![CDATA[$F{CONTACT_NUM}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="204" y="113" width="218" height="88"/>

<textElement/>

<textFieldExpression><![CDATA[$F{SITE_ADDRESS}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="482" y="20" width="154" height="14"/>

<textElement/>

<textFieldExpression><![CDATA[$F{CUST_NAME}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="304" y="218" width="115" height="14"/>

<textElement verticalAlignment="Middle">

<font size="6" isBold="true"/>

</textElement>

<text><![CDATA[(Write 'None' if there are no site risks)]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="0" y="290" width="219" height="20" backcolor="#CCCCCC"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font isBold="true"/>

</textElement>

<text><![CDATA[inwards]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="219" y="290" width="584" height="20" backcolor="#CCCCCC"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font isBold="true"/>

</textElement>

<text><![CDATA[Outwards(Weight in kilos by category)]]></text>

</staticText>

</band>

</title>

<summary>

<band height="209" splitType="Stretch">

<rectangle>

<reportElement positionType="Float" x="0" y="102" width="241" height="93"/>

</rectangle>

<rectangle>

<reportElement positionType="Float" x="275" y="102" width="251" height="93"/>

</rectangle>

<rectangle>

<reportElement positionType="Float" x="561" y="102" width="241" height="93"/>

</rectangle>

<staticText>

<reportElement positionType="Float" x="2" y="102" width="118" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Vehicle Registration:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="2" y="116" width="241" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Driver/Engineer name and signature:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="277" y="102" width="154" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Customer approval signature:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="277" y="143" width="154" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[Collection Date:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="564" y="102" width="237" height="41"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[i confirm that I have fulfilled my duty to apply the waste hierarchy as required by regulation 12 of the waste (England and Wales) Regulations 011.]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="563" y="165" width="39" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[signed:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="686" y="165" width="22" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[sIC:]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="2" y="195" width="801" height="14"/>

<textElement>

<font size="10"/>

</textElement>

<text><![CDATA[White: N2S copy                    Pink: Customer copy                   Yellow: Supplier copy]]></text>

</staticText>

<crosstab isRepeatRowHeaders="false" columnBreakOffset="0" ignoreWidth="false">

<reportElement x="0" y="0" width="801" height="102"/>

<crosstabDataset>

<dataset>

<datasetRun subDataset="Crosstab">

<datasetParameter name="WTNHeaderID">

<datasetParameterExpression><![CDATA[$P{WTNHeaderID}]]></datasetParameterExpression>

</datasetParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

</datasetRun>

</dataset>

</crosstabDataset>

<crosstabHeaderCell>

<cellContents>

<staticText>

<reportElement style="Crosstab Data Text" x="0" y="0" width="130" height="30"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Equipment Description]]></text>

</staticText>

<staticText>

<reportElement style="Crosstab Data Text" x="130" y="0" width="89" height="30"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Total Kilos]]></text>

</staticText>

<staticText>

<reportElement style="Crosstab Data Text" x="219" y="0" width="125" height="30"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="10" isBold="true"/>

</textElement>

<text><![CDATA[Re-Use]]></text>

</staticText>

</cellContents>

</crosstabHeaderCell>

<rowGroup name="Equipment_Desc" width="130" totalPosition="End">

<bucket class="java.lang.String">

<bucketExpression><![CDATA[$F{Equipment_Desc}]]></bucketExpression>

</bucket>

<crosstabRowHeader>

<cellContents backcolor="#F0F8FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="130" height="25"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{Equipment_Desc}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabRowHeader>

<crosstabTotalRowHeader>

<cellContents backcolor="#BFE1FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<staticText>

<reportElement x="0" y="0" width="130" height="36"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="9"/>

</textElement>

<text><![CDATA[Total]]></text>

</staticText>

<textField isBlankWhenNull="true">

<reportElement style="Crosstab Data Text" x="130" y="0" width="89" height="36"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="9"/>

</textElement>

<textFieldExpression><![CDATA[$V{Total_kilos_measure}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement style="Crosstab Data Text" x="219" y="0" width="125" height="36"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="9"/>

</textElement>

<textFieldExpression><![CDATA[$V{measure1}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabTotalRowHeader>

</rowGroup>

<rowGroup name="total_Kilos" width="89">

<bucket class="java.math.BigDecimal">

<bucketExpression><![CDATA[$F{Total Kilos}]]></bucketExpression>

</bucket>

<crosstabRowHeader>

<cellContents>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="89" height="25"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{total_Kilos}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabRowHeader>

<crosstabTotalRowHeader>

<cellContents/>

</crosstabTotalRowHeader>

</rowGroup>

<rowGroup name="group1" width="125">

<bucket class="java.math.BigDecimal">

<bucketExpression><![CDATA[$F{Re-use}]]></bucketExpression>

</bucket>

<crosstabRowHeader>

<cellContents>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="125" height="25"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{group1}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabRowHeader>

<crosstabTotalRowHeader>

<cellContents/>

</crosstabTotalRowHeader>

</rowGroup>

<columnGroup name="SHORTNAME" height="30" totalPosition="End">

<bucket class="java.lang.String">

<bucketExpression><![CDATA[$F{SHORTNAME}]]></bucketExpression>

</bucket>

<crosstabColumnHeader>

<cellContents backcolor="#F0F8FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="214" height="30"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{SHORTNAME}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabColumnHeader>

<crosstabTotalColumnHeader>

<cellContents backcolor="#BFE1FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<staticText>

<reportElement x="0" y="0" width="94" height="30"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle"/>

<text><![CDATA[Total]]></text>

</staticText>

</cellContents>

</crosstabTotalColumnHeader>

</columnGroup>

<measure name="WEIGHTMeasure" class="java.math.BigDecimal" calculation="Sum">

<measureExpression><![CDATA[$F{WEIGHT}]]></measureExpression>

</measure>

<measure name="Total_kilos_measure" class="java.math.BigDecimal" calculation="Sum">

<measureExpression><![CDATA[$F{Divided Kilo}]]></measureExpression>

</measure>

<measure name="measure1" class="java.lang.Integer" calculation="Sum">

<measureExpression><![CDATA[$F{Re-use}/$F{COUNT}]]></measureExpression>

</measure>

<crosstabCell width="214" height="25">

<cellContents>

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="214" height="25"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{WEIGHTMeasure}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabCell>

<crosstabCell width="214" height="36" rowTotalGroup="Equipment_Desc">

<cellContents backcolor="#BFE1FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="214" height="36"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement/>

<textFieldExpression><![CDATA[$V{WEIGHTMeasure}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabCell>

<crosstabCell width="94" columnTotalGroup="SHORTNAME">

<cellContents backcolor="#BFE1FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Mismatch Data Text" x="0" y="0" width="94" height="25"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$V{WEIGHTMeasure}+$V{group1}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabCell>

<crosstabCell width="94" height="36" rowTotalGroup="Equipment_Desc" columnTotalGroup="SHORTNAME">

<cellContents backcolor="#BFE1FF" mode="Opaque">

<box>

<pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>

</box>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="23" width="94" height="13"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement>

<font size="9"/>

</textElement>

<textFieldExpression><![CDATA[$V{WEIGHTMeasure}]]></textFieldExpression>

</textField>

<textField>

<reportElement style="Crosstab Data Text" x="0" y="0" width="94" height="23"/>

<textElement>

<font size="9"/>

</textElement>

<textFieldExpression><![CDATA[$V{WEIGHTMeasure}+$V{measure1}]]></textFieldExpression>

</textField>

</cellContents>

</crosstabCell>

<crosstabCell height="25" rowTotalGroup="total_Kilos">

<cellContents/>

</crosstabCell>

<crosstabCell height="25" rowTotalGroup="total_Kilos" columnTotalGroup="SHORTNAME">

<cellContents/>

</crosstabCell>

<crosstabCell rowTotalGroup="group1">

<cellContents/>

</crosstabCell>

<crosstabCell rowTotalGroup="group1" columnTotalGroup="SHORTNAME">

<cellContents/>

</crosstabCell>

</crosstab>

</band>

</summary>

</jasperReport>