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

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

本文介绍了在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.