Skip to Content
0
Former Member
May 14, 2009 at 12:55 AM

Linking Parameters to sub report from main report.

173 Views

When we link a formula in a main report to a sub report parameter and then use the sub report parameter in a SQL Command to an Oracle database, the Crystal Report works in Crystal Reports 2008 but not in CRFE 2.0 SP1. Please help how to do this. I'm restoring the sub report links after changing the database connection info as per Ted's advice in another thread. Please note that I can see and print the parameters being passed in the sub report. It's only that I can not use it in the SQL command.

We get the following exception

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

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at com.hyperformix.athens.crystal.CrystalReportEngine.exportCrystalReport(CrystalReportEngine.java:261)

... 11 more

Caused by: java.lang.NullPointerException

at com.crystaldecisions.reports.reportdefinition.ParameterFieldDefinition.qJ(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.ParameterFieldDefinition.qL(Unknown Source)

at com.crystaldecisions.reports.dataengine.f.hH(Unknown Source)

at com.crystaldecisions.reports.dataengine.f.S(Unknown Source)

at com.crystaldecisions.reports.dataengine.f.hN(Unknown Source)

at com.crystaldecisions.reports.dataengine.DataSourceManager.int(Unknown Source)

at com.crystaldecisions.reports.dataengine.DataSourceManager.a(Unknown Source)

at com.crystaldecisions.reports.dataengine.DataSourceManager.if(Unknown Source)

at com.crystaldecisions.reports.dataengine.y.byte(Unknown Source)

at com.crystaldecisions.reports.dataengine.y.equals(Unknown Source)

at com.crystaldecisions.reports.dataengine.i.if(Unknown Source)

at com.crystaldecisions.reports.dataengine.i.do(Unknown Source)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.if(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatterBase.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(Unknown Source)

at com.crystaldecisions.reports.formatter.export2.a.a(Unknown Source)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(Unknown Source)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(Unknown Source)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(Unknown Source)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(Unknown Source)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.businessobjects.sdk.erom.jrc.a.a(Unknown Source)

at com.businessobjects.sdk.erom.jrc.a.execute(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ds.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

Edited by: balaji va on May 14, 2009 2:55 AM