Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Business objects, Crystal Reports, XI Developer

I am using Crystal Reports Java Viewer  on IE to show reports. But I can only export web report to PDF format by default, how can I export to MS Excel format?
0
craigyang
Asked:
craigyang
  • 6
  • 3
1 Solution
 
mlmccCommented:
Do you have the Excel export dlls installed?

mlmcc
0
 
craigyangAuthor Commented:
I have the following dlls placed on my development lib directory but still only shown the default PDF format!
Database drivers (P2*.dll)
Export drivers (U2f*.dll and U2d*.dll)
User-defined Function Library (UFL) drivers (U2L*.dll)
0
 
mlmccCommented:
What version of Crystal?

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Sorry.  I see you have CR XI.

The Excel export dll is named differently.  I think it is CRXF_XLS

They have to be in a specific directory 9not your dev directory) and they need to be registered.

mlmcc
0
 
craigyangAuthor Commented:
Do you know where in Oracle jDeveloper version 10 should I place CRXF_XLS.dll and how to register?
0
 
mlmccCommented:
When you install Crystal, the dlls should be installed where Crystal wants them.  The install should also register them.

IN my instal they are l;ocated in
C:\Program Files\Common Files\Business Objects\3.0\bin

mlmcc
0
 
craigyangAuthor Commented:
I have excel dll installed by still doesn't show export option for MS Excel on JSP. Need to do some programming adjustments? My code is as follows :

//set the CrystalReportViewer print mode
oCrystalReportViewer.setPrintMode(CrPrintMode.ACTIVEX);
...
oCrystalReportViewer.processHttpRequest(request, response,getServletConfig().getServletContext(), out);
...
0
 
mlmccCommented:
Check this question.  There is a link to a comment that indicates you can't export to Excel from a JSP application

( http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_22865557.html )

I haven't been able to verify the statement but if you have the export dlls loaded it may be true.

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now