JSP pass paramer to RPT(cristal report)

本文链接：https://blog.youkuaiyun.com/morwind_01/article/details/875645

本文档提供了一个关于如何集成 Crystal Report 到 Web 应用的详细步骤指南，包括下载必要的组件、创建报告模板、设置数据库连接以及配置 JSP 页面来显示报告等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、Google and download cr4e-all-in-one-BETA-win32

2、Create <Cristal Report Blank Report >

3、set <Datebase Explore> (As Jdbc connection)

4、copy the test.jsp

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<%@ page
import="com.crystaldecisions.report.web.viewer.*,
com.crystaldecisions.sdk.occa.report.data.*"%>
<%@ page
import="com.crystaldecisions.reports.reportengineinterface .JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource. IReportSourceFactory2,
com.crystaldecisions.sdk.occa.report.reportsource. IReportSource"%>

<%
String report;

report = "CrystalReport1.rpt";

IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
IReportSource reportSource = (IReportSource)
rptSrcFactory.createReportSource(report, request.getLocale());

//*try to set a parameter source
Fields fields = new Fields();

ParameterField pfield1 = new ParameterField();
Values vals1 = new Values();
ParameterFieldDiscreteValue pfieldDV1 = new ParameterFieldDiscreteValue();
pfield1.setName("user");
pfieldDV1.setValue("smily");
pfieldDV1.setDescription("RPTCOMM type of report");
vals1.add(pfieldDV1);
pfield1.setCurrentValues(vals1);
fields.add(pfield1);

ParameterField pfield2 = new ParameterField();
Values vals2 = new Values();
ParameterFieldDiscreteValue pfieldDV2 = new ParameterFieldDiscreteValue();
pfield2.setName("pro");
pfieldDV2.setValue("P002 MIS2");
pfieldDV2.setDescription("P002 MIS2");
vals2.add(pfieldDV2);
pfield2.setCurrentValues(vals2);
fields.add(pfield2);

CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);

viewer.setParameterFields(fields);
viewer.setEnableParameterPrompt(false);

viewer.refresh();

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

viewer.dispose();
%>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

5、create <CrystalReport1.rpt> , set param <pro> and <user>

6、Run the test <run on server>