Dim b As New SQLGroupTableBuilder("统计表1","表A") B.AddTable("表A","编码","表B","编码") B.Groups.AddDef("公司") B.Totals.AddDef("数据1") B.Totals.ADDDEF("数据2") B.Totals.AddDef("数据3") B.Totals.AddDef("数据4") b.Totals.AddDef("数据5","iif(数据1 Is Null,0, 数据1) + iif(数据2 Is Null,0, 数据2) + iif(数据3 Is Null,0, 数据3) + iif(数据4 Is Null,0, 数据4)") B.Build
|