a:用ll_breakrow = dw_findgroupchange()得到第一组的第一条记录.
b:用count(*) for group 1得到每小组记录数
c: for i = 1 to 每小组记录数
ll_breakrow = ll_breakrow++
//赋给'名次'
next
d:循环
http://expert.csdn.net/Expert/topic/1756/1756957.xml?temp=.4276087
想了一个用代码实现的方法
1.用A分组
abs(count(A for group 1) - rowcount() - getrow())
2.为表添加一个字段用来记录顺序tag int
在dw_1.retrieve()之后写
long ll_num, ll_num_compare, ll_rowcount, i, ll_find
string ls_A, ls_A_compare
ll_rowcount = dw_1.rowcount()
for i = 1 to ll_rowcount
ls_A = dw_1.object.A[i]
ll_num = dw_1.object.compute_1[i]
if i = 1 then
ls_A_compare = ls_A
ll_num_compare = ll_num
end if
if i < ll_rowcount then
ll_find = dw_1.find("A = '" + ls_A_compare + "'", i + 1, ll_rowcount)
end if
if ll_find > 0 then
dw_1.object.tag[i] = ll_num - ll_num_compare + 1
else
if i > 1 then
dw_1.object.tag[i] = dw_1.object.tag[i - 1] + 1
end if
if i < ll_rowcount then
ls_A_compare = dw_1.object.A[i + 1]
ll_num_compare = dw_1.object.compute_1[i + 1]
end if
end if
next