refreshing data reports

[Guest_imported]

Hello friends

I am working with data reports my problem is that data reports are not getting refreshed automatically. If i open a data report view it closes itand then again opens it after making some changes in the database, the data report kepp on showing old values. I have tried refresh method of data report but it didnt solved the problem. plz help


saddysan

 

[BoonSiang]

You have to refresh the ADO Data Control (if you are this this control) or refresh the recordset (if you use Createobject method).

Below is the example i created. I have a data report called DataReport1, ADO Data Control called Adodc1.

Private Sub Command1_Click()

DataReport1.Show
' this line will refresh the data control. without this,
' your data report will not show the latest update.
Adodc1.Refresh
Set DataReport1.DataSource = Adodc1

End Sub

 

[Bruce007]

I was having the same problem and was
given solutions that helped but did not
correct it completly. Check out the message
submitted by Bruce007.

 

[iqbal21]

Just try this when u call your report
If deDailyRpt.rscmdDaily.State = 1 Then
deDailyRpt.rscmdDaily.Requery
Else
deDailyRpt.cmdDaily
End If
DailyRpt.Show