假如表有4列,第一列单号,第二列门店名称,第三列数量,第四列金额,我想相同把门店名称的金额合计和数量合计还有单子的数量合计,按照金额排名,取前十显示在一个临时表,该怎么操作呢?我现在做了一个统计表,但是统计表不能排序,我又增加了一个新临时表,然后可以排序,但是无法控制行数,而且加载速度很慢。Dim g As New GroupTableBuilder("QTXPDHJ", DataTables("SG_Gathering"))
g.Groups.AddDef("vShop")
g.Totals.AddDef("fQuantity")
g.Totals.AddDef("fRealMoney")
g.Totals.AddDef("vMBillID", AggregateEnum.Count)
g.FromServer = False
g.Build()
Dim dt As DataTable = DataTables("DPXSPHB")
dt.DataRows.Clear
Dim Cols1() As String = {"vShop","fQuantity","fRealMoney","vMBillID"}
Dim Cols2() As String = {"MDDM","XSSL","XSJE","XSDS"}
For Each dr1 As DataRow In DataTables("QTXPDHJ").Select("fRealMoney > 1","fRealMoney desc")
Dim dr2 As DataRow = DataTables("DPXSPHB").AddNew()
For i As Integer = 0 To Cols1.Length -1
dr2(Cols2(i)) = dr1(Cols1(i))
Next
Next
[此贴子已经被作者于2020/6/21 5:47:08编辑过]