cancel
Showing results for 
Search instead for 
Did you mean: 

Sub Report not working in Crystal Report 2008 using JSP

Former Member
0 Kudos

I am having developer license of Crystal Report 2008. I am able to generate report using Java JDK 1.5 , JSP,Oracle10g , deployed on WebSphere Application Server 6.1.0.29. I am not able to generate Sub reports. Can you please help us with sample code to how to call and configure subreport and please send configuration CRConfig.xml.

The below Error is Occurred on generating report.

On condition when we link the main report to subreport through parameter.

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: java.lang.NullPointerException---- Error code:-2147467259 Error code name:failed

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:741)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(SourceFile:767)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(SourceFile:324)

at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.getPage(SourceFile:149)

at com.businessobjects.report.web.event.s.a(SourceFile:158)

at com.businessobjects.report.web.event.s.a(SourceFile:127)

at com.businessobjects.report.web.event.bt.a(SourceFile:47)

at com.businessobjects.report.web.event.bw.broadcast(SourceFile:93)

at com.businessobjects.report.web.event.am.a(SourceFile:53)

at com.businessobjects.report.web.a.t.if(SourceFile:2104)

at com.businessobjects.report.web.e.a(SourceFile:300)

at com.businessobjects.report.web.e.a(SourceFile:202)

at com.businessobjects.report.web.e.a(SourceFile:135)

at com.crystaldecisions.report.web.ServerControl.a(SourceFile:607)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(SourceFile:342)

at com.ibm._jsp._CrystalReportViewer._jspService(_CrystalReportViewer.java:107)

at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1143)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:591)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)

at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)

at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:226)

at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:286)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3453)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:267)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)

at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)

Caused by: java.lang.NullPointerException

at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:84)

at oracle.jdbc.driver.ScrollableResultSet.getMetaData(ScrollableResultSet.java:1282)

at com.crystaldecisions.reports.common.data.JdbcCrystalResultSet.getMetaData(Unknown Source)

at com.businessobjects.reports.jdbinterface.common.ResultSetReader.bindToField(Unknown Source)

at com.crystaldecisions.reports.queryengine.ResultSetRecordReader.a(SourceFile:80)

at com.crystaldecisions.reports.queryengine.Rowset.a(SourceFile:1107)

at com.crystaldecisions.reports.queryengine.Rowset.z9(SourceFile:1025)

at com.crystaldecisions.reports.queryengine.Rowset.Aa(SourceFile:988)

at com.crystaldecisions.reports.queryengine.Rowset.z3(SourceFile:967)

at com.crystaldecisions.reports.queryengine.Rowset.bL(SourceFile:533)

at com.crystaldecisions.reports.queryengine.Rowset.zM(SourceFile:245)

at com.crystaldecisions.reports.queryengine.RowsetBase.zA(SourceFile:156)

at com.crystaldecisions.reports.queryengine.QueryInfo.vE(SourceFile:261)

at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:628)

at com.crystaldecisions.reports.datalayer.a.do(SourceFile:1621)

at com.crystaldecisions.reports.datalayer.a.a(SourceFile:1404)

at com.crystaldecisions.reports.dataengine.m.b(SourceFile:334)

at com.crystaldecisions.reports.dataengine.j.b(SourceFile:515)

at com.crystaldecisions.reports.dataengine.m.o(SourceFile:408)

at com.crystaldecisions.reports.dataengine.m.a(SourceFile:173)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:114)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:95)

at com.crystaldecisions.reports.dataengine.j.case(SourceFile:1080)

at com.crystaldecisions.reports.dataengine.h.<init>(SourceFile:108)

at com.crystaldecisions.reports.dataengine.DataContext.a(SourceFile:254)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4660)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4574)

at com.crystaldecisions.reports.dataengine.DataProcessor2.new(SourceFile:2652)

at com.crystaldecisions.reports.dataengine.DataProcessor2.byte(SourceFile:2610)

at com.crystaldecisions.reports.dataengine.DataProcessor2.try(SourceFile:2282)

at com.crystaldecisions.reports.dataengine.DataProcessor2.int(SourceFile:2442)

at com.crystaldecisions.reports.dataengine.DataProcessor2.I(SourceFile:1013)

at com.crystaldecisions.reports.dataengine.DataProcessor2.if(SourceFile:4816)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:2020)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:309)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:250)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.a(SourceFile:922)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.e(SourceFile:784)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.for(SourceFile:242)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:243)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:210)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:185)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:230)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359

Accepted Solutions (0)

Answers (1)

Answers (1)

aasavaribhave
Advisor
Advisor
0 Kudos

If you are not using latest CRJ ( what used to be JRC) Jars then download and update them from [here|http://downloads.businessobjects.com/akdlm/crystalreportsforeclipse/2_0/crjava-runtime_12.2.211.zip]

Also Look:

[CRJ Samples|http://www.sdn.sap.com/irj/boc/index?rid=/webcontent/uuid/909355da-5b84-2b10-76a4-eed3ccf9e650] [original link is broken];

and

[CRJ Parameter setting Sample|http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/f0c5a1ef-3e11-2c10-e595-f6767ba1c2af]

Edited by: Aasavari Bhave on May 10, 2011 11:36 AM