Jump to content
We've recently updated our Privacy Statement, available here ×

Getting NULL POINTER Exception on Jaspersoft Studio 6.3.1 but don't know where!!!


zain.imtiaz

Recommended Posts

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]

 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...