[Funnel Chart Using iReport]

Hi Bill

I have the same requirement, did you get any solution, if yes could you please share.

Thanks,
sanjaya

[Inverted Pyramid and doughnut chart in Jasper IReport]

Hi,

I have one requirement to draw an inverted Pyramid and doughnut chart in jasper IReport, But i could not find any.

Is there any plugin/option available for this?

Regards,
sanjaya

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

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>

 

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

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

[can we display total for row group in crosstab in ireport]

I am also facing the same issue. Please reply if anyone got fix for this. Please update.

[can we display total for row group in crosstab in ireport]

Hi,

I am also facing the same issue. Please reply if anyone got fix for this. Please update.

[How to show Total in rowGroup level of a "Crosstab"?]

Hi,

I am trying to show the data fetched from query as shown in below as a cross tab.

what i am trying to achive is to show  Equipment, Total Kilos and Re-Use in row Group level, and shortname as colums, and their corresponding sums.

But, the issue i am facing is since there are two rows having Total kilos 40 each for equipment "All_WTN_TEST X 50" the total is shown as 80, which is wrong.

I need to show the sum of total kilos equipment wise.(e.g All_WTN_Test - 40 + Printers 0 = 40) if printer is of 5 Kg then (40+5=45))

since equipments are 2 so sum of those two should be show.

 

Can any one please let me how to achive this? (I am bit new to jasper report design)

  

Thanks in advance.

 

Regards,

sanjaya

[Dynamically showing columns]

Hi,

I need to create a jasper report with following format

 

Entity   Weight   Plastic  Glass   Iron      Total

-------- -------  -------- -----   -------   -------------

Computer 5    Kg  2 Kg     1 Kg    1 Kg      4   Kg

Car      1000 Kg  100 Kg   100Kg   500Kg     700 Kg

Mobile   0.9  Kg  0.5 Kg   0.02Kg  0.04kg    0.56 Kg

-------------------------------------------- -------------

TOTAL    1005.9Kg 102.5Kg  101.02Kg 501.04Kg 704.56 Kg

----------------------------------------------------------

 

The Entities(Computer,car,mobile) and material (Plastic,Glass,Iron) are stored in different  tables.

 

The list of materials can increase dynamically, so I need to show only 8 materials per page, then we need to break the page and show the total in the final page.

 

Can anyone tell me if this possible? How to achieve it using oracle sql query/ in jasper.

 

Thanks in advance.

 

**Regards**,

**SAN**