Crystal report not updating

10 years ago By godwin183

I am having a problem with crystal reports. After the first execution, it doesn't matter what changes i make in the database. The report viewer does not change. My code is as follows;

        Try
            conn1 = getnod()
            conn1.Open()
 
          cmd3 = New SqlCommand("Select * From OrderTbl Where DateRecieved IS NULL", conn1)
 
            CrystalReportViewer1.Refresh()
            Dim da2 As New SqlDataAdapter(cmd3)
            da2.Fill(ds2, "Pending")
 
            Dim objrpt As New CrystalReport1
 
            CrystalReportViewer1.ReportSource = objrpt
            CrystalReportViewer1.Refresh()
            objrpt.Refresh()
            conn1.Close()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

Add new comment

5 views