以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  [求助]合计行0值不显示  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=62265)

--  作者:建筑人生
--  发布时间:2014/12/28 21:06:00
--  [求助]合计行0值不显示

Select Case e.DataCol.Name
    Case "投资收入","建筑公司收入","其它收入","备用金支出","备用金收回","班组支出","管理人员工资"
        For Each dr As DataRow In e.DataTable.Select("[_SortKey] >= " & e.DataRow("_SortKey"))
            Dim Val1 As Double = e.DataTable.Compute("Sum(收入合计)","[_SortKey] <= " & dr("_SortKey"))
            Dim Val2 As Double = e.DataTable.Compute("Sum(支出合计)","[_SortKey] <= " & dr("_SortKey"))
            Dim Val3 As Double = e.DataTable.Compute("Sum(备用金合计)","[_SortKey] <= " & dr("_SortKey"))           
            dr("余额") = Val1 - Val2-Val3           
        Next
\'显示合计行
        With Tables("现金流量表")
           
            .Cols("房地产收入").GrandTotal = True
            .Cols("房地产支出").GrandTotal = True
            .Cols("房地产合计").GrandTotal = True
           
            .Cols("投资收入").GrandTotal = True
            .Cols("投资支出").GrandTotal = True
            .Cols("投资合计").GrandTotal = True
           
            .Cols("建筑公司收入").GrandTotal = True
            .Cols("其它收入").GrandTotal = True
            .Cols("收入合计").GrandTotal = True
           
            .Cols("班组支出").GrandTotal = True
            .Cols("管理人员工资").GrandTotal = True
            .Cols("支出合计").GrandTotal = True
            .GrandTotal = True           
        End With       
End Select

 

 

要怎么样才能不显示0值


--  作者:有点甜
--  发布时间:2014/12/28 21:06:00
--  
 无法控制。