毕业设计论文(报表生成).docVIP

报表自动生成软件设计 Software Design of Auto-generating Reports 摘 要 在现代管理系统的开发中，经常涉及到数据的分析加工，最终把统计结果形成各种形式的报表，提供给领导决策参考或进行外部交流。一般情况下，可以采用专用的报表设计器来完成一个报表模板的设计，但在测试了几种设计器后，发现它们并不尽如人意。为此，笔者提出了基于Microsoft公司开发的Visual Basic 6.0以Basic高级语言为基础的面向对象的编程工具,采用ActiveX Data Objects数据连接技术,结合Access数据库,开发以Excel为数据报表模板的数据库管理系统。此设计的优点在于:通过VB设计的简洁窗口界面能够实现降低用户使用软件的操作难度;连接了数据库的管理系统可以对繁杂的数据在后台进行分析处理;增加了复杂格式报表打印输出功能可以使得外部交流变得直观透彻。此次设计开发的“物流管理系统”实现了对运单的添加、删除、修改和查询功能，对品名的添加、删除和修改功能，对车站的添加、删除和修改功能，对客户的添加、删除和修改功能。最为主要和重要的是实现了客户结算表单的打印预览、打印和导入到Excel功能以及汇总结算表单的打印预览、打印和导入到Excel功能。 关键词：Visual Basic；Excel；Access；报表；数据库管理系统 Abstract Analysis of the data processing is often involved in the modern management system. Finally, results of these statistical reports are made into various forms, provided to the leadership to make a decision or to have external communication. Normally, we can use a dedicated report designer to complete the report forms templates. After testing several designers, I found they are not as satisfactory as we thought. So, I put forward a plan, which is based on Visual Basic 6.0 that Microsoft Company made, using ActiveX Data Objects and combining Access, developing the DBMS that based on Excel. There are several advantages of this plan. By using VB to design compact windows and it is easy for clients to use this software .At the same time the DBMS make it possible to analyze and process the complexity of data in the background. It adds the print funcation of complex format output which makes the external communication clear. The design of this “Logistics management system” has realized the functions of waybill increases, waybill remove, waybill changes and waybill inquiry. It also has realized these functions, adding, delete, modify and inquiry .This functions can be use in product name, station name and customer name. The most important function of this design is to achieve a printout, print preview, and the excel import about settlement form and summary form. Keywords: Visual