Foxtable(狐表)用户栏目专家坐堂 → 请教以下报表如何实现?


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

主题:请教以下报表如何实现?

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


加好友 发短信
等级:管理员 帖子:47448 积分:251060 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2012/2/1 11:54:00 [只看该作者]

Dim sb As new StringBuilder
Dim bms As List(of String) = DataTables("人员").GetUniqueValues("","二级部门")
For Each bm As String In bms
    Dim nms As List(of String) = DataTables("人员").GetUniqueValues("二级部门 = '" & bm & "'", "姓名" )
    sb.Append(bm & " " & nms.Count & "人")
    For Each nm As String  In nms
        sb.append(" " & nm)
    Next
    sb.AppendLine("")
Next
bms = DataTables("人员").GetUniqueValues("","部门")
For Each bm As String In bms
    sb.Append(bm & DataTables("人员").Compute("Count([_Identify])","部门 = '" & bm & "'"))
Next
output.show(sb.Tostring)

 回到顶部