K killus Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-13 #1 我现在在做一个分组报表,要求在Qroup行上有一个计算统计,要求计算出该小组中某一列的合计 数比如计算出a组中数量(qty)的总计.不知该如何编写?
L liuly Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-14 #3 QuickReport的Demo中就有啊 Grouping and SubTotaling Report
K kals Unregistered / Unconfirmed GUEST, unregistred user! 2001-09-14 #5 不太明白你的意思,是不是这样??试试看是不是这个意思 Select Field1 as a,SUM(Field2) as b From Table1 Group By Field1 Union Select '总计' as a,Sum(Field2) as b From Table1
不太明白你的意思,是不是这样??试试看是不是这个意思 Select Field1 as a,SUM(Field2) as b From Table1 Group By Field1 Union Select '总计' as a,Sum(Field2) as b From Table1