Dim cryApp As New CRAXDRT.Application
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim Report As CRAXDRT.Report
Private Sub Command1_Click()
Set Report = cryApp.OpenReport("E:\report1.rpt")
Report.Database.SetDataSource rs
Form2.CRViewer1.ReportSource = Report
Form2.Show
End Sub
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DatabaseName;Data Source=servername"
rs.Open "select * from tableName", cn, adOpenKeyset, adLockReadOnly