The Dynamic Statistics of Cross-Tab Data Programmed by PowerBuilder
XU Ming (Institute of Machinery Manufacturing Technology, China Academe of Engineering Physics, MianYang 621900, China)
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.
【CateGory Index】： TP311.52