初学水晶报表问题:登陆失败了:(
当水晶报表的字段在数据库同一个表时可正常显示,当表内字段来自2个以上表时出错
---------------------------
Crystal Report Viewer
---------------------------
登录失败。
详细资料: 28000:[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'sa' 登录失败。
---------------------------
确定
---------------------------
程序:
Dim rptApp As New CRAXDRT.Application
Dim rpt As New CRAXDRT.Report
Private Sub Form_Load()
Dim rs As New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select name from aa ", conn, adOpenKeyset, adLockBatchOptimistic
Set rpt = rptApp.OpenReport(App.Path & "\report3.rpt")
rpt.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer91.ReportSource = rpt
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub