主题：求取统计例子

假如有一个销售表，里面有产品名称，规格型号，销售数量三列：

每种产品名称的销售都有很多次数

现在要做一个按钮，功能如下

统计该表销售的产品名称的种类，而不是行数

或者是修改如下编码：

Dim t As Table = Tables("销售统计")
Dim g As Subtotalgroup
t.StopRedraw()
t.SubtotalGroups.Clear()
t.GroupAboveData = False
t.TreeVisible = False
t.SpillNode = True

g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "店铺旺旺"
g.TotalOn = "商品数量,重量kg"
g.Caption = "{0} 小计"
t.SubtotalGroups.Add(g)

g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "*"
g.TotalOn = "商品数量,重量kg"
g.Caption = "总计"
t.SubtotalGroups.Add(g)

t.Subtotal()
t.ResumeRedraw()
t.ShowCell(t.Rows.Count(True) - 1, 0) '显示最后一行

使其在多显示一样为：订单笔数,订单笔数为不重复的商品编号的统计

 生成以后，动态修改其值。计算不重复的个数，可以用getValues函数。

 

http://www.foxtable.com/help/topics/2747.htm

 

http://www.foxtable.com/help/topics/1964.htm

 

Dim t As Table = Tables("销售统计")
Dim g As Subtotalgroup
t.SubtotalGroups.Clear()
t.GroupAboveData = False
t.TreeVisible = False
g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "店铺旺旺"
g.Caption = "{0}"
t.SubtotalGroups.Add(g)
t.Subtotal()

Dim r As Row
For i As Integer = 0 To t.Rows.Count(True) - 1
    r = t.Rows(i,True)
    If r.IsGroup '如果是分组行
        Dim f As String = "店铺旺旺 = '" & r("店铺旺旺") & "'"
        Dim v As String = " 订单数:" & t.Compute("Count(打印时间)",f)
        Dim P As List(Of String) =  DataTables("销售统计").GetValues("二级编码")
        v = v & " 订购数量:" & t.Compute("Sum(商品数量)",f)
        v = v & " 订购重量:" & t.Compute("Sum(重量kg)",f)
        v = v & " 商品种类:" & t.Compute("Sum(P)",f)
        r("店铺旺旺") = "店铺旺旺:" & r("店铺旺旺") & v
    End If
Next

 

 

 

此主题相关图片如下：11.png

请教这个怎么显示不出来

    If r.IsGroup '如果是分组行
        Dim f As String = "店铺旺旺 = '" & r("店铺旺旺") & "'"
        Dim v As String = " 订单数:" & t.Compute("Count(打印时间)",f)
        Dim P As List(Of String) =  DataTables("销售统计").GetValues("二级编码", f)
        v = v & " 订购数量:" & t.Compute("Sum(商品数量)",f)
        v = v & " 订购重量:" & t.Compute("Sum(重量kg)",f)
        v = v & " 商品种类:" & p.Count
        r("店铺旺旺") = "店铺旺旺:" & r("店铺旺旺") & v
    End If