Solved

Problems exporting report in Crystal Reports 10

Posted on 2004-09-08
12
858 Views
Last Modified: 2009-01-15
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?
0
Comment
Question by:tarekz
  • 7
  • 5
12 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 12008287
Are the exporting dlls installed?

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

mlmcc
0
 
LVL 1

Author Comment

by:tarekz
ID: 12008909
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?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12009224
I am referring to the one in Crystal design mode.

mlmcc
0
 
LVL 1

Author Comment

by:tarekz
ID: 12009550
Ok, then the answer is yes, i am able to export to all the formats available.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12010335
Is the JSP method being run on the same machine or is this on a client?

mlmcc
0
 
LVL 1

Author Comment

by:tarekz
ID: 12010408
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();
%>
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Accepted Solution

by:
mlmcc earned 100 total points
ID: 12011944
I remember reading another question or Crystal link that indicated some of the web viewers are limited in export capability to keep the size of the viewer small.

My understanding with Word and RTF is that they produce the same result in CR10 so you could use the Word option for RTF.

I'll see if I can find the reference.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12012790
0
 
LVL 1

Author Comment

by:tarekz
ID: 12016204
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!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12023358
Are you sure the constants you are using to set the export format are correct including capitalization?

mlmcc
0
 
LVL 1

Author Comment

by:tarekz
ID: 12030999
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.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12031606
Glad I could help

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now