CrystalActiveXReportViewer 如何设置数据源?
CrystalActiveXReportViewer 如何设置数据源? 引用的是crviewer.dll 文件版本11.5.9.1229
Dim scConn As New SqlClient.SqlConnection() Dim CMD As System.Data.SqlClient.SqlCommand Dim daIMPLRCR As New SqlDataAdapter() Dim dsIMPLRCR As New DataSet() Dim myReportDoc As New ReportDocument() Dim ConnectionString As String = "Data Source=" & M_ServerName & ";Initial Catalog=" & M_Database & ";User ID= " & M_UserName & ";Password= " & M_Password & "; " scConn.ConnectionString = ConnectionString scConn.Open() CMD = New SqlClient.SqlCommand("select * from AcctResult", scConn) CMD.CommandType = CommandType.Text CMD.ExecuteNonQuery() daIMPLRCR.SelectCommand = CMD daIMPLRCR.Fill(dsIMPLRCR, "RptIMPLRCR") myReportDoc.Load(Application.StartupPath & "\Report1.rpt") myReportDoc.SetDataSource(dsIMPLRCR.Tables(0)) crvARBrowse.ReportSource = myReportDoc crvARBrowse.Zoom(1)