加好友 发短信
等级:七尾狐
帖子:1525
积分:10580
威望:0
精华:0
注册:2008/9/24 11:16:00
|
[求助]修改sql语句,填充投工统计数 Post By:2013/12/23 14:23:00 [只看该作者]
如何根据CaseStudy目录下的文件"多表统计.Table"的思路,修改sql语句,将“日报源表”(外表数据表)中的投工数按年月,单位,客户汇总填充到“销售工效分月汇总”表中。请各位老师指教,谢谢!!
Dim sql,s As String sql = "SELECT 年月,单位,客户全称 AS 客户,SUM(销售收入) AS 销售收入,SUM(资金回笼) AS 资金回笼,0.1-0.1 As 投工,0.1-0.1 As 人均销售 FROM {xsmx} WHERE 年月 >= '" & nc & "' And 年月 <= '" & ny & "' GROUP BY 单位,年月,客户全称" Dim b As New CrossTableBuilder("销售工效分月汇总",sql) b.HGroups.AddDef("单位") b.HGroups.AddDef("客户") b.VGroups.AddDef("年月") b.Totals.AddDef("销售收入") b.Totals.AddDef("资金回笼") b.Totals.AddDef("投工") b.Totals.AddDef("人均销售") b.HorizontalTotal = True b.VerticalTotal = True b.Build()
|
|