如果采用是在报表中设置数据集,我已经解决。下面是我解决的代码。
Option Explicit
Dim IsRestart As Boolean
Private Sub ActiveReport_ReportStart()
DataControl1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=XUYINKUI"
DataControl1.Source = "select * from orders"
DataControl1.Refresh
If Not IsRestart Then
Me.Toolbar.Tools.Add ("打印设置")
Me.Toolbar.Tools.Add ("转为Excel")
End If
End Sub
Private Sub ActiveReport_ToolbarClick(ByVal Tool As DDActiveReports2.DDTool)
Select Case Tool.Caption
Case "打印设置"
If Me.PageSetup() Then
IsRestart = True
Me.Restart
End If
End Select
End Sub
http://www.datadynamics.com/downloads.asp
下载pro版:
ActiveReports 2 pro Manual (pdf format) -->手册
AR2 Pro Service Pack 1 (build 1170) -->sp1
AR 2 Professional fully functional evaluation version -->ar 2(评估)