1. Forums
  2. Programming
  3. Visual Basic .NET
  4. Crystal report not updating

Crystal report not updating

Submitted by godwin183 on
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;
  1.         Try
  2.             conn1 = getnod()
  3.             conn1.Open()
  4.  
  5.           cmd3 = New SqlCommand("Select * From OrderTbl Where DateRecieved IS NULL", conn1)
  6.  
  7.             CrystalReportViewer1.Refresh()
  8.             Dim da2 As New SqlDataAdapter(cmd3)
  9.             da2.Fill(ds2, "Pending")
  10.  
  11.             Dim objrpt As New CrystalReport1
  12.            
  13.             CrystalReportViewer1.ReportSource = objrpt
  14.             CrystalReportViewer1.Refresh()
  15.             objrpt.Refresh()
  16.             conn1.Close()
  17.         Catch ex As Exception
  18.             MsgBox(ex.Message)
  19.         End Try
  • 7 views