Link to home
Start Free TrialLog in
Avatar of tarekz
tarekz

asked on

Problems exporting report in Crystal Reports 10

hi,

I am using Crystal Reports 10 (Java Reproting Component).
I made a JSP page to export a rerport to the various available formats.
Only the Word and RTF format are working. All the others (Crystal Reports, Excel, Plain text, etc...) are generating the following exception:

com.crystaldecisions.report.web.viewer.ReportExportControl
Invalid post back event : {0}
 
 
Any ideas?
Avatar of Mike McCracken
Mike McCracken

Are the exporting dlls installed?

Can you export to other formats from the Crystal preview screen?

mlmcc
Avatar of tarekz

ASKER

What is the crystal preview screen? Do you mean the one in the Crystal Reports 10 designer?
Or you are asking about the html page generated by the viewer?
I am referring to the one in Crystal design mode.

mlmcc
Avatar of tarekz

ASKER

Ok, then the answer is yes, i am able to export to all the formats available.
Is the JSP method being run on the same machine or is this on a client?

mlmcc
Avatar of tarekz

ASKER

Ok, let me give all the details..

I am running tomcat 4.1.27 on my Machine (it is the application server for my JSP pages)... I am using only the Java Reporting Component... and the reports are all in the .../WEB-INF/classes directory... Probably i should mention that i am able to view them all in the crystal viewer.

Also here is the code of my exportReport.jsp (as i mentioned before, it is working if i choose Word as the format of the export)

<%
  String report = (String) session.getAttribute("report");

  IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
  IReportSource reportSource = (IReportSource)rptSrcFactory.createReportSource(report, request.getLocale());
  Fields fields = (Fields) session.getAttribute("fields");

  String selectedFormat = (String)session.getAttribute("exportFormat");

  ReportExportControl exportControl = new ReportExportControl();
  ExportOptions exportOptions = new ExportOptions();
  if(selectedFormat.equals("0")/*Crystal Report*/){
      exportOptions.setExportFormatType(ReportExportFormat.crystalReports);
  }
  else if(selectedFormat.equals("1")/*Word*/){
      exportOptions.setExportFormatType(ReportExportFormat.MSWord);
  }
  else if(selectedFormat.equals("2")/*Excel*/){
     exportOptions.setExportFormatType(ReportExportFormat.MSExcel);
  }
  else if(selectedFormat.equals("3")/*Rich Text Format*/){
      exportOptions.setExportFormatType(ReportExportFormat.RTF);
  }
  else if(selectedFormat.equals("5")/*PDF*/){
     exportOptions.setExportFormatType(ReportExportFormat.PDF);
  }
  else if(selectedFormat.equals("6")/*Excel without formatting*/){
      exportOptions.setExportFormatType(ReportExportFormat.recordToMSExcel);
  }
  else if(selectedFormat.equals("7")/*Text*/){
      exportOptions.setExportFormatType(ReportExportFormat.text);
  }
  else if(selectedFormat.equals("8")/*CSV*/){
      exportOptions.setExportFormatType(ReportExportFormat.characterSeparatedValues);
  }
  exportControl.setOwnPage(true);
  exportControl.setOwnForm(true);
  exportControl.setReportSource(reportSource);
  exportControl.setExportOptions(exportOptions);
  exportControl.setExportAsAttachment(true);
  exportControl.setParameterFields(fields);

  exportControl.processHttpRequest(request, response, getServletContext(), out);

  exportControl.dispose();
%>
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tarekz

ASKER

That is true, but they are talking about the export functionality that is within the viewer control itself.
The viewer only supports PDF & RTF. I am using the ReportExportControl which business objects claims it suports all the above mentioned formats (Excel, Word, Crystal Reports, Plain Text, CSV, etc...) except HTML...
Plus the Code i posted is a collection of source code i gathered from the examples they include with their installation.

I dont htink this problem is simple becuase i emailed business objects support and its been 10 days now and they havent replied... :)
I hope you or someone can beat them to the answer!
Are you sure the constants you are using to set the export format are correct including capitalization?

mlmcc
Avatar of tarekz

ASKER

I got word from Crystal Reports That the JRC (Java Reproting Component) only supports RTF and PDF... as we alreay knew, and that even if the ReportExportControl is used, the JRC engine can not handle these other formats.
Glad I could help

mlmcc