PB中编程交叉表数据的动态统计

The Dynamic Statistics of Cross-Tab Data Programmed by PowerBuilder

针对收费管理系统中需对大量数据进行横向和纵向分析统计的问题,探讨了在PowerBuilder环境下基于数据窗口技术动态实现交叉表的数据统计方法。该方法的关键,一是利用数据窗口的内嵌函数使交叉表横向表头只显示缴费时间,二是设计一个只有一个记录的临时数据表实现动态地选择年份进行该年的数据统计。交叉表的定义通过对行列上显示数据的拖动和计算列的放置以实现。数据动态统计包括SELECT语句、在编辑掩码控件em_1中选择输入年、主窗口的open事件、确定按钮等的内嵌函数。

Aiming at the problems that are longitudinal and transverse analysis and statistics of a great lot data in toll management system, the realization of dynamic statistics method for cross-tab data based on data window technology programmed by PowerBuilder was discussed. In the method, toll time display of transverse first line in cross-tab was accomplished with embedding function of data window. A provisional data table with one register was designed to select dynamically year and to do data statistic of the year. The definition of cross-tab was accomplished with dragging data displayed in row / clumn and calculating clumn location. The dynamic statistics of data includes SELECT sentence, input of selected year in edit mask control-ware em_1, open event of host window and knob confirming etc embedding functions.