Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共4 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:筛选后打印

1楼
狐友 发表于:2011/12/14 14:03:00

想根据管理员,逐步筛选后用excel报表打印,一个一个的打印,下面的代码打印出来不对

帮忙看下,谢谢!
    Dim tb As Table = Tables("销售订单.销售明细")
    Dim pr As Row = Tables("销售订单").Current
    Dim bh As String  = "订单编号 = '" & pr("订单编号") & "'"
    Dim Regions As List(Of String) = tb.DataTable.GetUniqueValues(bh,"管理员")
For Each Region As String In Regions 
   Tables("销售订单.销售明细").Filter = "[管理员] = '" & Region & "'"

 

    Dim Book As New XLS.Book(ProjectPath & "Attachments\book2.xls")
    Dim fl As String = ProjectPath & "Reports\book2.xls"
    Book.Build() '生成细节区
    Book.Save(fl) '保存工作簿
    Dim Proc As New Process '打开工作簿
    Proc.File = fl
    Proc.Start()

 

Next

Tables("销售订单.销售明细").Filter = ""

[此贴子已经被作者于2011-12-14 14:10:47编辑过]
2楼
程兴刚 发表于:2011/12/14 14:09:00

应该先告诉错误原因吧?

 

3楼
狐友 发表于:2011/12/14 14:12:00
就是全部都打印出来了,不是按管理员筛选后打印,我找个列子上来
4楼
狐狸爸爸 发表于:2011/12/14 14:16:00
Dim tb As Table = Tables("销售订单.销售明细")
Dim pr As Row = Tables("销售订单").Current
Dim bh As String  = "订单编号 = '" & pr("订单编号") & "'"
Dim Regions As List(Of String) = tb.DataTable.GetUniqueValues(bh,"管理员")
For Each Region As String In Regions
    Tables("销售订单.销售明细").Filter = "[管理员] = '" & Region & "'"
    Dim Book As New XLS.Book(ProjectPath & "Attachments\book2.xls")
    Dim fl As String = ProjectPath & "Reports\book2.xls"
    Book.Build() '生成细节区
    Book.Save(fl) '保存工作簿
    Dim Proc As New Process '打开工作簿
    Proc.File = fl
    proc.WaitForClose = True
    Proc.Start()
Next
Tables("销售订单.销售明细").Filter = ""
共4 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .03906 s, 2 queries.