zain.imtiaz

In Jaspersoft studio 6.3.1, it deletes all the row group! What should i do then? Why is it adding the TOTAL ROW forcefully when i don't want/need it??

I don't need/want to have the TOTAL ROW in my report then why do JasperSoft Studio forcefully add this??

Thanks in advance :)

I am getting a null pointer exception while previewing the report. I'm using Jaspersoft Studio 6.31. SOURCE: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --><!-- 2017-03-27T10:20:36 --><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="feeTemp" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="12c58979-90f5-4523-a9e0-06f1c064aac9"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Oracle test adapter"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="369"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="620"/> <style name="Crosstab_CH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Crosstab_CT" mode="Opaque" backcolor="#005FB3"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Crosstab_CD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <parameter name="P_LIST_TXT" class="java.lang.String"/> <parameter name="P_CAMPUS" class="java.lang.String"/> <parameter name="P_TERM" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[sELECT STD.REG_NBR, ACC.DUE_AMT, TO_CHAR(ACC.DUE_AMT) D_AMT,ACC.EVENT_NBR, 0 + ROW_NUMBER() OVER (ORDER BY STD.REG_NBR) AS S_NOFROM UCP.STUDENT STD, UCP.ACCOUNTS ACCWHERE STD.REG_NBR = ACC.REG_NBR AND SUBSTR(STD.REG_NBR,0,2) = 'C1'AND ACC.TERM_CDE = 'S17' AND ACC.EVENT_NBR IN (1,2,2.2,3.4)ORDER BY 1,3]]> </queryString> <field name="REG_NBR" class="java.lang.String"/> <field name="DUE_AMT" class="java.math.BigDecimal"/> <field name="D_AMT" class="java.lang.String"/> <field name="EVENT_NBR" class="java.math.BigDecimal"/> <field name="S_NO" class="java.math.BigDecimal"/> <background> <band splitType="Stretch"/> </background> <title> <band height="60" splitType="Stretch"> <textField> <reportElement x="5" y="19" width="550" height="21" uuid="179b059a-0db1-4d6a-a094-c8c25f33d85e"/> <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="Center" verticalAlignment="Middle"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <textFieldExpression> <![CDATA[$P{P_LIST_TXT}]]> </textFieldExpression> </textField> <textField> <reportElement x="2" y="0" width="550" height="19" uuid="eae8be87-b008-4b69-b070-523668a523ce"/> <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="Center" verticalAlignment="Middle"> <font fontName="Arial" size="14" isBold="true"/> </textElement> <textFieldExpression> <![CDATA[$P{P_CAMPUS}]]> </textFieldExpression> </textField> <textField> <reportElement x="235" y="40" width="90" height="19" uuid="9cc7c015-9978-470f-9f4b-916627656654"/> <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="Center"> <font fontName="Arial"/> </textElement> <textFieldExpression> <![CDATA["Term: " + $P{P_TERM}]]> </textFieldExpression> </textField> </band> </title> <pageFooter> <band height="30" splitType="Stretch"> <textField pattern="MMMMM dd, yyyy"> <reportElement x="10" y="0" width="100" height="30" uuid="b854fb59-d02d-42f3-96ed-756746d1304d"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression> <![CDATA[new java.util.Date()]]> </textFieldExpression> </textField> <textField pattern="HH:mm"> <reportElement x="110" y="0" width="100" height="30" uuid="79032c7e-d444-4961-9be4-5a88e1d08958"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression> <![CDATA[new java.util.Date()]]> </textFieldExpression> </textField> <textField> <reportElement x="410" y="0" width="100" height="30" uuid="715db46e-00fb-4d7d-a896-7a1be46979f6"/> <textElement textAlignment="Right"> <font fontName="Arial"/> </textElement> <textFieldExpression> <![CDATA["Page " + $V{PAGE_NUMBER}]]> </textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="510" y="0" width="40" height="30" uuid="240b846b-7bd7-42fb-b372-d0ca8688e8e1"/> <textElement textAlignment="Left"> <font fontName="Arial"/> </textElement> <textFieldExpression> <![CDATA[" of " + $V{PAGE_NUMBER}]]> </textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="180" splitType="Stretch"> <frame> <reportElement positionType="Float" x="77" y="0" width="400" height="180" uuid="464f91c6-9689-48bc-8b9e-74bc8c1d9770"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/> </reportElement> <crosstab> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="400" height="180" uuid="e6fe7e65-438a-478c-9cab-a41e535e5796"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/> <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/> <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/> <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/> </reportElement> <crosstabHeaderCell> <cellContents> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/> <staticText> <reportElement x="0" y="0" width="50" height="20" uuid="5e4a0473-2900-40d4-9b3e-b2850bcf8a6c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="10" isBold="true"/> </textElement> <text><![CDATA[s#]]></text> </staticText> <staticText> <reportElement x="50" y="0" width="50" height="20" uuid="d52e1fad-5935-493e-b624-5385658ef051"/> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[ Reg # / Installment #]]></text> </staticText> </cellContents> </crosstabHeaderCell> <rowGroup name="REG_NBR" width="100" totalPosition="End"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{REG_NBR}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/> <textField isStretchWithOverflow="true"> <reportElement stretchType="RelativeToTallestObject" x="50" y="0" width="50" height="20" uuid="0019039e-f6e2-4d9d-8604-7eec385d17c5"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Arial" size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[" "+$V{REG_NBR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="50" height="20" uuid="82cf3538-194a-4219-904d-e5cb32dee202"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="10"/> </textElement> <textFieldExpression> <![CDATA[$V{S_NO_MEASURE}]]> </textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents mode="Transparent" style="Crosstab_CT"> <box> <topPen lineWidth="1.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> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="EVENT_NBR" height="20" totalPosition="End"> <bucket class="java.math.BigDecimal"> <bucketExpression><![CDATA[$F{EVENT_NBR}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="01b691e8-bb9a-4f48-970d-494f2bc66b60"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="10" isBold="true"/> </textElement> <textFieldExpression> <![CDATA[$V{EVENT_NBR}]]> </textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Transparent" style="Crosstab_CT"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="S_NO_MEASURE" class="java.math.BigDecimal"> <measureExpression><![CDATA[$F{S_NO}]]></measureExpression> </measure> <measure name="D_AMT_MEASURE" class="java.lang.String"> <measureExpression><![CDATA[$F{D_AMT}]]></measureExpression> </measure> <crosstabCell width="60" height="20"> <cellContents mode="Opaque" style="Crosstab_CD"> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement x="0" y="0" width="60" height="20" uuid="865cdc27-480f-442a-840b-cb04f6fa3f87"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="10"/> </textElement> <textFieldExpression> <![CDATA[($V{D_AMT_MEASURE}==null?"0":$V{D_AMT_MEASURE}).toString().equals("0")?"X":$V{D_AMT_MEASURE}.toString()]]> </textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" columnTotalGroup="EVENT_NBR"> <cellContents mode="Transparent" style="Crosstab_CT"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="REG_NBR"> <cellContents mode="Transparent" style="Crosstab_CT"> <box> <topPen lineWidth="1.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> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="REG_NBR" columnTotalGroup="EVENT_NBR"> <cellContents mode="Transparent" style="Crosstab_CT"> <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> </cellContents> </crosstabCell> </crosstab> </frame> </band> </summary></jasperReport>[/code]ERROR: net.sf.jasperreports.engine.JRException: java.lang.NullPointerException at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:548) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:523) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:404) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: java.lang.NullPointerException at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.setGroupMeasureVariables(JRFillCrosstab.java:2946) at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.prepareColumnHeader(JRFillCrosstab.java:2101) at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.fillColumnHeaders(JRFillCrosstab.java:1832) at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.fillVerticalCrosstab(JRFillCrosstab.java:1546) at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.fill(JRFillCrosstab.java:1470) at net.sf.jasperreports.engine.fill.JRFillCrosstab.prepare(JRFillCrosstab.java:805) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:536) at net.sf.jasperreports.engine.fill.JRFillFrame.prepare(JRFillFrame.java:241) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:536) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1066) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1025) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:122) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:582) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at java.lang.Thread.run(Thread.java:745)[/code]