Dim dt As DataTable Dim b As New sqlGroupTableBuilder("统计表1", "A_SDDJ_DBBF_GY0") b.ConnectionName = "数据源名" b.Groups.AddDef("委托日期",DateGroupEnum.Year,"年") b.Groups.AddDef("委托日期",DateGroupEnum.Month,"月") b.Groups.AddDef("单位工程名称") b.Totals.AddDef("委托编号",AggregateEnum.Count,"订单数") '根据客户列来统计记录数,也就是订单数 dt = b.Build(True) '参数设置为True,生成一个临时表,不在主界面显示