名称为"统计表1"的table不存在? Post By:2013/1/23 21:20:00 [显示全部帖子]
Dim cmd As New SQLCommand Dim dt As DataTable cmd.C cmd.CommandText = "Select 客户名称,数量_本次交*单价 As [金额] From {出库单主表} Inner JOIN {出库单明细} ON {出库单明细}.[出库单号] = {出库单主表}.[出库单号]" dt = cmd.ExecuteReader() '对临时进行分组统计 Dim b As New CrossTableBuilder("统计表1",dt) b.HGroups.AddDef("客户名称") b.Totals.AddDef("金额") b.HorizontalTotal = True b.VerticalTotal = True b.Build() MainTable = Tables("统计表1")