水晶报新表培训课件

J2EE报表（报表（RPT）模块培训）模块培训 Crystal Report 开发篇开发篇Introduction To Crystal ReportsCrystal Reports is designed to work with your database to help you analyze and interpret important information.Crystal Reports makes it easy to create simple reports,and,it also has the comprehensive tools you need to produce complex or specialized reports.Learing how to use Crystal ReportsStart Crystal Reports to create a reportChoose using expert or blank report,then click OKSpecify data source for reportConnect to databaseChoose tables for report1.Choose lot_step_history.2.Click Add.3.Click Close.Add fields to report1.Choose one field,right click it,click Insert to Report.2.Move it to the Detail of report.Insert special fields1.Choose one field,right click it,click Insert to Report.2.Move it to reportClick Preview tab to preview reportGrouping DataHow to group data1.Select the field you want the data grouped by.2.Select the sort direction from the drop-down list.3.Click OK.Preview after grouped the data Running totals for a groupHow to run totals for a group1.Select the field you want to run total.2.Select one group.3.Click OK.Adjust the total fieldPreview the resultChartingSelect the type of chart 1.Specify the database fields you want to use as condition.2.Add the database fields you want to use as values to the Show Values list.3.Click OK.Choose data for chart Accept or add title for chartPreview the chartAdd parameter fieldsHow to add parameter1.Enter a name for the parameter in the Name field.2.Enter the desired prompting text in the Prompting text field.3.Select the appropriate Value type from the list.4.Click OK.Using parameter in selection formulaEdit selection formulaPreview report1.Enter the value your want.Introduction To Crystal EnterpriseCrystal Enterprise is a reliable,web-based platform for reporting,analysis and information delivery.Crystal Enterprise works within your existing web infrastructure to enable you to schedule and distribute reports to people who access your intranet or internet site.Architecture Of Crystal Enterprise Web Application(IE 4.01+,NN4.0+)Windows Application Web Server Web Component Server Automated Process Schedule Page Server DatabasesPublishing Reports Report publishing is the process of adding existing reports to the Crystal Enterprise environment and making them available in the web desktop of authorized users.Your are able to determine which reports are added,where they should be located,who should be able to access them,and how often the data should be updated.Start Crystal EnterpriseClick Crystal Management ConsoleInput password,then click Log on buttonClick New ReportChoose a folder,then click Browser button to choose a rpt fileClick OK buttonClick database tab,input password,and click Update bottonClick parameters tab,set value for each parameter,and click Update bottonSummaryAs a outstanding report tool,Crystal Report can provide us strong functions to perfect our reports.Crystal Enterprise combines tools for reporting off relational and multidimensional data with a scalable back end for security,processing,delivery,and repository management.The EndThank you very much!