报表设计与开发论文.doc

1毕业设计技术报告课题名称基于WEB应用程序的水晶报表设计与开发报表设计与开发学生姓名学号专业计算机科学与技术班级指导教师摘要VisualStudio.NET内置的CrystalReports（水晶报表）是一种标准化的报表设计工具，在.NET平台中的水晶报表可以用来生成交互式的、直观的、使人满意的报表。水晶报表不仅可以用来制作基于Web或者Windows应用程序的许多本地报表或基于Web服务的报表，你可以通过VisualStudio.NET关于水晶报表开发的帮助就可以在VisualStudio.NET平台中创建和格式化你自己的报表。ASP.NET已成为计算机网络应用的一个主要技术，尤其2是ASP.NET设计模式中的三层结构技术，在表示层提供应用程序的用户界面业务层实现应用程序的业务功能数据层提供对外部系统（如数据库）的访问1。本文针对采用ASP.NET三层结构设计模式、VisualStudio.NET内置的CrystalReports（水晶报表）功能以及与数据库交互技术的系统作以介绍。关键词ASP.NETCrystalReports贸易管理AbstractCrystalReportsforVisualStudio.NETisthestandardreportingtoolforVisualStudio.NETitbringstheabilitytocreateinteractive,presentationandqualitycontentreportsinthe.NETplatform.ItisusedtocreateaWeborWindowsapplicationthathostsalocalreportorReportWebService，ByhelperwhichintheVisualStudio.NETofDeployingCrystalReportsyoucancreateandformataCrystalReportintheVisualStudio.NETenvironment.ASP.NEThasbecometheapplicationsofthecomputernetworkmaintechniquecurrently,especially,ThreeLayeredtechniquewithinmodeoftheASP.NETdesignparticularly,thepresentationlayerprovidestheapplicationsuserinterfaceUI.Thebusinesslayerimplementsthebusinessfunctionalityoftheapplication.Thedatalayerprovidesaccesstoexternalsystemssuchasdatabases1.ThispaperintroduceyoutheElectronicCommerceBaseonEconomyManagementthatithasAdopttheThreeLayeredtechniquewithinmodeoftheASP.NETdesignparticularly,functionofCrystalReportsforVisualStudioandusetheSQLServerdatabase.KeywordsASP.NETCrystalReportsElectronicCommerce目录1概述.............................................................................................................................................................................41.1水晶报表简介.................................................................................................................................................41.1.1什么是水晶报表...................................................................................................................................41.1.2水晶报表的用途...................................................................................................................................51.1.2.1使用水晶报表可以创建所能想象的任何报表.........................................................................531.1.2.2使用水晶报表可将报表并入应用程序.....................................................................................51.1.2.3使用水晶报表可将报表扩展到Web应用程序.......................................................................51.1.3水晶报表的功能...................................................................................................................................51.1.4水晶报表的优点...................................................................................................................................51.1.5水晶报表的结构...................................................................................................................................61.1.6水晶报表的执行模式...........................................................................................................................71.1.7水晶报表的报表类型...........................................................................................................................71.1.8水晶报表处理模型...............................................................................................................................71.1.8.1第1次预传递..........................................................................................................................71.1.8.2第1次传递..............................................................................................................................71.1.8.3第2次预传递..........................................................................................................................81.1.8.4第2次传递..............................................................................................................................81.1.8.4第3次传递..............................................................................................................................81.1.9使用水晶报表的注意事项...................................................................................................................91.2设计思想..........................................................................................................................................................91.3国内外报表研究现状...................................................................................................................................101.3.1国外报表研究现状..............................................................................................................................101.3.2国内的报表研究历史..........................................................................................................................111.3.3国内的报表软件研究现状..................................................................................................................111.4开发工具的选用及介绍...............................................................................................................................121.4.1ASP.NET的优势...............................................................................................................................121.4.2ASP.NET的特点...............................................................................................................................121.4.3ASP.NET的工作原理.......................................................................................................................131.4.4ASP.NET与VB.NET之间的关系.................................................................................................131.4.5MicrosoftSQL2000简介.................................................................................................................132网站总体分析与设计...............................................................................................................................................132.1系统可性行分析...........................................................................................................................................132.1.1技术可行性.........................................................................................................................................132.1.2经济可行性.........................................................................................................................................142.1.3操作可行性.........................................................................................................................................142.2系统的ER图.............................................................................................................................................142.3系统的数据字典...........................................................................................................................................152.4系统的数据流图...........................................................................................................................................192.5系统技术路线及功能简介............................................................................................................................223详细设计...................................................................................................................................................................223.1采购订单管理...............................................................................................................................................233.2客户订单管理...............................................................................................................................................233.3客户信息管理...............................................................................................................................................233.4雇员信息管理...............................................................................................................................................233.5运货商信息管理...........................................................................................................................................243.6供应商信息管理...........................................................................................................................................243.7产品种类信息管理.......................................................................................................................................243.8库存信息管理...............................................................................................................................................243.9查看各类产品销售额报表...........................................................................................................................243.10查看年度、季度汇总销售额报表.............................................................................................................2643.11查看公司季度、月份财务汇总报表..........................................................................................................263.12查看各类产品报表.....................................................................................................................................273.13查看雇员销售业绩报表.............................................................................................................................273.14查看己发货的订单报表.............................................................................................................................283.15系统主页.....................................................................................................................................................224关键代码段示例.......................................................................................................................................................284.1上传图片并生成缩略图...............................................................................................................................284.2有关水晶报表打印功能的实现...................................................................................................................294.3有关水晶报表显示及向报表传递参数功能的代码段................................................................................304.4如何在弹出对话框的同时保持页面的显示................................................................................................314.5如何防止用户按F5或点击工具栏的刷新按钮多次重复提交数据....................................................314.6如何处理多页面重定向到同一页面后的返回问题....................................................................................315结论............................................................................................................................................................................325.1系统概述.......................................................................................................................................................325.2系统开发的体会...........................................................................................................................................326谢辞..............................................................................................................................................错误未定义书签。7参考文献...................................................................................................................................................................321概述1.1水晶报表简介1.1.1什么是水晶报表水晶报表英文称CrystalReports，是SeaGate公司出品的、功能完善、设计灵活的报表设计开发工具。其实质就是一种报表控件。水晶报表用于处理数据库数据，帮助用户分析和解释重要信息。使用水晶报表可以方便地创建简单报表，同时它也提供了创建复杂或专用的报表所需的整套工具