iFIX历史数据报表使用经验总结

iFIX ADO Based on Historical Data Report

结合多年自动化监控组态软件开发经验,在iFIX组态工程中开发基于ADO的历史数据报表功能。上位机采用组态软件iFIX4.5,使用Visual Basic 6.0作为开发工具,实时采集生产过程中所产生的数据,定时或根据触发条件保存数据到历史数据库,利用Excel生成报表模板,根据不同的选择条件查询数据生成报表。采用介绍的方法设计的报表应用程序具有普遍性,通过简单修改可移植到其它工程中。

Combined with years of automatic monitoring configuration software development experience,iFIX to the project to develop historical data reporting capabilities based on ADO.PC using the configuration software iFIX4.5 using Visual Basic 6.0 development tools,real-time acquisition of data generated in the production process,timing,or save the data to the historical database according to trigger conditions,the use of Excel to generate the report template,depending on the selection criteriaquery data to generate reports.This paper describes the reporting applications designed to be universal,by simple modification can be ported to other projects.