我用的是vb+sql2000,为何用第一就能显示,后来都显示第一条
Private Sub Form_Load()
'orderNO为传递值
Set rs = New ADODB.Recordset
sql = "select *from product where orderNO='" & Trim(OrderNO) & "'"
rs.Open sql, Conn, adOpenStatic, adLockReadOnly
Report.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefaultEnd Sub
Private Sub Form_Load()
'orderNO为传递值
Set rs = New ADODB.Recordset
sql = "select *from product where orderNO='" & Trim(OrderNO) & "'"
rs.Open sql, Conn, adOpenStatic, adLockReadOnly
Report.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefaultEnd Sub
objCRReport.DiscardSavedData
'赋给报表数据
objCRReport.Database.SetDataSource rst http://www.cnblogs.com/babyt/archive/2005/03/13/117753.html