Crystal Report XI problem while accessing sub reprots through Java code
I am getting follwoing exception while accessing sub reprots from Crystal Rerpot XI server.Same code works properly when i configure it to Crystal Report IX or X
Following is the code which is throwing exception
clientDoc.getSubreportController().setDataSource(subReportName, resultSet,subReportTableName,IConstants.OLD_REPORT_NAME);
Follwoing Exception is thrown by setDataSource() :
2009-02-26 03:42:33,196 INFO [STDOUT] com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException:
No error.---- Error code:-2147483648 Error code name:failed
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.proxy.remoteagent.t.a(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.do(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.verifyDatabase(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.bl.try(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.ao.onDataSourceChanged(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.crystaldecisions.sdk.occa.report.application.SubreportController.setDataSource(Unknown Source)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.one.csf.reports.handlers.ReportWriter.processTTXsubreport(ReportWriter.java:591)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.one.csf.reports.handlers.ReportWriter.processReport(ReportWriter.java:368)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.eds.web.action.CampaignDetailDisplayReport.execute(CampaignDetailDisplayReport.java:181)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
2009-02-26 03:42:33,196 INFO [STDOUT] at net.sf.struts.saif.SAIFTilesRequestProcessor.processActionPerform(SAIFTilesRequestProcessor.java:99)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
2009-02-26 03:42:33,196 INFO [STDOUT] at com.one.csf.struts.action.OneActionServlet.process(OneActionServlet.java:349)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
2009-02-26 03:42:33,196 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
2009-02-26 03:42:33,196 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2009-02-26 03:42:33,196 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,274 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:139)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
2009-02-26 03:42:33,290 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
2009-02-26 03:42:33,290 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
Please help me with this. Is there any change i need to make while configuring Crystal Report Xi server for TTX based sub reprots so that it can be accessed from Java code. Or is there any other way to access sub reports in Crystal Report XI from API point of view.
Edited by Mayank R - 23 Dec 2009 at 11:50pm