基于SQL SERVER 2005的WINCC 7.0报表系统实现方法  

System Implementation Method of WINCC 7.0 Report Based on SQL SERVER 2005

作　　者：霍迎科 杨铮 HUO Ying-ke;YANG Zheng(Hebei Iron and Steel Group Handan Iron and Steel Automation Department,Handan 056000 China)

机构地区：[1]河北钢铁集团邯郸分公司自动化部,河北邯郸056000

出　　处：《自动化技术与应用》2020年第6期135-139,共5页Techniques of Automation and Applications

摘　　要：本文介绍了在WINCC 7.0组态环境中,基于SQL SERVER 2005数据库和VBS编程语言实现WINCC 7.0复杂报表在高级应用中的操作方法,结合SQL SERVER 2005数据库和VBS语言阐述了数据归档、数据查询、数据导出、数据编辑的过程。按功能将报表结构划分为四个模块,分别为数据归档、数据查询、数据显示、数据打印。介绍了四个模块的设计编程思路方法,从而有效解决了在WINCC 7.0画面组态时难以实现复杂报表的难题。In WINCC 7.0 configuration environment,this paper introduces the operation method of self-defined WINCC 7.0 complex report forms based on SQL SERVER 2005 database and VB-Scirpt programming language,and elaborates how to customize the archiving,querying,exporting and editing of data in combination with database and VB language.Based on the idea of modularization,the report structure is divided into four modules:data archiving,data query,data display and data printing.The design idea and programming method of each module are introduced in detail,which effectively solves the problem of realizing complex data report in WINCC 7.0 environment.

关 键 词：WINCC 7.0 SQL SERVER 2005 报表 交换数据 

分 类 号：TP273[自动化与计算机技术—检测技术与自动化装置]