我用如下代码，实现了本月入库，出库的统计，怎样才能得到上月的结存金额和数量呢？，本月结存数量和金额，应该可以用表达式来解决吧
Dim g As New GroupTableBuilder("统计表1", DataTables("入库明细"))
Dim dt1 As fxDataSource
g.Groups.AddDef("入库日期", DateGroupEnum.Year, "年")
g.Groups.AddDef("入库日期", "月")
g.Groups.AddDef("商品名称")
g.Totals.AddDef("入库数量", "", "本月入库_数量")
g.Totals.AddDef("入库金额", "", "本月入库_金额")
dt1 = g.BuildDataSource()
Dim g1 As New GroupTableBuilder("统计表2",DataTables("出库明细"))
Dim dt2 As fxDataSource
g1.Groups.AddDef("出库日期", DateGroupEnum.Year, "年")
g1.Groups.AddDef("出库日期", "月")
g1.Groups.AddDef("商品名称")
g1.Totals.AddDef("出库数量", "", "本月出库_数量")
g1.Totals.AddDef("出库金额", "", "本月出库_金额")
dt2 = g1.BuildDataSource()
Dim nms As String() = {"年","月","商品名称"} '指定连接列
dt1.Combine(nms,dt2,nms) '将销售统计数据组合到进货统计数据
Tables("出入库月统计_月汇总").DataSource = dt1 '将统计结果绑定到Table
此主题相关图片如下：3.png
[此贴子已经被作者于2021/4/17 15:52:56编辑过]
加好友 
发短信
Post By：2021/4/17 15:51:00 [只看该作者]
