Foxtable(狐表)用户栏目专家坐堂 → 增加表标题


  共有2850人关注过本帖平板打印复制链接

主题:增加表标题

帅哥哟,离线,有人找我吗?
rgbjwjb
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:三尾狐 帖子:637 积分:6461 威望:0 精华:0 注册:2016/12/27 21:05:00
增加表标题  发帖心情 Post By:2021/3/10 14:46:00 [只看该作者]

我想给统计表加个标题,运行后,没有报错,也没统计结果,代码如下:

Dim ndxz As WinForm.ComboBox = e.Form.Controls("年度选择")
            Dim yfxz As WinForm.ComboBox = e.Form.Controls("月份选择")
            If ndxz.value > 0 And yfxz.value > 0 Then
                Dim dt1 As New Date(ndxz.value, yfxz.value, 1)
                Dim dt2 As New Date(ndxz.value, yfxz.value, Date.DaysInMonth(ndxz.value,yfxz.value)) '获取该月的最后一天
                Dim g As New CrossTableBuilder("统计表1", DataTables("派工单明细表"))
                Dim dt As fxDataSource
                g.HGroups.AddDef("村民组")
                g.HGroups.AddDef("户主姓名")
                g.HGroups.AddDef("派工日期", DateGroupEnum.None)
                g.VGroups.AddDef("工程名称")
                g.Totals.AddDef("工时", "工时")
                g.Totals.AddDef("工价", "工价")
                g.OrderByTotal = True
                g.HorizontalTotal = True
                g.VerticalTotal = True
                g.Decimals = 2
                g.Subtotal = True
                g.Filter = "[派工日期] >= #" & dt1 & "# And [派工日期] <= #" & dt2 & "#"
                g.Caption ="江安镇徐柴村" & ndxz.value & "年" & yfxz.value & "月公用工统计表"
                g.Build()
                dt = g.BuildDataSource()
                Tables("公用工查询_Table1").DataSource = dt
            End If
不知如何修改?请指教,谢谢!


 回到顶部