slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Java 水晶报表 PowerPoint Presentation
Download Presentation
Java 水晶报表

Loading in 2 Seconds...

play fullscreen
1 / 50

Java 水晶报表 - PowerPoint PPT Presentation


  • 188 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Java 水晶报表' - audra-lyons


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide2
目录
  • 水晶报表开发(CrystalReports 2008)
  • Java水晶报表(JBuilder 2005)
  • 报表项目布署(WebSphere v6.1)
slide3
水晶报表开发
  • Crystal Reports 的设计用途是,使用数据库来帮助您分析和解释重要的信息。Crystal Reports 可以方便地创建简单的报表,并且,它还拥有生成复杂报表或专用报表所需的一整套工具。
  • 创建所能想象的任何报表, Crystal Reports几乎可以从任何数据源生成您所需要的报表。内置报表专家在您生成报表和完成一般的报表任务过程中,会一步一步地指导您进行操作。报表专家通过公式、交叉表、子报表和设置条件格式帮助表现数据的实际意义,揭示可能被隐藏掉的重要关系。如果文字和数字确实不够充分,则用地理地图和图形进行形象的信息交流。
slide4
将报表并入应用程序,通过将 Crystal Reports 的报表处理功能整合到自己的数据库应用程序中,应用程序和 Web 开发人员可以节省开发时间并满足用户的需求。支持大多数流行的开发语言,可以方便地在任何应用程序中添加报表。无论您是 IT 行业的站点管理员,还是营销推广经理,也无论您是金融业的数据库管理员还是 CEO,Crystal Reports 都堪称是一个功能强大的工具,它可以帮助每一个人分析并解释重要的信息。
crconfig xml
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>

slide27
Java水晶报表
  • JBuilder x
  • Crystal Reports for Borland JBuilder
slide30
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

slide31
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");
slide32
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();
slide33
参数
  • 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
slide34
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);
slide35
报表标签
  • <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>
slide39
项目布署
  • Websphere v6.1
  • Weblogic *