水晶报表培训全文案例分析电子版

J2EE报表（RPT）模块培训——CrystalReport开发篇IntroductionToCrystalReports•CrystalReportsisdesignedtoworkwithyourdatabasetohelpyouanalyzeandinterpretimportantinformation.•CrystalReportsmakesiteasytocreatesimplereports,and,italsohasthecomprehensivetoolsyouneedtoproducecomplexorspecializedreports.LearinghowtouseCrystalReportsStartCrystalReportstocreateareportChooseusingexpertorblankreport,thenclickOKSpecifydatasourceforreportConnecttodatabaseChoosetablesforreport1.Chooselot_step_history.2.ClickAdd.3.ClickClose.Addfieldstoreport1.Chooseonefield,rightclickit,clickInserttoReport.2.MoveittotheDetailofreport.Insertspecialfields1.Chooseonefield,rightclickit,clickInserttoReport.2.MoveittoreportClickPreviewtabtopreviewreportGroupingDataHowtogroupdata1.Selectthefieldyouwantthedatagroupedby.2.Selectthesortdirectionfromthedrop-downlist.3.ClickOK.PreviewaftergroupedthedataRunningtotalsforagroupHowtoruntotalsforagroup1.Selectthefieldyouwanttoruntotal.2.Selectonegroup.3.ClickOK.AdjustthetotalfieldPreviewtheresultChartingSelectthetypeofchart1.Specifythedatabasefieldsyouwanttouseascondition.2.AddthedatabasefieldsyouwanttouseasvaluestotheShowValueslist.3.ClickOK.ChoosedataforchartAcceptoraddtitleforchartPreviewthechartAddparameterfieldsHowtoaddparameter1.EnteranamefortheparameterintheNamefield.2.EnterthedesiredpromptingtextinthePromptingtextfield.3.SelecttheappropriateValuetypefromthelist.4.ClickOK.UsingparameterinselectionformulaEditselectionformulaPreviewreport1.Enterthevalueyourwant.IntroductionToCrystalEnterprise•CrystalEnterpriseisareliable,web-basedplatformforreporting,analysisandinformationdelivery.•CrystalEnterpriseworkswithinyourexistingwebinfrastructuretoenableyoutoscheduleanddistributereportstopeoplewhoaccessyourintranetorinternetsite.ArchitectureOfCrystalEnterpriseWebApplication(IE4.01+,NN4.0+)WindowsApplicationWebServerWebComponentServerAutomatedProcessSchedulePageServerDatabasesPublishingReports•ReportpublishingistheprocessofaddingexistingreportstotheCrystalEnterpriseenvironmentandmakingthemavailableinthewebdesktopofauthorizedusers.•Yourareabletodeterminewhichreportsareadded,wheretheyshouldbelocated,whoshouldbeabletoaccessthem,andhowoftenthedatashouldbeupdated.StartCrystalEnterpriseClickCrystalManagementConsoleInputpassword,thenclickLogonbuttonClickNewReport…Chooseafolder,thenclickBrowserbuttontochoosearptfileClickOKbuttonClickdatabasetab,inputpassword,andclickUpdatebottonClickparameterstab,setvalueforeachparameter,andclickUpdatebottonSummary•Asaoutstandingreporttool,CrystalReportcanprovideusstrongfunctionstoperfectourreports.•CrystalEnterprisecombinestoolsforreportingoffrelationalandmultidimensionaldatawithascalablebackendforsecurity,processing,delivery,andrepositorymanagement.TheEndThankyouverymuch!