1 / 50

Java 水晶报表

Java 水晶报表. 目录. 水晶报表开发 (CrystalReports 2008) Java 水晶报表 (JBuilder 2005) 报表项目布署 (WebSphere v6.1). 水晶报表开发. Crystal Reports 的设计用途是，使用数据库来帮助您分析和解释重要的信息。 Crystal Reports 可以方便地创建简单的报表，并且，它还拥有生成复杂报表或专用报表所需的一整套工具。

audra-lyons
Download Presentation

Java 水晶报表

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Java水晶报表

  2. 目录 • 水晶报表开发(CrystalReports 2008) • Java水晶报表(JBuilder 2005) • 报表项目布署(WebSphere v6.1)

  3. 水晶报表开发 • Crystal Reports 的设计用途是，使用数据库来帮助您分析和解释重要的信息。Crystal Reports 可以方便地创建简单的报表，并且，它还拥有生成复杂报表或专用报表所需的一整套工具。 • 创建所能想象的任何报表， Crystal Reports几乎可以从任何数据源生成您所需要的报表。内置报表专家在您生成报表和完成一般的报表任务过程中，会一步一步地指导您进行操作。报表专家通过公式、交叉表、子报表和设置条件格式帮助表现数据的实际意义，揭示可能被隐藏掉的重要关系。如果文字和数字确实不够充分，则用地理地图和图形进行形象的信息交流。

  4. 将报表并入应用程序，通过将 Crystal Reports 的报表处理功能整合到自己的数据库应用程序中，应用程序和 Web 开发人员可以节省开发时间并满足用户的需求。支持大多数流行的开发语言，可以方便地在任何应用程序中添加报表。无论您是 IT 行业的站点管理员，还是营销推广经理，也无论您是金融业的数据库管理员还是 CEO，Crystal Reports 都堪称是一个功能强大的工具，它可以帮助每一个人分析并解释重要的信息。

  5. 报表开发示例

  6. CRConfig.xml • Installer Path\Business Objects\Common\4.0\java • <Classpath>E:\Program Files\Business Objects\Common\4.0\java/lib/crlovmanifest.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/CRLOVExternal.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/CRDBJDBCServer.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/CRDBXMLServer.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/CRDBJavaBeansServer.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/external/CRDBXMLExternal.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/external/log4j.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/CRDBSForceServer.jar;E:\Program Files\Business Objects\Common\4.0\java/lib/external/CRDBSForceExternal.jar;E:\oracle\ora921\jdbc\lib\ojdbc14.jar;E:\oracle\ora921\jdbc\lib\classes12.jar;${CLASSPATH} </Classpath> • <JDBCURL>jdbc:oracle:thin:@HostName:Port:SID</JDBCURL> <JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName> <JDBCUserName>scott</JDBCUserName>

  7. 数据源配置

  8. Java水晶报表 • JBuilder x • Crystal Reports for Borland JBuilder

  9. Jsp显示 com.crystaldecisions.report.web.viewer. CrystalReportViewer, com.crystaldecisions.report.web.viewer.CrPrintMode, com.crystaldecisions.sdk.occa.report.data. ConnectionInfos, com.crystaldecisions.sdk.occa.report.data. ConnectionInfo, com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory, com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2, com.crystaldecisions.sdk.occa.report.reportsource.IReportSource

  10. String path="WEB-INF/DbReport.rpt"; • IReportSourceFactory2 rsf = new JPEReportSourceFactory(); • java.util.Locale localetest = java.util.Locale.CHINA; • IReportSource rptSource = (IReportSource)rsf.createReportSource(path,localetest); • ConnectionInfos connInfos = new ConnectionInfos(); • IConnectionInfo connInfo1 = new ConnectionInfo(); • connInfo1.setUserName("soctt"); • connInfo1.setPassword("tiger");

  11. CrystalReportViewer viewer = new CrystalReportViewer(); • viewer.setReportSource(rptSource); • viewer.setDatabaseLogonInfos(connInfos); • viewer.setOwnPage(true); • viewer.setOwnForm(true); • viewer.setPrintMode(CrPrintMode.ACTIVEX); • viewer.setHasExportButton(true); • viewer.setHasPrintButton(true); • viewer.setHasLogo(true); • rptSource.refresh(); • viewer.processHttpRequest(request, response,getServletConfig().getServletContext(), out); • viewer.refresh(); • viewer.dispose(); • rptSource.dispose();

  12. 参数 • com.crystaldecisions.sdk.occa.report.data.Field, • com.crystaldecisions.sdk.occa.report.data. ParameterField • com.crystaldecisions.sdk.occa.report.data.Value • com.crystaldecisions.sdk.occa.report.data.ParameterFieldDiscreteValue

  13. Fields fields = new Fields(); • ParameterField pfield1 = new ParameterField(); • Values vals1 = new Values(); • ParameterFieldDiscreteValue pfieldDV1 = new ParameterFieldDiscreteValue(); • java.sql.Date ksrq = java.sql.Date.valueOf("2007-10-20"); • pfield1.setName("ksrq"); • pfieldDV1.setValue(ksrq); • vals1.add(pfieldDV1); • pfield1.setCurrentValues(vals1); • fields.add(pfield1); • viewer.setParameterFields(fields);

  14. 报表标签 • <crviewer:viewer • viewerName="prtdw1" • reportSourceVar="_prtdw1" • reportSourceType="reportingComponent" • isOwnPage="true" • allowParameterPrompting="true" • displayToolbar="true" • displayToolbarExportButton="true" • displayToolbarPrintButton="true" • displayToolbarFindPageButton="true" • displayToolbarRefreshButton="true" • displayToolbarToggleTreeButton="true" • displayToolbarViewList="true" • displayToolbarZoomList="true" • enablePageToGrow="false" • groupTreeWidthUnit="percent" • displayGroupTree="false" • displayPage="true" • allowDrillDown="false" • allowDatabaseLogonPrompting="true" • printMode="ActiveX" • displayToolbarCrystalLogo="true"> • <crviewer:report reportName="/WEB-INF/DbReport.rpt"/> • </crviewer:viewer>

  15. 导出

  16. 项目布署 • Websphere v6.1 • Weblogic *

  17. 上下文根:http://localhost:9680/datang/

More Related