示例

下例是一个 JSP 页面,它演示了如何为报表设置数据库登录信息。设置了登录信息后,即会显示报表。

注意:    对于与本教程示例一起使用的任何报表,您必须配置了适当的 JDBC 数据源,以便应用程序服务器能访问它。本例中使用的报表未随附于教程中。

setDbLogonViewReport.jsp

<%@ page import="com.crystaldecisions.report.web.viewer.*" %>

<%@ page import="com.crystaldecisions.sdk.occa.report.data.*"  %>

<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>

<%@ page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>


<%

    Object reportSource = session.getAttribute("reportSource");

    if (reportSource == null)

    {

String report = "/reports/sample.rpt";

        IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();

        reportSource = rptSrcFactory.createReportSource(report, request.getLocale());

        session.setAttribute("reportSource", reportSource);

    }

    

ConnectionInfos connInfos = new ConnectionInfos();


   IConnectionInfo connInfo1 = new ConnectionInfo();


connInfo1.setUserName("guest");

connInfo1.setPassword("password");


connInfos.add(connInfo1);


CrystalReportViewer viewer = new CrystalReportViewer();

viewer.setReportSource(reportSource);

   viewer.setEnableLogonPrompt(false);  

viewer.setDatabaseLogonInfos(connInfos);

    

    if (session.getAttribute("refreshed") == null)

    {

viewer.refresh();

session.setAttribute("refreshed", "true");

    }

    

    viewer.setOwnPage(true);

    viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);

%>



Business Objects
http://www.china.businessobjects.com

支持服务
http://www.china.businessobjects.com