以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- [求助]动态表达式合成错误 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=158301) |
-- 作者:冷泉 -- 发布时间:2020/11/15 10:46:00 -- [求助]动态表达式合成错误 提示错误:从字符串“[日期] >= #1/1/2011# And [日期] <= #”到类型“Long”的转换无效。麻烦老师指导下,谢谢 Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox2") Dim g As New CrossTableBuilder("统计表1", DataTables("明细"), "[日期] >= #1/1/" & e.sender.value & "# And [日期] <= #12/31/" & e.sender.value & "#" And "类别 = \'" & cmb.value & "\'") g.VGroups.AddDef("日期",DateGroupEnum.Year,"{0}年") g.VGroups.AddDef("日期","{0}月") g.VGroups.AddDef("部门") g.VGroups.AddDef("类别") g.Totals.AddDef("总价", "总价") g.Totals.AddDef("数量") g.Filter = "[日期] >= #1/1/" & e.sender.value & "# And [日期] <= #12/31/" & e.sender.value & "#" And "类别 = \'" & cmb.value & "\'" g.Build() e.form.controls("table1").Table.datasource = g.builddatasource()\'窗口表数据等于该创建表
|
-- 作者:冷泉 -- 发布时间:2020/11/15 18:34:00 -- 已经自己解决了 |