Export a report to excel (using JRC)

[Former Member]

Post Author: guyi

CA Forum: JAVA

hi,I am using JRC to open and view a report in my java application.

I tried to export a report to excel format without any success, for that I am using the ReportExportControl as you can see in the below scrap of code: IReportSource reportSource= (IReportSource) session.get(request).get("reportSource"); ReportExportControl exportControl = new ReportExportControl(); ExportOptions exportOptions = new ExportOptions(); exportOptions.setExportFormatType(ReportExportFormat.MSExcel); exportControl.setReportSource(reportSource); exportControl.setExportOptions(exportOptions); exportControl.setExportAsAttachment(true); String htmlContent = exportControl.getHtmlContent(request, response, request.getSession().getServletContext());Am I doing something wrong here?Any idea?Thanks in advanceGuy

[Former Member]

Post Author: guyi

CA Forum: JAVA

Hi Ted, thanks very much for your response.I have two questions:You mentioned that 'Excel export format support is on the roadmap for Crystal Reports for Eclipse', do you have any idea what is the release date? Export to excel is crucial for our application.I am using JRC to open and view a reports in my java application, (I

want to emphasize that I use crystal report 10 in order

to create and update reports and not through any java IDE (such as

eclipse)). Should I use the JRC from the eclipse plugin? Or should I get it from Crystal Reports XI Release 2? it seems to me that there are more than 1 way to gain the JRC is it correct? which one is better?Thanks in advance, Guy

[Former Member]

Post Author: Ted Ueda

CA Forum: JAVA

The post you're referring to is using the Report Application Server - the ReportClientDocument there is in a different package from that in the JRC - it's part of the Report Application Server Java SDK.

The RAS uses a server-client architecture, where requests from the Java client are sent to the RAS server, where the export format is created. The JRC is a 100% pure Java code where export formats are created in-process.

Although the JRC and the RAS SDK share some libraries, they don't share the backend engine.

Sincerely,

Ted Ueda

[Former Member]

Post Author: guyi

CA Forum: JAVA

Ted, thanks very much for your quick response.Yet I have a question, few days ago I noticed a post (

http://technicalsupport.businessobjects.com/cs/forums/thread/8107.aspx) in which the user claims that he succeeded to export a report to excel format (the excel was corrupted but basically he did it).

If this feature is not implemented yet how come it is possible?

Thanks in advance

Guy

[Former Member]

Post Author: Ted Ueda

CA Forum: JAVA

Excel export format support is on the roadmap for Crystal Reports for Eclipse, which is the latest version of the JRC - see http://diamond.businessobjects.com for more info.

The current CR4E JRC supports export to CSV, but not to Excel, format.

Sincerely,

Ted Ueda

[Former Member]

Hello, any release date for a working MSExcel export ?