OAF开发中使用crystal report

1. 下载crystal report for java解压后将目录crystalreportviewers复制到jdevhome/jdev/myhtml/OA_HTML，将目录lib中的jar文件加入JDeveloper工程文件的库文件中。

2. web.xml 在<web-app>中间添加，主要是读入crystalreportviewers

　 <context-param>
    <param-name>crystal_image_uri</param-name>
    <param-value>crystalreportviewers</param-value>

   </context-param>
    <context-param>
        <param-name>crystal_image_use_relative</param-name>
        <param-value>webapp</param-value>

   </context-param>

 

 

3. CrystalReportEngine-config.xml (jdevhome/jdev/myhtml/OA_HTML/WEB-INF)文件如下：

<?xml version="1.0" encoding="utf-8"?>
<CrystalReportEngine-configuration>
     <reportlocation>..</reportlocation>
     <timeout>10</timeout>
<keycode>your key</keycode>
</CrystalReportEngine-configuration>

 

4.  将文件test.rpt复制到目录jdevhome/jdev/myclasses

5. test.jsp文件如下：

<%@ page
  language    = "java"
  errorPage   = "OAErrorPage.jsp"
  contentType = "text/html" 
  import      = "com.crystaldecisions.ReportViewer.*,
                com.crystaldecisions.reports.reportengineinterface.*,
                com.crystaldecisions.report.web.viewer.*,
                com.crystaldecisions.sdk.occa.report.exportoptions.*,
                com.crystaldecisions.sdk.occa.report.reportsource.*,
                com.crystaldecisions.reports.sdk.*,"           
%>
<%
   CrystalReportViewer crv = new CrystalReportViewer();
   JPEReportSourceFactory jrsf = new JPEReportSourceFactory();
   crv.setReportSource(jrsf.createReportSource("test.rpt",request.getLocale()));
   crv.processHttpRequest(request,response,application,null);
%>

 

 

6. 在web.xml文件中加入如下内容（支持报表导出到PDF等文件）：

   <servlet id="CrystalReportViewerServlet">
        <servlet-name>CrystalReportViewerServlet</servlet-name>
        <display-name>CrystalReportViewerServlet</display-name>
        <servlet-class>
                com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet
        </servlet-class>
        <load-on-startup>1</load-on-startup>
   </servlet>
 
   <servlet-mapping id="CrystalReportViewerServletMapping">
        <servlet-name>CrystalReportViewerServlet</servlet-name>
        <url-pattern>/CrystalReportViewerHandler</url-pattern>
   </servlet-mapping>