Urgent Help Needed Vb.Net ReportViewer
-
Using the code below, I display a Crystal Report. The Crystal Report is populated by a view in sql server. Every time I run this, it always displays the same data, no matter what is in the view. Doesn't make any sense to me. 'Update view with new records Dim sc As New PK.BusinessLogicLayer.Schedule() sc.StudyNo = txtStudyNo.Text.Trim sc.PrintQCS() Dim QCSDoc As New ReportDocument() QCSDoc.Load("C:\Inetpub\wwwroot\x\Quota_Control.rpt") Dim logonInfo As New TableLogOnInfo() Dim i As Integer For i = 0 To QCSDoc.Database.Tables.Count - 1 logonInfo.ConnectionInfo.ServerName = serverName logonInfo.ConnectionInfo.DatabaseName = databaseName logonInfo.ConnectionInfo.UserID = uid logonInfo.ConnectionInfo.Password = pwd QCSDoc.Database.Tables.Item(i).ApplyLogOnInfo(logonInfo) Next CRV01.DisplayToolbar = False CRV01.DisplayGroupTree = False CRV01.BestFitPage = True CRV01.ReportSource = QCSDoc