aspose file tools*
The moose likes Other Java Products and Servers and the fly likes Failed to export report  with subreport using CrystalReports in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Failed to export report  with subreport using CrystalReports in java" Watch "Failed to export report  with subreport using CrystalReports in java" New topic
Author

Failed to export report with subreport using CrystalReports in java

Maria del Carmen Castillo MArtini
Greenhorn

Joined: Oct 22, 2004
Posts: 3
Hi,
I have many reports in Crystal Reports X11 that I put into java using the JRC and exporting them to PDF and those work ok, but I tried to add a new report using subreports like this:

ISubreportClientDocument subRep = reportClientDoc.getSubreportController().getSubreport(rpts.get(i).toString());
ResultSet resultSet1 = sql.getResultSet(querys.get(i).toString());
String table1 = subRep.getDatabaseController().getDatabase().getTables().getTable(0).getName();
//Push the Java Resultset into the report. This will then become the datasource of the report when the report itself is generated.
subRep.getDatabaseController().setDataSource(resultSet1, table1 , "resultTbl"+i);

and it throws me:

Failed to export report
com.crystaldecisions.reports.exportinterface.exceptions.ExportException: No se pudo crear el controlador

when I look at the log, it looks like it could generate the report, but when It tries to export to pdf fails.

The log is as follows:


(dataengine.datasource ? ) End reading from database
(dataengine.datasource ? ) Close rowset
(dataengine.datasource ? ) Finished running the first pass
(reports.dataengine ? ) Creating new data source
(reports.dataengine ? ) Create new report state
(dataengine.datasource ? ) Failed to create controller
(formatter.objectformatter ? ) com.crystaldecisions.reports.dataengine.a1: No se pudo crear el controlador
(disk.b ? ) Disk Exporter: finalizing export to destination
(reportengineinterface.Engine ? ) Failed to export report
com.crystaldecisions.reports.exportinterface.exceptions.ExportException: No se pudo crear el controlador
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.exportinterface.exceptions.ExportException.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.a.b.a(Unknown Source)
at com.crystaldecisions.reports.reportengineinterface.g.a(Unknown Source)
at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.export(Unknown Source)
at com.crystaldecisions.report.web.event.bn.a(Unknown Source)
at com.crystaldecisions.report.web.event.u.a(Unknown Source)
at com.crystaldecisions.report.web.event.b1.broadcast(Unknown Source)
at com.crystaldecisions.report.web.event.as.a(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.if(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)
at com.crystaldecisions.report.web.viewer.ReportExportControl.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)
at _reportes._jsps._VisorReportes._jspService(_VisorReportes.java:117)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:60)
at oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:662)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:370)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:629)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:218)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:119)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.crystaldecisions.reports.formatter.formatter.c: No se pudo crear el controlador
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.c.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bn.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bn.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.a8.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.a8.goto(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.i.goto(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.a8.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bl.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bn.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bn.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.a9.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bu.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bl.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b0.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.a4.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.l.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bu.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.l.for(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bl.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.o.h(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.o.long(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.o.h(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.d.o.aA(Unknown Source)
at com.crystaldecisions.reports.formatter.a.b.a(Unknown Source)
... 31 more
Caused by: com.crystaldecisions.reports.dataengine.a1: No se pudo crear el controlador
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.common.be.<init>(Unknown Source)
at com.crystaldecisions.reports.dataengine.a1.<init>(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.lc(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.<init>(Unknown Source)
at com.crystaldecisions.reports.dataengine.i.do(Unknown Source)
at com.crystaldecisions.reports.dataengine.i.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.a5.if(Unknown Source)
at com.crystaldecisions.reports.dataengine.a5.a(Unknown Source)
... 61 more
Caused by: com.crystaldecisions.reports.saveddata.c: No existe el campo de condici´┐Żn para este orden: ascending
at com.crystaldecisions.reports.saveddata.a.g.if(Unknown Source)
at com.crystaldecisions.reports.saveddata.a.a(Unknown Source)
at com.crystaldecisions.reports.saveddata.e.a(Unknown Source)
at com.crystaldecisions.reports.saveddata.e.a(Unknown Source)
... 67 more
(reportengineinterface.JPEReportSource ? ) Exception while processing export request: No se pudo crear el controlador
(reportengineinterface.JPEReportSource ? ) Releasing license
(reportengineinterface.JPEReportSource ? ) The report source timed out and will be disposed
(reportengineinterface.Engine ? ) Engine has been disposed
(reportengineinterface.JPEReportSource ? ) The report source has been disposed

The code I use to export is as follows:

ReportExportControl control = new ReportExportControl();
ExportOptions exportOptions = new ExportOptions();
IPDFExportFormatOptions opts = new PDFExportFormatOptions();
exportOptions.setExportFormatType(ReportExportFormat.PDF);
opts.setStartPageNumber(1);
opts.setEndPageNumber(10000);
exportOptions.setFormatOptions(opts);
Object reportSource = session.getAttribute("reportSource");
control.setExportOptions(exportOptions);
control.setReportSource(reportSource);
control.setEnableParameterPrompt(false);
control.refresh();
System.out.println("isOwnPage: "+control.isOwnPage());
control.processHttpRequest(request, response, application, pageContext.getOut());

Help me please!!!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Failed to export report with subreport using CrystalReports in java