Foxtable(狐表)用户栏目专家坐堂 → [求助]求解数据筛选,报表打印代码?


  共有2495人关注过本帖树形打印复制链接

主题:[求助]求解数据筛选,报表打印代码?

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/3/1 11:09:00 [显示全部帖子]

Dim nd As String = e.Form.Controls("ComboBox1").Text
Dim sd As String = e.Form.Controls("ComboBox2").Text
Dim str As String = ""
str &= DataTables("生存认证资料").GetComboListString("公民身份号码", "认证年度 = '" & nd & "' Or 认证时段 = '" & sd & "'").replace("|", "','")
Tables("退休生存人员").filter = "公民身份号码 in ('" & str.trim(",") & "')"

'==========================以上是筛选已经认证的人员==============================
Dim Book As New XLS.Book(ProjectPath & "Attachments\退休认证表.xls")
Book.Build()
Book.Save(ProjectPath & "Reports\退休认证表.xls")
Dim Proc As New Process
Proc.File = ProjectPath & "Reports\退休认证表.xls"
Proc.Start()
'==============================以上是认证报表打印=================================
Tables("退休生存人员").Filter = ""
e.Form.Close


 回到顶部