一种通用报表的设计和实现

龙源期刊网 https://www.wendangku.net/doc/3b1960996.html,

一种通用报表的设计和实现

作者：旭日,薛慧君

来源：《现代电子技术》2010年第18期

摘要:提出一种通用报表的设计和实现方法,在信息管理系统设计中,查询数据通常需要以报表的形式输出,设计了一个非常实用的函数,采用OLE自动化技术,通过程序代码实现对Excel文档的各种编辑功能,并应用于一类通用报表的设计和输出。设计的函数接口简单、易于调用,可以大大减少信息系统开发中一类通用报表的设计工作量,可重用性高。该方法已经应用于多个

实际应用系统的开发和设计。在此详尽分析和阐述了通用报表的设计和实现,并给出了该函数

的主要代码。关键词:通用报表; 信息管理系统; 函数调用; Excel报表格式

中图分类号:TN911-文献标识码:A

文章编号:1004-373X(2010)18-0069-03

Design and Implementation of General Two-dimensional Report

XU Ri1, XUE Hui-jun2

(1.Department of Computer Science, Inner Mongolia Business & Trade Vocational College, Hohhot 010010, China;

2.Department of Computer Science, Inner Mongolia Electronic Information Vocational Technical College, Hohhot 010010, China)

Abstract: The design and implementation methods of a general report are proposed. The data of MIS is usually outputed in a report mode during the design of information management system. Various edition functions for Excel files were realized with OLE automatization technology and program code. They are applied to the design and output of the first class common report. The designed function interface is simple and easy to be called, and can greatly reduce the design work of the common report in the development of information systems, this method has been applied to the development and design of many application systems. The detailed analysis and elaboration on design and implementation of a kind of general report are offered. The main codes of this function are also provided.Keywords: common report; information management system; function call; Excel report format

0 引言