Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Problems exporting report in Crystal Reports 10

Posted on 2004-09-08
12
Medium Priority
?
880 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 101

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 101

Expert Comment

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

mlmcc
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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 101

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
 
LVL 101

Accepted Solution

by:
mlmcc earned 400 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 101

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 101

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 101

Expert Comment

by:mlmcc
ID: 12031606
Glad I could help

mlmcc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 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