四班erp fs750 adhoc报表开发文档

《四班erp fs750 adhoc报表开发文档》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、WelcometoSoftBrandsBalanceforthedemand-drivenworldAd-hocReportChenChenAgenda1.Overview2.WhatisReportBuilder3.FSAd-HocReport4.Startwithasamplereport5.Q&AOverviewAlonghistoryofprovidingcustomerswithvariouswaystoquerytheirFourthShiftdatabase-Inthelate1980’s---------DVUD-Inthemid1

2、990’s--------FourthShiftODBCdriverOverview–Inthelate1990’s--------Microsoft’sTransact-SQLlanguage–Intheearly2000’s---------FBVS.–In2006,SQLServerReportingServicesOverview–SotodaywemakeiteasyforourcustomerstodevelopSQLstatementsinordertocreatetheirownapplications,reports,andad-

3、hocqueriesontopoftheirFourthShiftdatabases.WhatisReportBuilder?–ReportBuilderisanewfeature,basedonSQLServerReportingServices,providedwithMicrosoftSQLServer2005.ReportBuilderallowsuserstodevelopad-hocreportsoftheirSQLServerdatabasewithouthavingtolearnaquerylanguagesuchasTransac

4、t-SQL.Developmentofthesead-hocreportsisdonebysimplydragginganddroppingdataelementsintoareportformandthenexecutingthereport.Theytheniterativelyadddataelementsontotheirreportuntilitcontainsthedatatheyarelookingfor.TheycanthensavethereportsothatitisavailablewiththerestoftheReport

5、ingServicesreportsonthereportserver.AndallofthistakesplacewithouttheneedtodevelopaSQLServerselectstatement.WhatisReportBuilder?–ReportBuilderisaClickOnceWinFormsapplicationthatisaccessedfromthereportserverforeasycentralizedmanagement.ReportBuilderreportsarepublishedusingReport

6、DefinitionLanguage(RDL),whichallowsuserstotakeadvantageofReportingService’sfullcapabilities.WhatisReportBuilder?–BecauseReportBuilderreportsaresavedasRDL,theycanbeopenedandmodifiedusingtheadvancedprogrammingcapabilitiesinReportDesigner.ReportBuilderreportsaremanaged,secured,an

7、ddeliveredusingthesamemethodsandAPIsusedtomanage,secure,anddeliverReportDesignerreports.Inaddition,ReportBuildercanbelaunchedfromthirdpartyapplicationsforintegratedreporting.FSAd-HocReport–Installation–DataSourcelink–PerspectivesintroductionFSAd-HocReport-InstallationFSAd-HocR

8、eport-InstallationFSAd-HocReport-InstallationFSAd-HocReport–D