一种自定义动态报表系统的设计与应用  

Design and Applications of Custom Dynamic Report System

作　　者：巫乔顺[1] 彭海波[1] 李杰[1] 

机构地区：[1]武钢集团昆明钢铁股份有限公司信息中心,云南昆明650302

出　　处：《机械设计与制造工程》2013年第1期80-82,共3页Machine Design and Manufacturing Engineering

摘　　要：设计并实现了一种基于XML和Excel技术的自定义动态报表系统,系统由数据层、业务层、定义层及展现层组成。其中数据层为任何能提供报表原始数据的数据源,如数据库、文本文件等;业务层的功能主要是解析配置文件,获取报表原始数据、组织提供报表数据给展现层,决定报表最终的处理方式(如打开、下载或者直接打印等);定义层主要用于定义数据源的获取方式、连接类型、报表格式、打印信息等;展现层由Excel模板构成,可以包含文本、图形、控件等。该设计能使报表的实施和维护成本大幅降低,通过简单的配置即可满足多变的报表需求,具有极高的灵活性、易用性和实用性。Based on XML and EXCEL technology, this paper designs and implements a custom dynamic report system. The system is composed of data layer, business layer, definition layer and presentation layer. The data layer can provide statements of original data source, such as database, text file. The main function of business layer is parsing configuration files, obtaining statements, providing original data report data to the presentation layer, and deciding the final processing way such as open, download or print. Definition layer is mainly used for the definition of source data acquisition mode, link type, report format, print information. Presentation layer consists of EXCEL templates, which can contain text, graphics, controls. The design significantly reduces imple mentation and maintenance costs of statements, and variable reporting requirements can be met by a simple con figuration. The design has high flexibility, ease of use and practicality.

关 键 词：XML EXCEL 报表 动态 设计 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]