基于模版解析的电网自定义报表系统的设计与实现v2.docVIP

PAGE 2 Computer Engineering and Applications 计算机工程与应用 基于模版解析的电网自定义报表系统的设计与实现v2 第 PAGE \* Arabic \* MERGEFORMAT 1 页第 PAGE \* Arabic \* MERGEFORMAT 1 页 HEREDITAS (Beijing) 2006, 28(8): 1~10 封面人物 基于模版解析的电网自定义报表系统的设计与实现 作者名1, 作者名2, 作者名3 NAME Namename1, NAME Name2, NAME Namename3 1.单位全名 部门(系)全名,省 市(或直辖市) 邮政编码 2.单位全名 部门(系)全名,省 市(或直辖市) 邮政编码 3.单位全名 部门(系)全名,省 市(或直辖市) 邮政编码 1. Department of ****, University, City ZipCode, China 2. School of ****, University, City ZipCode, China 3. College of ****, University, City ZipCode, China Author. Design and implementation of power grid custom report system based on template analysis.Computer Engineering and Applications Abstract：In view of the problem that the power network dispatching management system has the problems such as poor report expansion, diverse data sources and complex functions, the scheme of using custom report forms is proposed. According to excel to make statements of visibility, flexibility, easy to operate features, using the method of analytic systems excel report template storage report style structure, also in custom report page layout template based information and data repository tables, reporting information, report display configuration and data display data source information design template analysis grid of user-defined report system based on. System administrators through the local computer excel to make the report templates, through the system analysis template, select configure report relevant information, the system will automatically generate the report links and generate report shows, greatly improve the efficiency and making statements. Key words：dispatching management system; template analysis; user-defined report system 摘 要：针对电网调度管理系统在日益增加的业务需求下出现的报表扩展性差、数据源多样化、报表功能复杂等问题，提出采用自定义报表的方案。根据Excel制作报表的可视性、灵活性、易操作的特点，采用系统解析Excel报表模版存储报表样式结构的方法，同时在报表定制页面配置模版基础信息、数据存储库表、报表功能信息、报表显示配置及数据显示的数据源等信息，设计出基于模版解析的电网自定义报表系统。系统管理员通过本地电脑上的Excel制作报表模版，经过系统分析模版，选择配置报表相关信息，系统自动生成该报表链接并生成显示报表，大大提高了制作并