7,763
社区成员
发帖
与我相关
我的任务
分享
Screen.MousePointer = vbHourglass
'Set rs = Cnn.Execute("select * from VDetail ")
Dim CApp As New CRAXDRT.Application
Dim CRpt As New CRAXDRT.Report
Dim i As Integer
Set CRpt = CApp.OpenReport(App.Path & "\Data\DayReport.rpt")
CRpt.Database.Tables(1).SetDataSource rs ’这里的记录集是通过SQL语句得到的
'CRpt.ParameterFields.Item(1).AddCurrentValue "姓名:" & Text2.Text
'CRpt.ParameterFields.Item(2).AddCurrentValue "工号:" & Text1.Text
'CRpt.ParameterFields.Item(3).AddCurrentValue "开始时间:" & DTP1.Value & " 结束时间:" & DTP2.Value
frmView.CR.ReportSource = CRpt
frmView.CR.ViewReport
frmView.CR.Zoom 100
frmView.CR.Width = Me.ScaleWidth
frmView.CR.Height = Me.ScaleHeight
frmView.Show vbModal
Screen.MousePointer = vbDefault