刚看了其他帖子,说 combine需要包含所有的分组
我如下做是可行,那是否还有别的更好的方案呢?
先在视图按单号分组统计每一单的金额:
SELEC T
DateName(year,dbo.[销售明细].[销售日期]) AS [年份],
case when DateName(weekday,dbo.[销售明细].[销售日期]) = '星期日' then cast(datename(week,dbo.[销售明细].[销售日期])as int)-1
else
cast(datename(week,dbo.[销售明细].[销售日期])as int)
end AS [周次],
dbo.[销售明细].[门店],
dbo.[销售明细].[营业员],
dbo.[销售明细].[单号],
sum(dbo.[销售明细].[销售金额]) as 销售金额
FROM
dbo.[销售明细]
group BY
dbo.[销售明细].[门店],
dbo.[销售明细].[营业员],
dbo.[销售明细].[单号],
dbo.[销售明细].[销售日期]
再在FT里做周大单金额 的统计:
Dim b5 As New SQLGroupTableBuilder("统计表5","员工周销售单号")
Dim dt5 As fxDataSource
b5.C
b5.Groups.AddDef("门店") '根据产品分组
b5.Groups.AddDef("营业员") '根据产品分组
b5.Totals.AddDef("销售金额",AggregateEnum.Max,"周大单金额") '根据产品分组
b5.Filter = filter
dt5= b5.BuildDataSource()