Dim ks As Date= Date.Today
Dim js As Date= Date.Today.AddDays(1)
MessageBox.Show( ks & js)
Dim dp As String="测试店铺13"
Dim Val As Integer
Val = DataTables("退件扫描").Compute("Count(运单编号)","扫描类型 = '已退' and 上下站 = '" & dp & "'and 扫描时间 <= #" & js & "# and 扫描时间 >= #" & ks & "# ") '
If Val >0 Then
MessageBox.Show(Val )
Dim Book As New XLS.Book(ProjectPath & "Attachments\退件报表.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\退件报表.xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(6,6).Value = "<扫描类型='已退'and 上下站='"& dp &"'and 扫描时间 <= #' & js & '# And 扫描时间 >= #' & ks & '# >" '写入打印条件
Sheet(4,2).Value = dp
Book.Build() '生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()
Else
MessageBox.Show("当前筛选条件下无数据,请重新筛选!")
End If
报表能不能使用窗口中新建的临时表数据?