• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Failed to export report with subreport using CrystalReports in java

 
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!!!
 
Brace yourself while corporate america tries to sell us its things. Some day they will chill and use tiny ads.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic